Power query % help

[lokou90]

Good morning,

I am writing to you because I am completely blocked ! I have an array with formulas in Power Query ! The principle is simple :

Get the difference between "cash buy (achat comptant)" and "cash sell(vente comptant)" values ! There is a file in history and a graph.

I would like to add columns, like the following ↓ ;

- A column with the percentage of gain or loss.

- A column with the number of days elapsed or hours if it is less than one day since the purchase and resale.

- A column that calculates me the profit made in the day between the date of purchase and resale.

As in this picture ↓

there may be multiple purchase/resale movements for the same value and at the same date. If a value is purchased, it is not required to be sold yet.


The four columns does not work very well it seems to me ! I can't seem to load with more than 200 lines

Files exemples

I can't put the formulas back in Power Query, if someone can kindly help me, it would be really great !!!

 

[sandy666]

just refresh query or re-apply source file then refresh

Valeur	Code ISIN	Date Achat	Montant Achat	Date Vente	Montant Vente	Gain/Perte	% Gain/Perte	Durée détention	Gain/Perte / Jour
BAIDU 120 PW 06/21 UNICRDT BK	DE000UC1NEV0	06/11/2020	1,737.0000 €	10/11/2020	1,579.5000 €	- 157.50 €	-9.07%	5	- 31.50 €
CRYOPORT	US2290503075	12/11/2020	3,382.5600 €	16/11/2020	2,900.7000 €	- 481.86 €	-14.25%	5	- 96.37 €
SNAP 32.5 PW 06/21 UNICRDT BK	DE000UC1NRP4	09/11/2020	1,908.7500 €	12/11/2020	2,089.5000 €	180.75 €	9.47%	4	45.19 €
JAGUAR HEALTH INC	US47010C4096	17/11/2020	3,743.0000 €
SEANERGY MARITIME HOLDINGS	MHY737601945	17/11/2020	2,450.0000 €
PAYPAL HOL 250 CW 20 CTGM EUR	DE000KB60SU6	17/11/2020	5.8000 €
KELLOGG 80 CW 12/20 SG EFFEKT	DE000CL2F2Y6	17/11/2020	52.0000 €
GULFPORT ENERGY	US4026353049	16/11/2020	1,647.3600 €
CASTOR MARITIME RG	MHY1146L1092	16/11/2020	2,756.0000 €
TELIGENT	US87960W2035	10/11/2020	1,231.2000 €
SCWORX	US78396V1098	10/11/2020	1,204.5000 €
HIGH POINT RES RG	US43114K2078	10/11/2020	6,012.0000 €
BAUDAX BIO RG-WI	US07160F1075	10/11/2020	3,199.4500 €
BORR DRILLING RG	BMG1466R2078	10/11/2020	4,093.8600 €
WHITING PETROLEUM	US9663875089	09/11/2020	5,866.4100 €
NORTHERN OIL AND GAS	US6655313079	09/11/2020	750.8400 €
CREATD INC	US2252651078	09/11/2020	1,360.5400 €
ALPH C 2000 CW 12/20 SG EFFEKT	DE000SB438L7	05/11/2020	1,800.0000 €

 

[lokou90]

even when I refresh, after a while, the lines change format and it does not load the 500 lines... Also, I don't know if my last four columns are good in formulas ?

 

[sandy666]

History csv contain 36 rows (500?)
Result table you can see in post#3
I changed source path to my needs , refresh and it works

I can't say more until you change language to english, sorry

 

[lokou90]

new file 500

looking, I give you the file

 

[sandy666]

with updated source path

