Yahoo Finance Data in Google Sheet

Google Apps Script
Interested in purchasing this script? Contact me
Yahoo Finance summary

SUMMARY

This Google Apps Script pulls daily stock quotes from the Yahoo Finance API. It stores the data in a Google Sheet for historical look-ups. The script updates a summary sheet by calculating today's price change in dollars and percentage.

Get Yahoo Finance data

A Google Sheet serves as a repository for historical stock prices.

Every stock ticker has a column. Every row represents the market close data for a given date.

sheet
Yahoo Finance code

Automated API processing

An Installable Trigger launches a Google Apps Script that fetches daily stock prices for a customized list of stock tickers after market close.

The script avoids data duplication by comparing the API date with the last date stored in the sheet: it either appends a new data row or updates the last row's data.

Summary dashboard

A summary sheet includes calculated metrics that uses the historical data, such as difference in prices between yesterday and today.

The user can update the sheet manually at any time using a custom menu option.

Yahoo Finance Summary
Technologies and libraries in project
Google Apps Script
GAS Triggers
Google Spreadsheet Service
Yahoo Finance API
Interested in purchasing this script? Contact me
RELATED CASE STUDIES

The project involved pulling information about YouTube channels and their videos and playlists, using the YouTube Data API. A Google Apps Script was built to take an arbitrary number of channel IDs, get their metadata, and then iterate through their videos and playlists and get their own metadata.

All information is to be pulled into a Google Sheet.

This project involves parsing addresses in a Google Sheet along with their metadata. A Google Apps Script is launched via a custom menu. It creates a sidebar with a Google Map, converts the addresses into lat/long data points, centers the map according to the addresses, and displays the addresses as markers on the map.

Address metadata is shown when the user hovers over the marker. The map can be viewed in full-screen mode.

The client needed a Chrome extension, which his team would use to mark their website pages for scraping. A Google Apps Script accepts the extension's page requests, scrapes the web page, and saves the data in a Google Doc based on a template.

This Google Apps Script queries the Twitter API, pulling data about tweets and followers into a Google Sheet, which is synched with a Google Data Studio report.

This project embeds a Calendly form on a Google Apps Script web app page. Calendly can be pre-filled with data if the user is a returning customer. When the user completes the registration, a Calendly webhook calls the web app end point, which updates a Google Sheet with the registration data.

This Google Apps Script looks for new IP addresses that are entered in a Google Sheet. The script validates each IP address, triggers a call to a Geo lookup API, and updates a different sheet with geographical data, such asa city, state, and internet service provider.

This Google Apps Script pulls new entries from a Google Sheet in real-time. It uses a Zapier webhook to insert new to-do tasks into an Asana project. The payload includes a mix of standard and custom Asana fields. The script updates the sheet with Zapier IDs to eliminate duplicate inserts.