How to feed price at a specific time automatically into Excel

Hi everyone,

I'm currently working on a small Excel dashboard but there is one problem so far:

I would like to measure the percentage gain or loss from a specific time of day, let's say 0:00 MT4 server time.

How do I get the price at 0:00 server time automatically into excel?

I am not a programmer, but the following method should work.

 

1. Find and use a period converter to (live) export price history to a csv file;
2. From within Excel (late version), add link to the exported csv file. (refresh interval can be designated)
3. Use vlookup function or VBA macro to find the desired feed.

Good luck.

Hi Samuri and thank you.

Don't know if I'm able to do this but I'll give it a try.

Just follow the steps to get the csv file(s) ready.

Use pips4life's wonderful indicator on your chart, set the periodmultiplier to 1, outputcsvfile to 2;



The csv file will be created and updated live in your mt4\mql4\files folder;


From Excel, choose data\import\from txt file and designate the file location and choose the import options;


That will do the main job for you.

Good luck.