9 Replies Latest reply on Apr 8, 2016 6:32 AM by Andrew Connolly

    How to identify the open and closing trade each day

    Eleanor Green

      I have a very large dataset of trades.

       

      I need to be able to identify the price of the opening and closing trade for each day to create a calculated field that I can then use to make candlestick charts. This seems like it should be a fairly common requirement but I can't find an easy answer.

       

         

      PRICEDEAL_TIMEDeal description
      2502/01/2015 07:31German
      2602/01/2015 07:35German
      3002/01/2015 08:35German
      3102/01/2015 09:27German

       

       

      Thanks very much in advance