How much would that set you back?Well, Nada! Courtesy of Google.This post will guide you through coding a simple Tactical Asset Allocation on Google’s Docs.
1. A Google account.
2. Google Docs.The system is similar to Faber’s TAA model using 5 Etfs.: SPY,TLT,VNQ,EEM,DBC
We buy or sell at the beginning of the month ONLY.
If Close > 200-moving Average then we buy the ETF.
If Close < 200-moving Average then we sell the ETF.
If TodayIsNewMonth AND CloseETF>MA(200) Then Buy
If TodayIsNewMonth AND CloseETF<MA(200) Then Sell
Let’s get started. Go to Google Docs and create a new SpreadSheet. Call it TAA_5.
Once the spreadsheet is open in your browser, go up to the menu and select Tools–>Script Editor…
This should open a new script Editor. Select “SpreadSheet” as your project.
Lets start coding.
It would be nice to create an object that holds all the ETF information.
So here’s the function to store each ETF’s info:
So let’s show all this info on the Spreadsheet.
Now you can go on the top Menu and select a function to run. Select “ShowTAAOnSpreadsheet”.
Press the “paly” button to run.
Go to the spreadsheet, see if it updated.
Please do not abuse Google’s Servers by having it run too often. They are kind enough to provide this kind of functionality free of charge.