AAII Sentiment Data

Optuma Forums Optuma General Discussion AAII Sentiment Data


Viewing 1 post (of 1 total)
  • Author
  • #66449
    • Topics: 67
    • Replies: 705
    • Posts: 772

    The AAII Investor Sentiment Survey has become a widely followed measure of the mood of individual investors. The weekly survey results are published in financial publications including Barron’s and Bloomberg and are widely followed by market strategists, investment newsletter writers and other financial professionals.

    Whilst we don’t have the data available in our database, if this data is important to you then it can be imported in to Optuma from .csv text files. To do this save and extract the four files in the attached .zip folder to a suitable location on your system (such as Documents/Optuma).

    To import the data click on Data > Import Local Data and click the 3 dots to navigate to the saved AAII Sentiment Data folder, and Import.


    You will then be able to open the weekly Bullish, Bearish, and Neutral survey values from the imported folder (AAIIBULL, AAIIBEAR, and AAIINEUT). Save and open the .owb workbook file attached to open these charts:

    AAII Histogram

    AAII Line

    Updating the Data

    The survey data is updated every Friday and available from the AAII website, so to update the charts open the three .csv files (preferably in Notepad, as Excel can change the date formatting) and enter the latest values. Save and close the .csv file, and then reopen the charts in Optuma and they will be updated (there’s no need to reimport the files).

    • This topic was modified 1 month ago by Darren.
    1 user thanked author for this post.
Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest