Quoting pinoytraderDislikedTo all,
here's a copy of the worksheet from Rex, I made some changes on the formula. i.e., corrected the range of cells for the calculation of the medians on the GBP sheet. Row inserted on the Data sheet for the current day will always be included in the calculations. Hope this helps.Ignored
By the way could you tell me what was the error on the range of cells for the calculation of the medians. I hope it was not a conceptual error on my part.
I am having some problems with getting the current price to upload on its own.
When I first open the file I get a couple of messages.
I first get a message saying "Remote data not accessible. Start application MT4.exe?"
I then click yes, and I get a second message:
"Cannot run MT4.exe The program or one of its components is damaged or missing"
However, MT4 is working fine.
Do you have a suggestion of how to get this to work?
Is it possible to have the current high and low of the day updated on its own in order to get range calculations?
As I said before, I like what you guys did to my spreadsheet.
Regards,