New provider request: AAII Sentiment Data
Author: richard1000
Creation Date: 5/6/2017 6:42 PM
profile picture

richard1000

#1

5/6/2017 6:42 PM

American Association of Individual Investors (AAII) publishes a weekly survey of investor sentiment. The historical data from 1987 to present is here:

http://www.aaii.com/files/surveys/sentiment.xls

There is a good argument that this survey may be used as a contrarian indicator.

http://www.aaii.com/journal/article/is-the-aaii-sentiment-survey-a-contrarian-indicator

So any interest in making this data a part of WL Data Provider?

PS. The sentiment file has some statistical data attached to the end of sentiment data. Does this extra data make it difficult to extract the sentiment data?
profile picture

Eugene

#2

5/6/2017 7:13 PM

While I'll be working on adding support for AAII/AAII_SENTIMENT symbol to the Quandl static provider for a more convenient use, you could give our Excel static provider a try and import the XLS file directly. If you haven't worked with the provider before, I recommend you study its online guide in the Wiki.
profile picture

Eugene

#3

5/7/2017 7:37 AM

ETA for AAII support in Quandl provider is late May 2017. The sentiment data will be exposed as Named DataSeries (as with COT data).
profile picture

Eugene

#4

5/26/2017 9:49 AM

Richard, you may install (or update) the Quandl provider suite now:

Quandl static provider

The Quandl ticker you're interested in is AAII/AAII_SENTIMENT (with the slash). If you haven't used it before make sure to read its Online help in the Wiki first!
profile picture

WEALTHPRO25

#5

9/11/2017 9:26 PM

i updated quandal and i only get data upto june 1, 2017 but the update and the quandl web site shows data up to september 7, 2017 i am using AAII/AAII_SENTIMENT.

please help so i can data upto september 7, 2017 as per the website. thanks
profile picture

Eugene

#6

9/11/2017 9:56 PM

I've just checked and everything works: the data is downloaded up to 9/7/2017 and the Wiki code example renders expected output on the chart.
profile picture

WEALTHPRO25

#7

9/11/2017 10:03 PM

this is the chart i get with the Wiki code:
profile picture

Eugene

#8

9/11/2017 10:11 PM

Have you tried to right click and "Reload chart history"?
profile picture

WEALTHPRO25

#9

9/11/2017 10:16 PM

thank you now it works
profile picture

Eugene

#10

9/12/2017 7:02 AM

Glad to hear that.
profile picture

Eugene

#11

4/25/2019 10:28 AM

Look how the % of bears is at the yearly low now:



Capitulation and market top ahead?
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).