Myfxbook history in Excel

Mar 15, 2017 at 07:28
3,669 Visualizações
4 Replies
Membro Desde Feb 20, 2017   1 posts
Mar 15, 2017 at 07:28
Hey guys.

I know I can export it to CSV and I can work on it to turn in a proper information, but anyone already did that? Anyone can share a macro or something?

Thank you.
Membro Desde Apr 18, 2017   718 posts
Jul 25, 2017 at 06:52
No, I didn’t try it yet! But I am sure, it’s possible!
Membro Desde Feb 12, 2016   427 posts
Aug 03, 2017 at 11:19
Yes, this is possible and you can do it as long as you are good with Macros. If you are not - no way you can, so go out there and search for someone good with Macros on Excel to help you install it on your PC :)
Accept the loss as experience
Membro Desde Nov 21, 2011   1718 posts
Aug 03, 2017 at 13:19 (editado Aug 03, 2017 at 13:27)
I can make macro at work...
Please provide the script that extracts data from MT4
Then what is your need... or I will build macro on my own view to consolidate data

Edited: Oh from myfxbook... Ok, i'll do that this afternoon
Membro Desde Nov 21, 2011   1718 posts
Aug 03, 2017 at 15:25
Here we go:
copy the sheet 'statement' into the file.
Then run the macro.
You have to set columns I, N & O as nomber in couple of clicks
Go to Sheet 'Dashboard' right click on tab and click 'Refresh Data'
You have to adjust your own parameters.
You can also build your own dashboard.

Hope it helps

Cheers

Anexos:

O tópico está bloqueado
*Uso comercial e spam não serão tolerados, podendo resultar no encerramento da conta.
Dica: Postar uma imagem/URL do YouTube irá incorporá-la automaticamente no seu post!
Dica: Insira o sinal @ para preencher automaticamente um nome de utilizador que participe nesta discussão.