MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE IF NOT EXISTS `STOCK_DATA_TRANSPOSED` (
  `id` int(6) unsigned,
  `Date` Date NOT NULL,
  `Name` varchar(200) NOT NULL,
  `Price` varchar(200) NOT NULL,
  `Timestamp` datetime NOT NULL
) DEFAULT CHARSET=utf8;
INSERT INTO `STOCK_DATA_TRANSPOSED` (`id`, `Date`, `Name`, `Price`, `Timestamp`)
VALUES (NULL, '2019-12-31 00:00:00', 0x4d4d4d, '176.4199981689453', '2021-05-01 17:47'),
       (NULL, '2020-01-02 00:00:00', 0x4d4d4d, '180', '2021-05-01 17:47'), 
       (NULL, '2020-01-03 00:00:00', 0x4d4d4d, '178.4499969482422', '2021-05-01 17:47'), 
       (NULL, '2020-01-06 00:00:00', 0x4d4d4d, '178.6199951171875', '2021-05-01 17:47'), 
       (NULL, '2020-01-07 00:00:00', 0x4d4d4d, '177.89999389648438', '2021-05-01 17:47'),
       (NULL, '2019-12-31 00:00:00', 0x534f, '63.70000076293945', '2021-05-01 17:47'), 
       (NULL, '2020-01-02 00:00:00', 0x534f, '62.619998931884766', '2021-05-01 17:47'), 
       (NULL, '2020-01-03 00:00:00', 0x534f, '62.560001373291016', '2021-05-01 17:47'), 
       (NULL, '2020-01-06 00:00:00', 0x534f, '62.810001373291016', '2021-05-01 17:47'), 
       (NULL, '2020-01-02 00:00:00', 0x534f, '62.619998931884766', '2021-05-01 17:47'),(NULL, '2019-12-31 00:00:00', 0x4f505454, '0.8700000047683716', '2021-05-01 17:47'), (NULL, '2020-01-02 00:00:00', 0x4f505454, '0.8799999952316284', '2021-05-01 17:47'), (NULL, '2020-01-03 00:00:00', 0x4f505454, '0.8399999737739563', '2021-05-01 17:47'), (NULL, '2020-01-06 00:00:00', 0x4f505454, '0.8600000143051147', '2021-05-01 17:47'), (NULL, '2020-01-07 00:00:00', 0x4f505454, '0.8500000238418579', '2021-05-01 17:47'),(NULL, '2020-01-02 00:00:00', 0x5257452e4445, '26.959999084472656', '2021-05-01 17:47'), (NULL, '2020-01-03 00:00:00', 0x5257452e4445, '26.84000015258789', '2021-05-01 17:47'), (NULL, '2020-01-06 00:00:00', 0x5257452e4445, '26.450000762939453', '2021-05-01 17:47'), (NULL, '2020-01-07 00:00:00', 0x5257452e4445, '27.049999237060547', '2021-05-01 17:47'), (NULL, '2020-01-08 00:00:00', 0x5257452e4445, '27.170000076293945', '2021-05-01 17:47');
CREATE TABLE IF NOT EXISTS `user_portfolio` (
  `ID2` int(6),
  `Date2` Date,
  `Name2` varchar(200) NOT NULL,
  `Price2` varchar(200) NOT NULL,
  `User_ID` int(6) unsigned
) DEFAULT CHARSET=utf8;
INSERT INTO `user_portfolio` 
        (`ID2`, `Name2`, `Date2`, `Price2`, `User_ID`) 
VALUES (NULL, 'SO', '2021-05-18 17:47:46', '64.44000244140625', '1'), 
        (NULL, 'RWE.DE', '2021-05-17 17:48:01', '32.119998931884766', '1'),
        (NULL, 'OPTT', '2021-05-17 18:40:12', '2.140000104904175', '1'), 
        (NULL, 'MMM', '2021-05-18 19:31:05', '205.11000061035156', '1'),
        (NULL, 'SO', '2021-05-18 17:47:46', 64.44000244140625, 2);
select
  sdt.Name,
  up.Date2 as 'Purchase Date',
  up.Price2 as 'Purchase Price',
  up.User_ID,
  sdt.`Date` as 'Closing Date',
  sdt.Price as 'Closing Price',
  concat((sdt.Price - up.Price2) / up.Price2 * 100, '%') as Diff
from `STOCK_DATA_TRANSPOSED` sdt
join user_portfolio up on up.name2 = sdt.name
where up.user_id = 1
order by `sdt`.`Date` asc, sdt.Name desc;


Name
Purchase Date
Purchase Price
User_ID
Closing Date
Closing Price
Diff


SO
2021-05-18
64.44000244140625
1
2019-12-31
63.70000076293945
-1.1483576201594075%

