Refrigerator Bulls and Bears
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
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
Last Updated
33
5-Nov-2019
34
License
35
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).
36
Acknowledgements
37
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.
38
39
Update History
40
11-Nov-2019
Fixed error in CPI-U calculation for each month when new data is not available.
41
5-Nov-2019
Initial Release baseline, it was in work and on the site since the 1st though. I consider it stable now.
Loading...