Valeur	Code ISIN	Date Achat	Montant Achat	Date Vente	Montant Vente	Gain/Perte	% Gain/Perte	Durée détention	Gain/Perte / Jour
ABBOTT LABORATORIES	US0028241000	18/09/2020	1,491.2800 €	22/09/2020	1,460.2000 €	- 31.08 €	-2.08%	5	- 6.22 €
ACCELERATE DIAGNOSTICS	US00430H1023	23/03/2020	428.4800 €	25/03/2020	466.2600 €	37.78 €	8.82%	3	12.59 €
ACE CONV UTS	KYG0083D1126	02/11/2020	2,398.3700 €	03/11/2020	2,392.8000 €	- 5.57 €	-0.23%	2	- 2.79 €
ACM RESEARCH CL A	US00108J1097	13/10/2020	2,335.5500 €	23/10/2020	2,008.8800 €	- 326.67 €	-13.99%	11	- 29.70 €
ACTIVISION 90 CW 20 SG EFFEKT	DE000SB1YYL1	13/08/2020	3,654.0000 €	01/09/2020	3,456.0000 €	- 198.00 €	-5.42%	20	- 9.90 €
ADDVANTAGE MEDIA GROUP	US0067433062	25/02/2020	979.4900 €	26/02/2020	857.6000 €	- 121.89 €	-12.44%	2	- 60.95 €
AKOUOS RG	US00973J1016	10/09/2020	606.5100 €	14/09/2020	607.2000 €	0.69 €	0.11%	5	0.14 €
ALPH C 2000 CW 12/20 SG EFFEKT	DE000SB438L7	07/09/2020	5,400.0000 €	05/11/2020	1,800.0000 €	- 3,600.00 €	-66.67%	60	- 60.00 €
ALPHA PRO TECH	US0207721095	28/02/2020	3,514.4900 €	05/03/2020	1,734.3100 €	- 1,780.18 €	-50.65%	7	- 254.31 €
ALPHABET CL A	US02079K3059	04/03/2020	5,466.9900 €	29/04/2020	5,389.7400 €	- 77.25 €	-1.41%	57	- 1.36 €
AMGEN 290 CW 12/20 SG EFFEKT	DE000SB2V398	02/09/2020	3,360.0000 €	09/10/2020	660.0000 €	- 2,700.00 €	-80.36%	38	- 71.05 €
AMGEN 300 CW 09/21 SG EFFEKT	DE000SB4YLH0	27/10/2020	3,185.0000 €	02/11/2020	2,210.0000 €	- 975.00 €	-30.61%	7	- 139.29 €
APPLE 162.5 CW 03/21 SG EFFEKT	DE000SB41XL8	12/10/2020	1,080.0000 €	13/10/2020	1,215.0000 €	135.00 €	12.50%	2	67.50 €
APPLE 420 CW 09/20 CTGM EUR	DE000KB48ZM3	10/07/2020	198.3200 €	14/07/2020	246.5600 €	48.24 €	24.32%	5	9.65 €
APPLE 450 CW 09/20 CTGM EUR	DE000KB58SG9	03/08/2020	7,335.0000 €	07/08/2020	8,550.0000 €	1,215.00 €	16.56%	5	243.00 €
ARCO PLATFORM-A RG	KYG045531061	21/05/2020	6,467.8400 €	01/06/2020	6,510.3900 €	42.55 €	0.66%	12	3.55 €
ASML 344.2 TS PERP GOLDMN OHG	NL0015339912	29/09/2020	555.0000 €	09/10/2020	447.0000 €	- 108.00 €	-19.46%	11	- 9.82 €
ATEME	FR0011992700	18/05/2018	1,119.3000 €	08/06/2020	769.6000 €	- 349.70 €	-31.24%	753	- 0.46 €
AXA 16 PW 12/20 CTGM EUR	DE000KB33RW1	31/07/2020	770.0000 €	03/08/2020	560.0000 €	- 210.00 €	-27.27%	4	- 52.50 €
BAIDU 120 PW 06/21 UNICRDT BK	DE000UC1NEV0	06/11/2020	1,737.0000 €	10/11/2020	1,579.5000 €	- 157.50 €	-9.07%	5	- 31.50 €
BAIDU 124.28 TL PERP BNPPI	FRBNPP020192	21/10/2020	951.5000 €	26/10/2020	946.0000 €	- 5.50 €	-0.58%	6	- 0.92 €
BANDWIDTH-A RG	US05988J1034	19/02/2020	1,763.9400 €	15/07/2020	2,890.7100 €	1,126.77 €	63.88%	148	7.61 €
BILL.COM HLDG RG	US0900431000	07/05/2020	3,529.0000 €	18/05/2020	3,800.6900 €	271.69 €	7.70%	12	22.64 €
BIOCEPT	US09072V4023	02/03/2020	2,020.9500 €	04/03/2020	2,358.0000 €	337.05 €	16.68%	3	112.35 €
BIOGEN	US09062X1037	26/03/2020	300.7000 €	30/03/2020	315.4700 €	14.77 €	4.91%	5	2.95 €
BIRKS GROUP	CA09088U1093	17/08/2020	3,699.3000 €	28/08/2020	2,967.8000 €	- 731.50 €	-19.77%	12	- 60.96 €
BORR DRILLING RG	BMG1466R2078	02/11/2020	3,481.6000 €	26/05/2020	3,190.8000 €	- 290.80 €	-8.35%	-159	1.83 €
BORR DRILLING RG	BMG1466R2078	10/11/2020	4,093.8600 €	02/11/2020	3,481.6000 €	- 612.26 €	-14.96%	-7	87.47 €
BOX	US10316T1043	26/05/2020	3,190.8000 €	29/05/2020	3,311.5500 €	120.75 €	3.78%	4	30.19 €
BRILLIANT ACQN UTS	VGG1643W1032	30/06/2020	310.9300 €	30/06/2020	311.5500 €	0.62 €	0.20%	1	0.62 €
CALAVO GROWERS	US1282461052	05/03/2020	1,905.7200 €	09/03/2020	1,809.4700 €	- 96.25 €	-5.05%	5	- 19.25 €
CALIX NETWORKS	US13100M5094	01/06/2020	552.2400 €	29/06/2020	540.5400 €	- 11.70 €	-2.12%	29	- 0.40 €
CERENCE RG-WI	US1567271093	22/06/2020	1,303.3800 €	06/07/2020	1,236.2700 €	- 67.11 €	-5.15%	15	- 4.47 €
COCACOLA 50 CW 12/20 SG EFFEKT	DE000CL5BZ43	10/08/2020	3,080.0000 €	03/09/2020	5,500.0000 €	2,420.00 €	78.57%	25	96.80 €
COCACOLA 60 CW 09/21 SG EFFEKT	DE000SB4Z585	15/10/2020	950.0000 €	21/10/2020	900.0000 €	- 50.00 €	-5.26%	7	- 7.14 €
COUPA SOFTWARE RG	US22266L1061	26/06/2020	827.1900 €	21/07/2020	909.6500 €	82.46 €	9.97%	26	3.17 €
CREATD INC	US2252651078	02/11/2020	1,347.5000 €	09/11/2020	1,360.5400 €	13.04 €	0.97%	8	1.63 €
CRWDSTRIK HLDG RG-A	US22788C1053	11/06/2020	3,860.8000 €	03/08/2020	4,547.2300 €	686.43 €	17.78%	54	12.71 €
DANONE 65 CW 12/20 CTGM EUR	DE000CP6QAZ8	20/07/2020	2,470.0000 €	28/07/2020	1,690.0000 €	- 780.00 €	-31.58%	9	- 86.67 €
DECKERS OUTDOOR	US2435371073	20/05/2020	651.8200 €	26/05/2020	736.8000 €	84.98 €	13.04%	7	12.14 €
DELL TECHNOLOGIES CL C	US24703L2025	13/10/2020	2,106.0300 €	19/10/2020	2,117.0200 €	10.99 €	0.52%	7	1.57 €
DOCUSIGN RG	US2561631068	31/03/2020	2,429.9100 €	06/10/2020	8,658.3900 €	6,228.48 €	256.33%	190	32.78 €
DOCUSIGN RG	US2561631068	22/10/2020	634.9800 €	31/03/2020	2,429.9100 €	1,794.93 €	282.68%	-204	- 8.80 €
DOMINO'S PIZZA	US25754A2015	06/10/2020	8,658.3900 €	08/10/2020	7,940.3800 €	- 718.01 €	-8.29%	3	- 239.34 €
DRAFTKINGS INC	US26142R1041	29/05/2020	3,256.3500 €	03/08/2020	2,791.4000 €	- 464.95 €	-14.28%	67	- 6.94 €
ELDORADO RESORTS	US28470R1023	01/04/2020	1,550.9200 €	11/06/2020	4,037.7200 €	2,486.80 €	160.34%	72	34.54 €
ELECTROMED	US2854091087	30/03/2020	3,241.0400 €	21/05/2020	3,478.5300 €	237.49 €	7.33%	53	4.48 €
ENDAVA ADS-A	US29260V1052	24/02/2020	3,780.0000 €	21/05/2020	3,285.8000 €	- 494.20 €	-13.07%	88	- 5.62 €
EQUINIX REIT	US29444U7000	24/02/2020	1,944.5400 €	03/06/2020	2,075.0700 €	130.53 €	6.71%	101	1.29 €
EVOKE PHARMA	US30049G1040	03/09/2020	3,975.0000 €	11/09/2020	3,817.5000 €	- 157.50 €	-3.96%	9	- 17.50 €
FACEBOOK 260 CW 09/20 CTGM EUR	DE000CP86MV9	03/08/2020	224.0000 €	07/08/2020	333.2000 €	109.20 €	48.75%	5	21.84 €
FACEBOOK 400 CW 03/21 BNPPI	NL0015059551	15/09/2020	735.0000 €	09/10/2020	637.0000 €	- 98.00 €	-13.33%	25	- 3.92 €
FACEBOOK CLASS A	US30303M1027	25/03/2020	8,409.5100 €	30/03/2020	8,614.9700 €	205.46 €	2.44%	6	34.24 €
FDX 320 CW 03/21 SG EFFEKT	DE000SB55XG8	14/10/2020	2,640.0000 €	30/10/2020	1,800.0000 €	- 840.00 €	-31.82%	17	- 49.41 €
FISERV INC	US3377381088	24/02/2020	2,098.4400 €	11/05/2020	1,851.1400 €	- 247.30 €	-11.78%	78	- 3.17 €
FSD PHARMA-B SV RG	CA35954B2066	30/10/2020	1,913.0900 €	03/11/2020	1,890.0000 €	- 23.09 €	-1.21%	5	- 4.62 €
FULGENT GENETICS	US3596641098	16/10/2020	7,123.9000 €	04/09/2020	4,500.0000 €	- 2,623.90 €	-36.83%	-41	64.00 €
FULGENT GENETICS	US3596641098	16/10/2020	1,435.9000 €	16/10/2020	7,123.9000 €	5,688.00 €	396.13%	1	5,688.00 €
GEN ELECTR 15 CW 20 SG EFFEKT	DE000CL2GYL2	04/09/2020	4,500.0000 €	29/10/2020	150.0000 €	- 4,350.00 €	-96.67%	56	- 77.68 €
GULFPORT ENERGY	US4026353049	26/10/2020	3,512.3200 €	16/11/2020	1,647.3600 €	- 1,864.96 €	-53.10%	22	- 84.77 €
HELEN OF TROY	BMG4388N1065	04/05/2020	655.9800 €	05/05/2020	662.2000 €	6.22 €	0.95%	2	3.11 €
IBIO	US4510332038	17/08/2020	2,002.6500 €	18/08/2020	2,002.6500 €	- €	0.00%	2	- €
ICLICK INTERACTIVE	US45113Y1047	08/06/2020	1,031.5600 €	26/06/2020	977.6900 €	- 53.87 €	-5.22%	19	- 2.84 €
INTEL 80 CW 12/20 BNPPI	NL0014173957	02/09/2020	8,000.0000 €	22/10/2020	800.0000 €	- 7,200.00 €	-90.00%	51	- 141.18 €
INTUIT	US4612021034	24/08/2020	2,323.0900 €	26/08/2020	2,408.8800 €	85.79 €	3.69%	3	28.60 €
IPSEN	FR0010259150	05/02/2019	225.9000 €	21/02/2020	132.0000 €	- 93.90 €	-41.57%	382	- 0.25 €
IROBOT	US4627261005	27/02/2018	1,202.7500 €	05/03/2020	811.7500 €	- 391.00 €	-32.51%	738	- 0.53 €
KELLOGG 80 CW 12/20 SG EFFEKT	DE000CL2F2Y6	28/08/2020	3,640.0000 €	17/11/2020	52.0000 €	- 3,588.00 €	-98.57%	82	- 43.76 €
LUMINEX	US55027E1029	19/08/2020	962.1000 €	24/08/2020	932.1000 €	- 30.00 €	-3.12%	6	- 5.00 €
LVMH	FR0000121014	05/03/2020	1,552.0000 €	01/04/2020	1,295.1000 €	- 256.90 €	-16.55%	28	- 9.18 €
MC DONALD'S CORP	US5801351017	30/04/2020	552.6200 €	05/05/2020	550.8000 €	- 1.82 €	-0.33%	6	- 0.30 €
MCDO 260 CW 03/21 SG EFFEKT	DE000SB55XJ2	14/10/2020	2,500.0000 €	30/10/2020	1,200.0000 €	- 1,300.00 €	-52.00%	17	- 76.47 €
MCDO214.5329TLPERPGOLDMN OHG	NLGS000025M6	16/10/2020	144.8000 €	28/10/2020	64.0000 €	- 80.80 €	-55.80%	13	- 6.22 €
MCKESSON	US58155Q1031	31/08/2020	2,143.8200 €	14/09/2020	2,115.9600 €	- 27.86 €	-1.30%	15	- 1.86 €
MERCADOLIBRE	US58733R1023	24/02/2020	3,505.0500 €	07/05/2020	3,734.6200 €	229.57 €	6.55%	74	3.10 €
METHODE ELECTRONICS	US5915202007	29/06/2020	675.8600 €	30/06/2020	685.5200 €	9.66 €	1.43%	2	4.83 €
MICRON TECHNOLOGY	US5951121038	18/09/2020	2,523.2500 €	21/09/2020	2,444.5000 €	- 78.75 €	-3.12%	4	- 19.69 €
NETFLIX457.874564TLPERPGOLDMN	NL0015341512	18/09/2020	2,160.0000 €	22/09/2020	2,790.0000 €	630.00 €	29.17%	5	126.00 €
NEUROCRINE BIOSCIENCES	US64125C1099	26/05/2020	862.1800 €	10/06/2020	836.1300 €	- 26.05 €	-3.02%	16	- 1.63 €
NEW ORIENTAL ED.TEC. REP 1 SHA	US6475811070	09/10/2020	5,291.2400 €	13/10/2020	5,320.5300 €	29.29 €	0.55%	5	5.86 €
NIKE CLASS B	US6541061031	04/03/2020	4,168.3500 €	23/04/2020	3,952.7400 €	- 215.61 €	-5.17%	51	- 4.23 €
NORTHERN OIL AND GAS	US6655313079	30/10/2020	1,947.4900 €	27/02/2018	9,811.6000 €	7,864.11 €	403.81%	-975	- 8.07 €
NORTHERN OIL AND GAS	US6655313079	09/11/2020	750.8400 €	30/10/2020	1,947.4900 €	1,196.65 €	159.37%	-9	- 132.96 €
NVIDIA	US67066G1040	27/02/2018	9,811.6000 €	02/03/2020	10,808.0000 €	996.40 €	10.16%	735	1.36 €
NVIDIA 650 CW 03/21 SG EFFEKT	DE000SB438S2	29/09/2020	1,764.0000 €	09/10/2020	2,010.4000 €	246.40 €	13.97%	11	22.40 €
NVIDIA500.15TLPERPGOLDMN OHG	NLGS000036H3	23/10/2020	1,739.5000 €	29/10/2020	1,011.5000 €	- 728.00 €	-41.85%	7	- 104.00 €
ONTRAK INC	US6833731044	07/08/2020	2,695.9300 €	17/08/2020	2,435.5100 €	- 260.42 €	-9.66%	11	- 23.67 €
OPGEN	US68373L3078	10/08/2020	2,842.4000 €	09/09/2020	1,641.6000 €	- 1,200.80 €	-42.25%	31	- 38.74 €
PAYPAL HOL 195 CW 20 CTGM EUR	DE000KB49C14	31/07/2020	5,320.0000 €	28/08/2020	6,790.0000 €	1,470.00 €	27.63%	29	50.69 €
PAYPAL HOL 205 CW 20 CTGM EUR	DE000KB48RZ2	20/07/2020	1,278.0000 €	23/07/2020	1,260.0000 €	- 18.00 €	-1.41%	4	- 4.50 €
PAYPAL HOL 250 CW 20 CTGM EUR	DE000KB60SU6	02/09/2020	3,712.0000 €	17/11/2020	5.8000 €	- 3,706.20 €	-99.84%	77	- 48.13 €
PFIZER	US7170811035	09/11/2020	4,935.6300 €	16/11/2020	4,737.5000 €	- 198.13 €	-4.01%	8	- 24.77 €
PFIZER 41 CW 09/20 CTGM EUR	DE000KA3XSP1	23/07/2020	3,261.2000 €	27/08/2020	31.0000 €	- 3,230.20 €	-99.05%	36	- 89.73 €
PFIZER 42 CW 03/21 CTGM EUR	DE000KB79D32	10/11/2020	1,575.0000 €	12/11/2020	750.0000 €	- 825.00 €	-52.38%	3	- 275.00 €
PHOENIX TREE HOLDI	US7191561015	27/10/2020	832.8400 €	08/09/2020	3,048.5500 €	2,215.71 €	266.04%	-48	- 46.16 €
PHOENIX TREE HOLDI	US7191561015	27/10/2020	3,138.6000 €	27/10/2020	832.8400 €	- 2,305.76 €	-73.46%	1	- 2,305.76 €
R1 RCM	US7493971052	08/09/2020	3,048.5500 €	20/10/2020	3,247.1000 €	198.55 €	6.51%	43	4.62 €
REKOR SYSTEMS	US7594191048	17/09/2020	1,778.5000 €	09/10/2020	1,537.5500 €	- 240.95 €	-13.55%	23	- 10.48 €
REPAY HOLDINGS RG-A	US76029L1008	24/06/2020	1,832.5100 €	21/07/2020	1,789.9100 €	- 42.60 €	-2.32%	28	- 1.52 €
REPRO MEDSYSTEMS	US7599101026	21/04/2020	890.5900 €	27/04/2020	856.8300 €	- 33.76 €	-3.79%	7	- 4.82 €
ROKU-A RG	US77543R1023	03/03/2020	1,253.7800 €	29/04/2020	1,343.4400 €	89.66 €	7.15%	58	1.55 €
SEANERGY MARITIME HOLDINGS	MHY737601945	17/11/2020	2,450.0000 €	09/11/2020	1,908.7500 €	- 541.25 €	-22.09%	-7	77.32 €
SEANERGY MARITIME HOLDINGS	MHY737601945	02/11/2020	1,892.0000 €	17/11/2020	2,450.0000 €	558.00 €	29.49%	16	34.88 €
SNAP 32.5 PW 06/21 UNICRDT BK	DE000UC1NRP4	09/11/2020	1,908.7500 €	12/11/2020	2,089.5000 €	180.75 €	9.47%	4	45.19 €
SOLAREDGE TECHNOLOGIES	US83417M1045	06/03/2020	2,234.3100 €	18/05/2020	2,139.5200 €	- 94.79 €	-4.24%	74	- 1.28 €
SONY CORP ADR	US8356993076	12/10/2020	2,393.7700 €	26/10/2020	2,424.0000 €	30.23 €	1.26%	15	2.02 €
SPARTANNASH COMPANY	US8472151005	26/05/2020	1,492.1200 €	22/06/2020	1,322.0300 €	- 170.09 €	-11.40%	28	- 6.07 €
SPHERE 3D	CA84841L3083	10/06/2020	824.0400 €	15/06/2020	750.0000 €	- 74.04 €	-8.99%	6	- 12.34 €
TAKE TWO INTERACTIVE SOFTWARE	US8740541094	14/10/2020	3,366.2000 €	20/10/2020	3,301.2000 €	- 65.00 €	-1.93%	7	- 9.29 €
TELSA 1900 CW 09/20 CTGM EUR	DE000KB57QU6	23/07/2020	1,815.0000 €	19/08/2020	2,115.0000 €	300.00 €	16.53%	28	10.71 €
TITAN PHARMACEUTCLS	US8883145075	26/10/2020	2,409.6000 €	28/10/2020	3,152.0000 €	742.40 €	30.81%	3	247.47 €
TOTAL SE	FR0000120271	23/03/2020	100.1400 €	25/03/2020	127.3000 €	27.16 €	27.12%	3	9.05 €
TRANE TECHNOLOGIES	IE00BK9ZQ967	19/10/2020	5,248.8000 €	20/10/2020	5,150.0800 €	- 98.72 €	-1.88%	2	- 49.36 €
TWILIO INC CLASS A	US90138F1021	04/02/2019	1,255.6500 €	14/09/2020	2,513.1700 €	1,257.52 €	100.15%	589	2.14 €
TWITTER 32.5 PW 20 UNICRDT BK	DE000UC16G40	09/09/2020	457.7000 €	23/09/2020	209.3000 €	- 248.40 €	-54.27%	15	- 16.56 €
UBISOFT ENTERTAINMENT	FR0000054470	20/03/2020	4,140.5000 €	25/03/2020	4,417.4000 €	276.90 €	6.69%	6	46.15 €
WALMART INC	US9311421039	19/05/2020	263.2000 €	26/05/2020	249.9100 €	- 13.29 €	-5.05%	8	- 1.66 €
WALT DISNEY COMPANY (HOLDING)	US2546871060	25/03/2020	814.8900 €	31/03/2020	807.4400 €	- 7.45 €	-0.91%	7	- 1.06 €
WESTERN DIGITAL CORPORATION	US9581021055	19/03/2020	3,222.5000 €	24/03/2020	3,872.5000 €	650.00 €	20.17%	6	108.33 €
WORKDAY CLASS A	US98138H1014	26/05/2020	2,193.5600 €	28/05/2020	2,419.1800 €	225.62 €	10.29%	3	75.21 €
ZOOM VIDEO COMMUNICATIONS CL A	US98980L1017	26/08/2020	2,931.1000 €	02/09/2020	4,367.6600 €	1,436.56 €	49.01%	8	179.57 €
JAGUAR HEALTH INC	US47010C4096	17/11/2020	3,743.0000 €
CASTOR MARITIME RG	MHY1146L1092	16/11/2020	2,756.0000 €
TELIGENT	US87960W2035	10/11/2020	1,231.2000 €
SCWORX	US78396V1098	10/11/2020	1,204.5000 €
HIGH POINT RES RG	US43114K2078	10/11/2020	6,012.0000 €
BAUDAX BIO RG-WI	US07160F1075	10/11/2020	3,199.4500 €
MODERNA RG64.416TLPERPVONTOBEL	DE000VP8M2H7	10/11/2020	2,445.0000 €
ARTELO BIOSCIENCES	US04301G2012	02/11/2020	1,222.0000 €
PROMETIC LIFE SCIENCES	CA53272L1031	30/10/2020	2,100.0000 €
SHIFTPIXY RG	US82452L2034	29/10/2020	1,375.5000 €
CELSION	US15117N5032	26/10/2020	2,432.0000 €
RENAULT 20.25 PW 20 UNICRDT BK	DE000UC14AE2	07/08/2020	420.7500 €
SNAP 30 CW 09/20 CTGM EUR	DE000KB57KK0	16/07/2020	660.0000 €

 

[sandy666]

duplicated post

 

[lokou90]

I don't understand, because when I load, on my side, I get

I do not understand, because when I load, on my side, I get this, after a few lines ↑ Have you changed a few things ? Also, the values are good according to you for % gain / loss, holding time etc... If so, could you send me the file according to your settings or if you have Russia to make changes, it would help me a lot

 

[sandy666]

Temps.rar

Compressed (zipped) Folder

1drv.ms

 

[lokou90]

before the 4 columns were set up, the loading was good ↓ I realized this little manipulation

this is incraoyble, because when I open the file, I stop here me: (! Isn't there a general setting that can block like that ?