EA Forex Academy – Algorithmic & Manual Trading Courses › Forums › Forex Trading Forum › Historical data converted to number of bars
- October 7, 2020 at 11:08 #62322
I just created this spreadsheet converting historical data to number of bars.
Might be useful to some 😉October 9, 2020 at 11:08 #62745
That is interesting! I did something similar for one of my courses but yours looks better.
However, there is something important I realized with the time. And it is simple.
Why should we look for 5 years on H1 and on M15?
In your table, it is very clear that on M15 we have +160k bars and on H1 we have +40k bars. That is 4 times fewer bars which is logical because 1 hour has 4 x 15 min.
So is 1 kilo of cotton heavier or 1 kilo of iron? 🙂
If EA Studio works great on 40k bars for H1 then you should be using 40k bars for M15 as well.
What I am saying is that IT IS the number of bars that matters, not the time period.October 9, 2020 at 11:30 #62767
It’s the number of bars that matters, but the numbers in my table are based on 100% bars e.g. weekends & holidays included.
According to my calculations, if I deduct roughly 29% (28.87%) from the number of bars, then I’m left with the actual number of bars delivered by Dukascopy.
Thank you for your feedback.October 9, 2020 at 11:55 #62778
I get your point! Good job!
Cheers,October 9, 2020 at 14:53 #62811
Updated to (roughly) the actual number of bars (without weekends nor holidays):
October 11, 2020 at 15:32 #63130
Looks better. But tell me what is your idea behind it? What is your goal?October 11, 2020 at 15:41 #63133
My goal is to quickly convert bars into period of time. When I say quickly, I mean without the need to go into EA Studio and upload data (and then clean up) to see them converted. I’m sure I’m close to making an excel formula that does the job. Not sure if it’ll be useful. Sometimes I waste time on something that turns useful sometimes not. I’m not trying to share rubbish. Just trying to share what I see is probably useful.October 11, 2020 at 22:18 #63140
I get your point, and nothing shared in the Forum is rubbish. As far as it is useful, I accept it. Anyway, I would delete the topic 🙂
Why don’t you use the Data Horizon?
When you go to Data – Datta Horizon, you can set whatever period you wish, and the bars are immediately displayed in the Editor:October 11, 2020 at 22:24 #63141
Sure Petko. Delete it by all means. It’s not as useful as I thought.
Sometime I’d like to delete my stupid post myself but don’t know how or whether it’s allowed lol.
Thanks.October 14, 2020 at 9:07 #63288
No need to delete the posts, Asser. They are always useful to the new students.
- You must be logged in to reply to this topic.