Forex Lens - RP Forex - Google Sheets

	A	B	C	D	E	F	G	H	I	K
1	Date	Forex Pair	Direction	Entry Price	Stop Loss	Take Profit 1	Result	Profit/Loss	Total P/L	Notes
2	06/05/2020	NZDUSD	Sell	0.5996	0.6029	0.59734	LOST	-35	-35.0
3	07/05/2020	EURUSD	Buy	1.08350	1.07933	1.08503	WON	15	-20.0
4	11/05/2020	NZDUSD	Sell	0.60678	0.60921	0.60425	WON	22.5	2.5
5	12/05/2020	GBPAUD	Buy	1.91113	1.9025	1.9130	LOST	-22.5	-20.0	USE 50% OF YOUR REGULAR POSITION SIZE
6	12/05/2020	AUDJPY	Sell	69.738	70.045	69.564	WON	17	-3.0
7	13/05/2020	EURCAD	Sell	1.52505	1.52985	1.52275	WON	23	20.0
8	13/05/2020	EURJPY	Sell	115.74	116.142	115.552	WON	19	39.0
9	14/05/2020	CHFJPY	Sell	109.985	110.52	109.722	WON	26	65.0
10	19/05/2020	USDJPY	Sell	107.782	108.150	107.523	WON	26	91.0
11	19/05/2020	USDCAD	Buy	1.3935	1.38885	1.39575	WON	22.5	113.5
12	21/05/2020	NZDUSD	Sell	0.61177	0.61556	0.60921	WON	25.6	139.1
13	22/05/2020	NZDJPY	Sell	65.779	65.530	66.355	WON	25	164.1
14	22/05/2020	USDCAD	Buy	1.39775	1.4000	1.39377	WON	22.5	186.6
15	26/05/2020	EURGBP	Sell	0.8883	0.8922	0.8860	LOST	-39	147.6
16	26/05/2020	USOIL	Sell	33.69	34.85	33.52	WON	17	164.6
17	26/05/2020	USDCAD	Sell	1.3785	1.3844	1.3760	WON	25	189.6
18	26/05/2020	EURAUD	Sell	1.6500	1.65789	1.6475	WON	25	214.6
19	28/05/2020	USDCAD	Sell	1.37520	1.38609	1.37296	WON	22.4	237
20	29/05/2020	EURUSD	Buy	1.11077	1.10575	1.1133	WON	25.3	262.3
21	01/06/2020	EURNOK	Sell	10.70639	10.9999	10.70303	WON	33.6	295.9
22	02/06/2020	CADJPY	Buy	79.4	78.609	79.651	WON	25.1	321
23	02/06/2020	EURNZD	Buy	1.77245	1.76504	1.77500	WON	25.5	346.5
24	02/06/2020	USOIL	Buy	36.6	35.42	37	VOID	0	346.5	Price not available
25	04/06/2020	GBPNZD	Sell	1.9535	1.96017	1.95072	WON	27.8	374.3
26	04/06/2020	GBPJPY	Buy	137.72	137.205	137.985	LOST	-30	344.3	Close half your position at -30 pips. Close the rest.
27	05/06/2020	GBPNZD	Sell	1.9461	1.95303	1.9435	WON	26	370.3
28	08/06/2020	EURNZD	Sell	1.72447	1.73406	1.72198	WON	24.9	395.2
29	09/06/2020	NZDJPY	Sell	70.67	71.345	70.405	WON	26.5	421.7
30	10/06/2020	USDCHF	Sell	0.9457	0.95409	0.9433	WON	24	445.7
31	10/06/2020	GBPUSD	Buy	1.2775	1.269	1.28055	WON	15.2	460.9	USE 50% OF YOUR REGULAR POSITION SIZE
32	10/06/2020	GBPUSD	Buy	1.2784	1.27205	1.2815	LOST	-31.8	429.1	USE 50% OF YOUR REGULAR POSITION SIZE
33	11/06/2020	AUDJPY	Sell	73.309	74.055	73.055	WON	25.4	454.5
34	11/06/2020	NZDJPY	Sell	68.744	69.755	68.505	WON	19.1	473.6	Reduce position size by 20%
35	18/06/2020	GBPCAD	Buy	1.70423	1.69995	1.70677	LOST	-8	465.6	Close GBPCAD -8 pips.
36	18/06/2020	GBPJPY	Buy	134.221	133.721	134.505	LOST	-50	415.6
37	18/06/2020	GBPUSD	Sell	1.24421	1.2535	1.24105	WON	31.6	447.2
38	18/06/2020	EURUSD	Sell	1.11967	1.12602	1.117	WON	26.7	473.9
39	22/06/2020	GBPAUD	Sell	1.8017	1.80801	1.79905	LOST	-12	461.9	Close this -12 pips.
40	22/06/2020	AUDCAD	Sell	0.9356	0.93727	0.933	WON	26	487.9
41	23/06/2020	EURUSD	Sell	1.13053	1.1355	1.1277	WON	28.3	516.2
42	25/06/2020	USDCHF	Buy	0.94895	0.9474	0.95021	LOST	-15.5	500.7
43	25/06/2020	EURAUD	Sell	1.63765	1.6422	1.63505	WON	26	526.7
44	26/06/2020	AUDUSD	Buy	0.6894	0.68604	0.692	LOST	-33.6	493.1
45	30/06/2020	XAUUSD	Buy	1782.155	1773	1785	WON	28.5	521.6
46	02/07/2020	GBPUSD	Sell	1.246	1.25216	1.2435	LOST	-61.6	460
47	02/07/2020	NZDUSD	Sell	0.6513	0.65405	0.64845	LOST	-27.5	432.5
48	07/07/2020	EURNZD	Buy	1.72177	1.7187	1.723429	EVEN	0	432.5	Close on entry
49	07/07/2020	EURJPY	Sell	121.205	121.635	120.935	LOST	-27	405.5
50	09/07/2020	USDCHF	Sell order	0.936	0.94058	0.93411	WON	18.9	424.4	Not triggered yet
51	10/07/2020	GBPUSD	Sell	1.25942	1.26685	1.25704	WON	23.8	448.2	Go with 70% of your regular position size
52	10/07/2020	AUDJPY	Sell	74.15	74.612	74	WON	15	463.2
53	13/07/2020	EURUSD	Sell	1.13601	1.13818	1.1335	WON	25.1	488.3
54	13/07/2020	EURJPY	Sell	121.8	122.055	121.63	WON	17	505.3
55	14/07/2020	NZDUSD	Sell	0.6518	0.65717	0.64975	LOST	-12	493.3	Close now for -12 pips. DXY is slipping
56	15/07/2020	EURCAD	Sell	1.54201	1.54706	1.5395	WON	25.1	518.4
57	21/07/2020	EURUSD	Buy	1.1515	1.1435	1.1542	WON	27	545.4
58	22/07/2020	GBPJPY	Sell	135.579	136.077	135.321	WON	25.8	571.2
59	22/07/2020	GBPJPY	Buy	136.558	135.975	136.7	LOST	-27	544.2	Close -27 pips
60	23/07/2020	EURCAD	Sell	1.55077	1.55475	1.54815	WON	26.2	570.4
61	24/07/2020	AUDUSD	Sell	0.70789	0.7126	0.7056	LOST	-47.1	523.3
62	27/07/2020	EURUSD	Buy	1.1775	1.16401	1.18	WON	20	543.3	Close EURUSD at 20 pips ✅ we will renter after Powell’s comments.
63	30/07/2020	EURUSD	Buy	1.1815	1.1722	1.184	WON	25	568.3
64	30/07/2020	USDJPY	Sell	104.715	105.189	104.485	WON	23	591.3
65	05/08/2020	EURUSD	Sell	1.1857	1.1917	1.1832	LOST	-60	531.3
66	05/08/2020	GBPUSD	Sell	1.3115	1.3175	1.309	LOST	-30	501.3	Go with half a position size please.
67	11/08/2020	EURCAD	Sell	1.5625	1.55964	1.57055	LOST	-80	421.3
68	13/08/2020	AUDJPY	Sell Stop	76.4	76.675	76.15	LOST	-28	393.3
69	13/08/2020	GBPUSD	Buy	1.30756	1.30325	1.31	WON	24	417.3
70	13/08/2020	EURUSD	Buy	1.1824	1.17678	1.18501	WON	26	443.3
71	13/08/2020	Gold	Buy	1954.155	1933	1960	WON	6	449.3
72	18/08/2020	EURJPY	Sell	125.55	125.988	125.305	LOST	-44	405.3
73	19/08/2020	GBPUSD	Sell	1.3126	1.31705	1.31	WON	26	431.3
74	19/08/2020	USDJPY	Buy	105.92	105.505	106.19	WON	19	450.3	Go with 70% of your regular position size.
75	19/08/2020	AUDUSD	Sell	0.72	0.72405	0.7177	WON	16	466.3	Go with 70% of your regular position size.
76	20/08/2020	USDCAD	Sell	1.318	1.328	1.3153	WON	27	493.3
77	24/08/2020	USDCAD	Sell	1.3226	1.32516	1.32	WON	26	519.3
78	26/08/2020	USDJPY	Sell	106.085	106.407	105.857	WON	23	542.3
79	01/09/2020	EURJPY	Sell	126.25	126.612	126	EVEN	0	542.3
80	02/09/2020	USDCAD	Sell	1.30412	1.30805	1.3015	LOST	-39	503.3
81	03/09/2020	CADJPY	Sell	80.95	81.287	80.6	WON	35	538.3
82	04/09/2020	NZDUSD	Sell	0.6695	0.67652	0.667	WON	25	563.3
83	04/09/2020	NZDJPY	Sell	71.033	71.674	70.76	WON	5	568.3	In minor profit, close here
84	08/09/2020	GBPUSD	Sell	1.2973	1.30455	1.2948	WON	25	593.3
85	09/09/2020	EURGBP	Sell	0.90762	0.91318	0.9052	LOST	-56	537.3
86	10/09/2020	GBPUSD	Sell	1.28487	1.293	1.28226	WON	26	563.3
87	17/09/2020	CADJPY	Sell	79.37	79.807	79.1	WON	27	590.3
88	17/09/2020	EURUSD	Buy	1.1822	1.776	1.18435	WON	21	611.3
89	23/09/2020	EURUSD	Sell	1.16829	1.1733	1.1655	WON	28	639.3
90	23/09/2020	GBPUSD	Sell	1.2724	1.27957	1.2695	WON	29	668.3
91	24/09/2020	USDCHF	Buy	0.92775	0.9214	0.93	WON	7	675.3	Close now at 7 pips profit
92	01/10/2020	EURNZD	Sell	1.76521	1.77065	1.7625	WON	27	702.3
93	08/10/2020	EURNZD	Sell	1.785	1.79054	1.7825	WON	25	727.3
94	08/10/2020	CADJPY	Sell	80.21	79.81	80.4	WON	5	732.3	Closing out at 5 pips profit
95	08/10/2020	NZDCAD	Sell	0.868	0.872	0.8655	LOST	-40	692.3
96	14/10/2020	AUDJPY	Sell	75.354	75.816	75.1	WON	25	717.3
97	15/10/2020	EURAUD	Sell	1.65075	1.65805	1.648	LOST	-73	644.3
98	20/10/2020	GBPAUD	Sell	1.83067	1.8361	1.8282	LOST	-54	590.3
99	21/10/2020	USDCAD	Sell	1.30905	1.31254	1.30655	LOST	-36	554.3
100	27/10/2020	USDCAD	Sell	1.31848	1.32136	1.31607	LOST	-29	525.3