Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following example shows  price, change, volume and last trade data based on these formulas: for price, =GOOGLEFINANCE(C2), where C2 is the stock symbol, =GOOGLEFINANCE(C2, "change"), =GOOGLEFINANCE(C2, "volume"), and =GOOGLEFINANCE(C2, "tradetime")Image Removed

...

The tabs at the bottom of the sheet are important. The reader will create different finance topic names for every tab you have.  Any hidden tabs will be ignored. Also sheets that have the prefix ! will be ignored. 

Like all Google Sheets, you may want to take advantage of the collaboration functionality to share the sheet and allow multiple people to contribute content.

...

After setup , open the Sheets tab and add the URL of the Google Sheet that contains the market data into the reader. You will be asked to authorize your Google account.Image Removed

...

When The Reader is run, it will map to this (these) Google Sheets and pull the content into the Chameleon Finance module. More information about the Chameleon Finance module can be found here: Financials

...