Ms Excel

Discussion in 'Automated Trading' started by mkhan1900, Sep 23, 2007.

  1. 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
    D= High

    I will appreciate any help.

    Thank you.
  2. smili


    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.
  3. mkhan1900


    Smili my email address is

    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.
  4. man


    this is a misplaced thread.
  5. 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.
  6. man


    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 ...