Tracking Stocks in Google Sheet

One minute read
trading • sheets

Generate CSV reports

$ ./generate-csv-reports.sh 2>&1 | grep "Exporting report"

Combine all reports

$ python3 combine-all-csvs.py

Paste into Google Sheet

image

Re-arrange and apply formulas

Last Close: =GOOGLEFINANCE(C3,"price")
Current Code: =G3*E3
TV Link: =HYPERLINK(CONCATENATE("https://www.tradingview.com/chart/?symbol=", C3), C3)
Chart: =sparkline(googlefinance(C3,"price",today()-30,today()))
Profit Loss: =I3-H3