Bloomberg historical data field: average volume

Discussion in 'Trading' started by Maverick2608, Oct 7, 2022.

  1. Every ticker.
     
    #11     Oct 7, 2022
  2. newwurldmn

    newwurldmn

    It didn't work for me either apparently.

    I would try HELP HELP.
     
    #12     Oct 7, 2022
    Maverick2608 likes this.
  3. Peter8519

    Peter8519

    Sorry, I misunderstood what you want. You want the 30 days average volume of all stocks. It's possible to do it with any charting software. All charting software is capable of scanning the database.
    1. Sum the volume of each ticker symbol for a period 30 days from a start to end date and dump to a text file.
    2. Use a script(either python or java) and sort the text file by date
    3. For each date, sum the volume and divide by the number of observations
    4. Result is in time series of total average volume
     
    Last edited: Oct 7, 2022
    #13     Oct 7, 2022
    Maverick2608 likes this.
  4. Peter8519

    Peter8519

    #14     Oct 7, 2022
  5. Unfortunately Bloomberg confirmed that the variable is not historically available despite being indicated as "historical" in the system. However, it can be programmed within Bloomberg for Excel.
     
    Last edited: Oct 8, 2022
    #15     Oct 8, 2022
  6. newwurldmn

    newwurldmn

    that sucks.
     
    #16     Oct 8, 2022