Ms Excel

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

  1. mkhan1900

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

    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

    mkhan1900

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

    man

    this is a misplaced thread.
     
  5. mkhan1900

    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

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