Actually it is a script you put it in the /experts/scripts folder.When you put it on the chart it executes and .Writes the files thats it.Nothing except the popup window appears on your chart informing you of the the progress.
Check your Mt4 folder and experts/files there you should have the files.
Each time you want to update you have to run the script again.
You could place it into the expert folder and load it from there put then you have it writing the files with every tick maybe with a sleep function would set it to execute at set times>

Really appreciate your help. Right I've put it in the Scripts folder and then I just dragged and dropped it onto a chart (is this how you do it?) and then an alarm bell rang saying 'local history files are being updated from the server'. However this bell is going off every few seconds.

When I opened up the excel sheet you kindly posted (with MT4 running in the background) and I clicked on one of the update buttons it displays an error message asking whether I want to debug the program.

I'm a little confused as to what the file does that you've sent me. Does it collate the data I want in an easier fashion (ie rather than exporting a csv file?) for excel to then import?

Thanks again,

Learning lots by the hour!

The beeping will stop as soon all files are created.

The update error is telling me that the files can't be located or are not created. Wndows Vista does write the files in a different location.

1 Do you use Windows Vista or XP?

2 Are you using interbank FX?
else the code in the script neeeds to be edited by removing the(m) after each currency nomination.

3 Are the csv files created in the expert/files folder ?

4 did you unzip the excel into the C: drive? it would make things easier otherwise all formulas in the excel need to be altered.

1. I use XP (I don't like Vista!)
2. I wasn't so have removed the "m's"
2. Yes the csv files are being created
4. Yes it is now unzipped into C: (no folder)

what do I do now?(!) The spreadsheet is only for the AUD/JPY

Dave

[quote=dgrspencer;203730]1. I use XP (I don't like Vista!)
2. I wasn't so have removed the "m's"
2. Yes the csv files are being created
4. Yes it is now unzipped into C: (no folder)

Ok, now you have a tool to create the files.Alter the script line 16 to the currencies you like to work with.In line 163 you change the amount of data for each time frame.Lin 40-45 47-53 take out the periodes you don't need and compile it.

re. excel
Yes it is only for one currency now you go and extend and copy the sheet and replace AUDJPY with the currency you like to add.Once you've done that and it doesn't work post it and I'll help you from there.

[quote=Forexcashman;203748]Great! I've done all of that - changed the codes to suit my set up and it now works. The files are being created. think I now have a problem with the spreadsheet. This is the command line in excel

='C:\Program Files\Interbank Fx Trader 4\experts\files\[ExportedAUDJPYmH1.csv]ExportedAUDJPYmH1'!B3

Now I've changed this to;

='C:\Program Files\MetaTrader 4\experts\files\[ExportedEURJPYH4.csv]ExportedEURJPYH4'!B3

So I've changed;
1. where my MT4 is
2. AUDJPY to EURJPY (as it's one of the pairs I've chosen to export)
3. removed the "m's"
4. the time scale - 4hours is one of my time frames so H1 changed to H4

When I do all of this I'm told that 'Excel cannot update one or more links in this work book' etc.

When I then go to Edit>Links I get into territory beyond my understanding - I really do appreciate your help.

What I am still slightly confused about is what I'm trying to achieve here. I think that, say for 4 hourly data, I will have to drag my script over a chart to get the data and then click on the macro button on the spreadsheet to update it all. This is fancy and cool and I want to be able to do it! However, it's only slightly more convenient than exporting all the historical data to a sheet as a csv file and then using that info. Am I missing something? The only realy irritating thing about exporting the history is I can't work out how to export a few candles worth of information so I end up with thousands of records.

Dave

='C:\Program Files\MetaTrader 4\experts\files\[ExportedEURJPYH4.csv]ExportedEURJPYH4'!B3

So your Broker's MT4 is only called MetaTrader 4. Usually they use There company name like Alpari or WHC.?

When I then go to Edit>Links I get into territory beyond my understanding - I really do appreciate your help.

Now you have to edit the entries in the Macro as well as it is still looking for interbank FX and for the H1 and D1 csv.

What I am still slightly confused about is what I'm trying to achieve here. I think that, say for 4 hourly data, I will have to drag my script over a chart to get the data and then click on the macro button on the spreadsheet to update it all. This is fancy and cool and I want to be able to do it! However, it's only slightly more convenient than exporting all the historical data to a sheet as a csv file and then using that info. Am I missing something?

If you require only the H4 of 1 currency then yes it is only slightly more convenient.

The only realy irritating thing about exporting the history is I can't work out how to export a few candles worth of information so I end up with thousands of records.

Can you be more specific I don't understand what your are trying to achieve?

I simply downloaded my MT4 from metaquotes.net.

What I am trying to achieve is a spreadsheet which automatically calculates 4hrly, daily, weekly and monthly pivots. Actually I don't use them directly for trading but I like to know where a position I may take fits into pivot points. I have conditionally formatted cells to light up colours when the price (I have a live price feed into the spreadsheet) gets within a certain number of pips.

I can export the history from MT4 (creates a csv file just as your script does) but I get the entire history within MT4 - thousands of candles worth of info. Obviously to calculate pivots I only need the most recent ones - hope that clears up what I was saying before.

However, having played around a bit I love the idea behind what your helping me with. Drag the script onto a chart (repeated ever 4 hours) then click on a macro button to automatically update my spreadsheet. This is a much slicker way!

Have I cleared things up a bit?

Continued thanks

Yes it did
With the script I gave you gets the amount of candles you require by altering the lines I pointed out. Just remember if run the script the most recent candle will have a closing price of the current price as it is not a close candle. It changes within the H4 timeframe each time you run the script.
In a way it does make your calculation dynamic if you lets say update every 2hours but I don't know if those change are significant for you calculation.
If you only want to consider closed candles then skip the first data in your excel update.
Btw did you get the changes to the Macro work out OK?

Another thing ,the script is written that way that it writes the files for the Currency and TF you altered the code to . You can put it on any chart and any TF of you MT4 t does not influence proper function of the script.

Thanks. I'd worked out that it doesn't matter what currency or time frame and the script works. It's a great tool.

OK, so here's where I'm at. I can run the script and, as it's supposed to, it creates a csv file in the experts>files folder. So where I'm now at is trying to get the macro function within the spreadsheet to work - ie get the information from these files.

I changed the file path and removed the "m's" but for some reason it isn't working. Well, nothing happens immediately - maybe I've changed the file path correctly but then when I click on the macro button it is incorrectly set.

I've tried starting from scratch and copying the excel command you use (but with my file path)

(my version)
='C:\Program Files\MetaTader 4\experts\files\[ExportedEURUSDD1.csv]ExportedEURUSDD1'!A1

but when I hit enter, a window appears saying "Update Values: ExportedEURUSDD1.csv" (the file I've linked it to) - I go to the location of this file but it doesn't appear. It only recognises actual excel files, lotus files or web pages.

So in short, I can't connect an excel file with the data and nor can I set the macro correctly! Just thought, is the line of code in excel dependent on a macro? ie do they need each other to work. Sorry I'm quite out of my depth!

Dave