SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : General market lab and commentary
SPY 683.310.0%Nov 12 4:00 PM EST

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Robohogs who wrote (352)4/21/2016 8:24:44 AM
From: Robohogs  Read Replies (1) of 668
 
Note that May from the earlier graph is positive 23 of 34 years but the big negative bars during the 10s is what is killing it. I am not sure what to make of that.

I went back through the April monthly returns MANUALLY off the raw data set. As long as yahoo has the correct data, the returns are posted ARE correct. They seem to be a full 1% lower than data I have seen before. Strange. Dividends in one month of one quarter could not make more than 20-50 bps of difference.

Completing this for SPY, Nasdaq 100, QQQ, Nasdaq Comp, and/or bios now that I have formulas set up should be cakewalk. I am trying to get the pivot tables set up to simplify life. Alternatively, I can manually extract averages for say the full period and then reduce back for smaller timeframes. If I DO that before running the other series, it will be done as soon as I pull the data set down (15 seconds).

Jon
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext