Ms Excel

M

mkhan1900

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.
 
Quote from mkhan1900:

this is a misplaced thread.



I didn't know which is a correct thread for this. For future can you tell me.

Thank you.
More...
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 ...
 
You must log in or register to reply here.
Back
Top