OPTT
2021-05-17
2.140000104904175
1
2019-12-31
0.8700000047683716
-59.34579616259745%

MMM
2021-05-18
205.11000061035156
1
2019-12-31
176.4199981689453
-13.987617549623424%

SO
2021-05-18
64.44000244140625
1
2020-01-02
62.619998931884766
-2.824338051781376%

SO
2021-05-18
64.44000244140625
1
2020-01-02
62.619998931884766
-2.824338051781376%

RWE.DE
2021-05-17
32.119998931884766
1
2020-01-02
26.959999084472656
-16.064757219807685%

OPTT
2021-05-17
2.140000104904175
1
2020-01-02
0.8799999952316284
-58.87850691152031%

MMM
2021-05-18
205.11000061035156
1
2020-01-02
180
-12.242211757413598%

SO
2021-05-18
64.44000244140625
1
2020-01-03
62.560001373291016
-2.9174441292498%

RWE.DE
2021-05-17
32.119998931884766
1
2020-01-03
26.84000015258789
-16.438352910577294%

OPTT
2021-05-17
2.140000104904175
1
2020-01-03
0.8399999737739563
-60.74766670109253%

MMM
2021-05-18
205.11000061035156
1
2020-01-03
178.4499969482422
-12.997905310699847%

SO
2021-05-18
64.44000244140625
1
2020-01-06
62.810001373291016
-2.5294863537557366%

RWE.DE
2021-05-17
32.119998931884766
1
2020-01-06
26.450000762939453
-17.65254781287318%

OPTT
2021-05-17
2.140000104904175
1
2020-01-06
0.8600000143051147
-59.81308541367459%

MMM
2021-05-18
205.11000061035156
1
2020-01-06
178.6199951171875
-12.915023847855792%

RWE.DE
2021-05-17
32.119998931884766
1
2020-01-07
27.049999237060547
-15.78455748263226%

OPTT
2021-05-17
2.140000104904175
1
2020-01-07
0.8500000238418579
-60.28037466475175%

MMM
2021-05-18
205.11000061035156
1
2020-01-07
177.89999389648438
-13.266055595971727%

RWE.DE
2021-05-17
32.119998931884766
1
2020-01-08
27.170000076293945
-15.410955853666215%

Name	Purchase Date	Purchase Price	User_ID	Closing Date	Closing Price	Diff
SO	2021-05-18	64.44000244140625	1	2019-12-31	63.70000076293945	-1.1483576201594075%
OPTT	2021-05-17	2.140000104904175	1	2019-12-31	0.8700000047683716	-59.34579616259745%
MMM	2021-05-18	205.11000061035156	1	2019-12-31	176.4199981689453	-13.987617549623424%
SO	2021-05-18	64.44000244140625	1	2020-01-02	62.619998931884766	-2.824338051781376%
SO	2021-05-18	64.44000244140625	1	2020-01-02	62.619998931884766	-2.824338051781376%
RWE.DE	2021-05-17	32.119998931884766	1	2020-01-02	26.959999084472656	-16.064757219807685%
OPTT	2021-05-17	2.140000104904175	1	2020-01-02	0.8799999952316284	-58.87850691152031%
MMM	2021-05-18	205.11000061035156	1	2020-01-02	180	-12.242211757413598%
SO	2021-05-18	64.44000244140625	1	2020-01-03	62.560001373291016	-2.9174441292498%
RWE.DE	2021-05-17	32.119998931884766	1	2020-01-03	26.84000015258789	-16.438352910577294%
OPTT	2021-05-17	2.140000104904175	1	2020-01-03	0.8399999737739563	-60.74766670109253%
MMM	2021-05-18	205.11000061035156	1	2020-01-03	178.4499969482422	-12.997905310699847%
SO	2021-05-18	64.44000244140625	1	2020-01-06	62.810001373291016	-2.5294863537557366%
RWE.DE	2021-05-17	32.119998931884766	1	2020-01-06	26.450000762939453	-17.65254781287318%
OPTT	2021-05-17	2.140000104904175	1	2020-01-06	0.8600000143051147	-59.81308541367459%
MMM	2021-05-18	205.11000061035156	1	2020-01-06	178.6199951171875	-12.915023847855792%
RWE.DE	2021-05-17	32.119998931884766	1	2020-01-07	27.049999237060547	-15.78455748263226%
OPTT	2021-05-17	2.140000104904175	1	2020-01-07	0.8500000238418579	-60.28037466475175%
MMM	2021-05-18	205.11000061035156	1	2020-01-07	177.89999389648438	-13.266055595971727%
RWE.DE	2021-05-17	32.119998931884766	1	2020-01-08	27.170000076293945	-15.410955853666215%