FX Blue is a fantastic tool to monitor your forex portfolio on MT4 or MT5. I show you some beginner steps to create your own portfolio. Google sheets is then used to show you some advanced functions to automate your portfolio monitoring.
Here is the portfolio used as an example in this video : https://www.fxblue.com/users/demo_20230303/portfolio
Google Sheets Formulas
Formula to get the Balance & Equity (Cell A2 contains “lf_demo1”)
=transpose(query((arrayformula(substitute(IMPORTHTML(concatenate("https://www.fxblue.com/users/",A2,"/"),"table",1),"+",""))),"select Col2"))Formula to get Monthly and Weekly stats (Cell A2 contains “lf_demo1”)
=importdata("https://www.fxblue.com/users/demo_20230303/csv")Formula to get all the transactions into sheet “trades”
=transpose(query((arrayformula(substitute(IMPORTHTML(concatenate("https://www.fxblue.com/users/",A2,"/"),"table",3),"+",""))),"select Col2"))Formula to get the total closed profits for the past month grouped by fxblue account, and magic number.
=query(trades!A:Y, "select W, U, sum(O) where A = 'Closed position' and K > date '2023-02-01' group by W, U")Fxblue : https://www.fxblue.com/
Sample Google Sheets : https://lisaforex.com/fxblueformulas
Spy Tool : https://lisaforex.com/spytool
