Easy way to get latest information about the stocks you follow

The script allows you to get the latest Stock/MF/ETF information including last and current prices, day's range, 52 week range, beta coefficient, P/E ratio, earnings per share, earnings date, ex-dividend date and other miscellaneous information.

Inputs

The script allows following inputs:

1. Stock names - input the names of stocks you are looking for in case if you don't know corresponding stock symbol or looking for stock location on other exchanges.
2. Stock symbols - directly input stock symbols to get information about the specific stock.

You can directly input stock names or symbols from CSV file. Please keep values to input in first column.

Requirements

This script uploads the information directly to your google sheet, hence you need to get your Google API credentials JSON file from:

https://console.developers.google.com/apis/credentials

You can read more about API credentials here:

https://cloud.google.com/docs/authentication

Please place the credentials file in the same folder as the script.