Google Sheets within The Trade Archives
Instructions
-
Make your Google Sheet public (support.google.com)
-
Make sure you have the required columns (see methods below)
-
Determine Entry Method
Each row is a trade (Simple)
Each row is a buy/sell (Complex)
Simple Method
The assumption is that every trade is all-in all-out (you buy 100 shares and then sell 100 shares). Here are the column names you need.
Required Columns:
- Ticker => string
- Date => date format
- Close Date => date format
- Size => number
- Avg Buy => number
- Avg Sell => number
- Trade Type => must be 'long' or 'short'
Optional Columns:
- Time=> hh:mm
- Close Time' => hh:mm
- Plan => text
- Results => text
- Vehicle => must be either 'share', 'call', or 'put' default is 'share'
- Strike => number
- Expiration => date
- Trigger Price=> number
- Target Price => number
- Stop Price => number
- Strategy => text
- RValue => number
- Interval => options: 1, 5, 10, 15, 30, 60, 240, or D
- Image => comma seperated image URLs
Complex Method
Each row is an individual buy/sell. Here are the column names you need.
Required Columns:
- Ticker => string
- Date => date format
- Price => number
- Size => number
- Action => must be 'buy' or 'sell'
- GroupID => number that indicates which rows are grouped
Optional Columns:
- Time=> hh:mm
- Plan => text*
- Results => text*
- Vehicle => must be either 'share', 'call', or 'put' default is 'share'
- Strike => number
- Expiration => date
- Trigger Price=> number*
- Target Price => number*
- Stop Price => number*
- Strategy => text*
- RValue => number*
- Interval => options: 1, 5, 10, 15, 30, 60, 240, or D*
- Image => comma seperated image URLs*
*only needed on first buy/sell of group
