Bloomberg historical data field: average volume

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

  1. I cannot seem to find a Bloomberg historical data field: average volume.

    Of course I can draw 3 months volume and calculate the average. But if you have 100,000 data entries - stocks at different dates, it would require a massive amount of data to calculate the figure across the 100,000 entries (100,000 times 60 trading days.) It would be much easier to just use a data field to draw average volume for a particular stock at a particular date.

    Anyone see a solution to that problem?
     
    murray t turtle likes this.
  2. newwurldmn

    newwurldmn

    are these not retreivable historically?

    upload_2022-10-7_6-7-52.png
     
    Repoguy likes this.
  3. Peter8519

    Peter8519

    You need a stock charting software e.g. Metastock, NinjaTrader or Amibroker just to name a few. You will also need a data source e.g. free Yahoo Finance daily data. NinjaTrader is a freeware if you don't need live trading. I personally use Amibroker. It has a companion software(AmiQuote) for downloading data from paid or free source. It's a paid software. Be warned that the learning curve is steep. User support via forum. Those who know programming will be easier.

    This is the script to plot the 60days moving average for volume.
    Plot( MA(Volume, 60), "3month MA", colorBlue, styleThick);
    Ticker = A, daily volume in histogram, blue line is 60 days moving average
    A-volume.jpg
     
    murray t turtle likes this.
  4. Thank you. I believe it is not a historical data field. I will check.
     
  5. Thank you. I does not look practical across 100,000 entries. It looks more suitable to study individual stocks.
     
  6. newwurldmn

    newwurldmn

    I think there are a lot of data fields they say aren’t historical but are if you feed it a date value.
     
  7. Oh, I did not know that. I will check. Thank you.
     
  8. %%
    Good points.
    I use but not limited to IBD newspaper charts+ website;
    any stock or ETFs with 50 day average daily volume \
    + average weekly volume......... Some paid, some free ;but free is not unlimited #of symbols
     
  9. I checked. The "VOLUME_AVG_30D" is actually indicated as "historical," but unfortunately returns: #N/A N/A
     
    murray t turtle likes this.
  10. newwurldmn

    newwurldmn

    what ticker?
     
    #10     Oct 7, 2022