Technical Analysis Spreadsheets

There's a discussion of Bollinger, Moving Averages, MACD, VMA, EMA, DMI, VDX, maybe FBI, CIA   HERE.


Note: These spreadsheets may change (dramatically) without notice.
It's jest too much work to keep changin' the pictures, below.
Hopefully, the changes make 'em better ... not worser.

Then, too, some may not work with certain versions of Excel %$#^@!

Name
spreadsheet (probably) looks (something) like this
Click on the picture for a BIGGER picture
1

Monte Carlo
the Full Monte

an Explanation

2

MC Final

pick a
Final
portfolio.
Will you make it?

an Explanation

3

sensible MC

sensible
withdrawals!

an Explanation

4

Portfolio Theory

Efficient
Frontier

an Explanation

5

Another Frontier

Frontiers
(again)

an Explanation

6

Distributions

Normal? Lognormal?
What is it?

an Explanation

See also:

Distributions

7

Options

probability
of winning?

an Explanation

8

VDX

ADX with
volume weighting

an Explanation

9

MACD

and Bolli-bands
and EMAs
and ADX/VDX ...

an Explanation

10

DOWNLOAD
DATA

if you want to download stock data,
do your own analysis,
play with Bolli-bands,
play with Fibonacci ...

about Fibonacci

11

MC-2

selecting various
Indexes
(or is it Indices?):

What's best
(in the past!)

an Explanation

12

DDM

Dividend Discount
... pricing stocks

an Explanation

13

Averages

Moving Averages
... the best choice?

an Explanation

14

Rebalancing

When's best
... to rebalance?

an Explanation

15

WAVES

a Wave Theory
... maybe.

CLICK!
for a cartoon

an Explanation

16

Download

get stock data
to play with

no Explanation needed :^)

17

Allocations

how to allocate

an Explanation

18

Sectors

switching sectors

Sector Rotation

19

Kelly Ratio(s)

how much to invest?

the Kelly Ratio

20

VaR

What's the risk?

Value at Risk

21

Golden Ratios

Growth versus Value

Golden Ratios

22

Bolli Stuff

Predicting Stock Prices

Bolli Bands

23

CAPM

Capital Asset Pricing Model

CAPM

24

Spearman

Rank Correlation

Spearman Rank Correlation

25

gRANK

Magic Ratios

gRANK etc.

26

DCA

DCA vs All-at-once

DCA stuff

Remember !!!

RIGHT-click on the Name and Save Target or Save Link to download a ZIPd spreadsheet:

You may be able to find descriptions/tutorials about the spreadsheets.
Just to go to gummy_stuff ... then search for "spreadsheets"
Most spreadsheets have a link to the associated tutorial ... maybe.

Note:

All of my spreadsheets can be found here.