Help with Script to export only current Daily Open prices.

[Trims]

Hi All
Just found this forum, really impressed with it. There's loads of good information and help to which I hope to contribute.

I am currently learning how to code ea’s, scripts and indicators for Empty4 but have just a basic understanding at the moment, studying some of the lesson I downloaded from here has helped.

I am looking for a script to pull the daily open price from Empty4 on to a CSV file for each currency pair I trade. I would like it all in one script, gathering the data of all the pairs requested at the same time and populating the spreadsheet in the same boxes each time I use the script in the new day, therefore overwriting the previous day’s price.

From this, I will update another spreadsheet on which I have a heat map for the pairs, showing how far they have moved up or down in the day, the % of move and the range the day. These calculations depend on inputting the Daily open each day. At the moment I have to do this manually which is ok but boring.

There are some other scripts which extract this data but not one which will overwrite the daily data for onward transmission. Any idea, if a scrip like this exists or could anyone help me in coding it.
Thanks

[dietcoke]

There are some other scripts which extract this data but not one which will overwrite the daily data for onward transmission. Any idea, if a scrip like this exists or could anyone help me in coding it.
Thanks

Post the script you've seen which most nearly does what you want and say exactly what it is you want it to do differently.

[Trims]

There are some other scripts which extract this data but not one which will overwrite the daily data for onward transmission. Any idea, if a scrip like this exists or could anyone help me in coding it.
Thanks

Post the script you've seen which most nearly does what you want and say exactly what it is you want it to do differently.

Hi Thanks for your reply.

This is the closest i have found to a script which would extract the data. Its from Currency Secrets. Not sure if I can put the link here though but credit to them for the script etc..

It extracts the data you choose (Daily in my case) to pre prepared individual spreadsheets of the choosen currencies. By just loading the script onto one chart it populates all the pre-prepared spreadsheets requested wtih historical data in CSV format.

What I would like is to do, is use the same type of script, ie one load on to one chart and it will download all that days open price to one workbook spreadsheet, showing the currency, date, time and daily open price. Each time it is modified it will overwrite the previous days data.

I'll then reference this spreadsheet in another workbook where a lot of the calculations are taken from the daily open price. Which currently I am inputting manually in the morning.

If posible I would like to be able to choose the time of the daily open price (ie London open) rather than brokers just so I can experiment which would give me the best results. But this is not essential.

I hope this make sence.

Anyhelp with this would be much apreciated. Thanks.

[dietcoke]

Hi Thanks for your reply.

This is the closest i have found to a script which would extract the data. Its from Currency Secrets. Not sure if I can put the link here though but credit to them for the script etc..

It extracts the data you choose (Daily in my case) to pre prepared individual spreadsheets of the choosen currencies. By just loading the script onto one chart it populates all the pre-prepared spreadsheets requested wtih historical data in CSV format.

What I would like is to do, is use the same type of script, ie one load on to one chart and it will download all that days open price to one workbook spreadsheet, showing the currency, date, time and daily open price. Each time it is modified it will overwrite the previous days data.

I'll then reference this spreadsheet in another workbook where a lot of the calculations are taken from the daily open price. Which currently I am inputting manually in the morning.

If posible I would like to be able to choose the time of the daily open price (ie London open) rather than criminals just so I can experiment which would give me the best results. But this is not essential.

Try this.

I've added an extern to choose the start time of your day.

[Trims]

Many thanks i'll give that a go.