liveBook · Manning

Google Sheet

As explained in Investing for Programmers

Google Sheets is a cloud-based spreadsheet service for creating, storing, and collaboratively editing tabular data.

Google Sheets is a cloud-based spreadsheet workspace for collecting, storing, filtering, visualizing, and collaboratively editing portfolio data. It turns exported holdings into worksheets that expose values, yields, gains, losses, and asset distribution. section 6.0 section 6.2

A portfolio-monitoring workflow uses Google Sheets to:

  • Store stock reference data with tickers, share counts, position values, yearly yields, and potential gains or losses. section 6.2
  • Summarize total asset value and yield while grouping assets by type for distribution analysis. section 6.2
  • Receive exported DataFrames and display live Google Finance values alongside values captured at export time. section 6.5.1

Exporting a stock worksheet

A Python workflow authenticates with a protected JSON key, selects a worksheet, and writes column headers plus DataFrame values. It can then add GOOGLEFINANCE formulas using each ticker and the row’s share count, allowing live position values to be compared with exported values. section 6.5.1

Figure 6.3 A reference example of the Google Sheets worksheet with stock information
figure

Inspect the worksheet layout showing stock information, filterable columns, position metrics, and live values. section 6.2

Figure 6.4 Overview worksheet with assets grouped by value (USD column) and passive income (Yield column)
figure

Inspect the overview layout showing asset values, passive income, and asset-type distribution. section 6.2

How Investing for Programmers covers it

How deep it goes
Combines worksheet design with Python export and live formulas, while deferring detailed access-setup guidance to external instructions.
Examples
Uses stock worksheets, asset overviews, exported DataFrames, currency-converted values, and live GOOGLEFINANCE formulas.
What it assumes
Assumes Python and tabular DataFrame familiarity, while requiring learners to configure permissions and protect an authentication JSON key.
What you can do after
Operate Google Sheets through gspread to export portfolio tables and add live position-value formulas.
How it connects
Links portfolio management with DataFrames, Google Finance, currency conversion, authentication, and asset allocation.

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Investing for Programmers. The section links point to the parts of the book it draws on.