ABCDEFGHIJKLMN
1
Introduction to the Bull and Bears Spreadsheet.
2
3
Background
4
See this page for what and why:
5
https://www.gebele.com/charts-and-graphs/bulls-n-bears
6
7
Daily Sheet
8
Daily uses a recent history model to look at highs and lows using googlefinance().
9
The problem is that I need to manually set "final/official" highs/lows, otherwise the limited (60 days) look back will eventually fill up.
10
Secondly, due to the fact that if a high is set on a date,
11
I still need to manually verify that low after the high is set since googlefinance does not provide timestamps for the daily high and low.
12
By default for Intraday lows on days with a new high, the low of the day equals the closing
13
A manual review may change the result, but closing is a good default start and shouldn't be too confusing.
14
For Closing lows, on days with a new high, high=low for that day by definition since we only have one reading per day.
15
16
[Intraday|Closing] Bulls-Bears
17
These are the messy tabs that create the history, data points, CPI adjustments and documents my setting for each Secular period.
18
Note, currently these tabs are clones of each other with the only difference being the intraday vs. close setting in cell A47 and the filter on Column C
19
20
[Intraday|Closing] Real Index Report
21
These are the summary reports taking data from the detailed bull-bear tabs and the Daily to present in a tabular form.
22
Note, currently these tabs are clones of each other with the only difference being what tab they reference.
23
24
[Intraday|Closing] Real Index Chart
25
These are the graphical charts used to show the history.
26
27
CPI-U History
28
This tab creates a history of the CPI-U for doing an inflation adjustment against the index. The logic is overkill for this spreadsheet, but I stole it from another project.
29
30
Author
31
Alan J. Gebele (alan@gebele.com)
www.gebele.com/chart-and-graphs
32
License
33
I have been too lazy to put a license on this work, but intend to provide anyone with free right to use/adapt/customize, just give credit for original work, and links back (think Creative Commons Attribution).
34
Acknowledgements
35
A post from DonIce inspired me to make a program/sheet. Thanks to Ed Yardeni (yardeni.com) for excellent tables that summarize bulls and bears since the Great Depression.
36
37
Update History
38
31-Mar-2020
Updated Daily to a much simpler model that uses long history. Should be faster/more reliable queries to google service.
39
11-Nov-2019
Fixed error in CPI-U calculation for each month when new data is not available.
40
5-Nov-2019
Initial Release baseline, it was in work and on the site since the 1st though. I consider it stable now.