I am no expert in expert Excel. I hope someone can help me. I have a spread sheet that has 5 min price data. My goal is to ignore all time frame and extract only first hour (9:30 -10:30) High and and low. (First hour range)I am basically trying to come up with a formula for first hour range on Excel spread sheet. Column A = Date B= Time C=Open D= High E=Low F=Close I will appreciate any help. Thank you.
PM me for my email address. If you can email me your xls sheet with about 5 days of data I can put some calcs in to extract the data. I think it'll take a few columns of calcs to extract.
Smili my email address is sayeed@cox.net. If you can kindly send me your email adress I can email the data. I have never posted anything in Elitetrader. Let me try to upload the data anyway. Thank you.
this is a misplaced thread. I didn't know which is a correct thread for this. For future can you tell me. Thank you.
technical analysis or maybe strategy. this is for Automated Trading, and you are asking a question that does not seem related to completely automised and mechaic trading. at least i assume that ...