A Yahoo Finance API Custom Function for Google sheets. This function can return any data or statistics for yahoo finance stocks. Options support currently in development

• =yfinance usage & modules
• =yfinance_history usage

1. on your sheet go to tools -> Script Editor
2. Create new script and copy function.gs to it
3. Once saved it should be ready for use

the ticker according to yahoo finance of the stock you want to get data from Example: "AAPL", "TD.TO"

• =yfinance(ticker,modules,header)
• =yfinance("AAPL","{'assetProfile':[]}",true)

Every stock has modules of data returned by yahoo finance Each module has submodules (ex. peRatio) and you can specify these in an array or leave an empty [] array to return all submodules returning all submodules may mess up formatting slightly Format: "{'module1':['subModule1','subModule2'], 'module2':[]}" (DONT use doublequotes for modules and submodules)

• =yfinance("AAPL","{'price':['marketCap'],'earnings':[]}",false)

Include data headers using true/false

• =Yfinance(ticker,modules,true)

not all stocks contain the same modules/submodules so formatting errors may occur due to this. Some submodules have their own submodules (ex. insiderTransactions) which will be put as a JSON string in a cell and may by over the max cell char limit of google sheets.

the ticker according to yahoo finance of the stock you want to get data from Example: "AAPL", "TD.TO"

the interval between data points returned One of:

• "1m", "2m", "5m", "15m", "30m", "60m", "90m", "1h", "1d", "5d", "1wk", "1mo", "3mo"

period 1 is the start date for data returned and period 2 is the end date Date Format: YYYY-MM-DD Date format w/ time: YYYY-MM-DDTHH-MM-SS (don't change T)

the stock events you want historical data on Format: Array "['dividends','splits']"

• dividends
• capitalGain
• splits

Show headers for data true/false

Costco Quarterly w/ Dividends:

• =yfinance_history("COST","3mo","2000-01-01","2021-01-01","['dividends']",true)

Tesla Price on 2018-01-10

• =yfinance_history("TSLA","1d","2018-01-10","2018-01-11","[]",false)