JSON Code to Import Data from Stock Exchange API to Google Apps Script

Closed Posted 3 months ago Paid on delivery
Closed Paid on delivery

I am looking for assistance to write code that will pull stock market data from a public API and import it into Google Apps Script.

Specifically, I am after the FINRA Reg SHO Daily Short Sale Volume. This should be done through the JSON format. In addition, I need someone who understands how to utilize Google Apps Script. The data pulled and imported must be reliable and accurate, and guaranteed up-to-date.

The FINRA API Platform authentication and authorization scheme is based on OAuth 2.0.

OAuth 2.0 enhances security by replacing the use of long-lasting credentials with limited life span tokens, reducing the potential of exposing an API Credential.

The project can be divided into 2 parts (Source: [login to view URL]) :

(1) API client sends a POST request to the FINRA Identify Platform (FIP) using the API Client ID and API Client Secret associated with an API credential (created via the API Console) as a Basic Auth token in the Authorization Header. The API will then return an access_token to be used in (2) below.

(2) Use "access_token" returned from FIP (from part (1) above) as a Bearer token in the Authorization Header to retrieve the "Reg SHO Daily Short Sale Volume" to append into a Google Sheet as the right-most column each day.

Coding JSON Google Apps Scripts Programming Google Sheets

Project ID: #36680096

About the project

17 proposals Remote project Active 2 mos ago

17 freelancers are bidding on average $170 for this job


Hi there! As I have read, I see you need help writing code that pulls data from the stock market and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of exper More

$250 USD in 1 day
(17 Reviews)

Hi there, ★★★ Google Apps / Sheets / VBA Expert ★★★ 9+ Years of Experience ★★★ I've read requirements and ready to write code that will pull stock market data from a public API and import it into Google Apps Script.. More

$250 USD in 2 days
(8 Reviews)

Hi, I'm interested in your requirement. I have good experience of web development with Google Apps Scripts. I can do this authorization and get the data to sheets using Google Apps Script from the API. If you More

$125 USD in 1 day
(4 Reviews)

Hello cryptocommando32, We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on JSON, Coding, Programming, Google S More

$140 USD in 7 days
(2 Reviews)

we can do the task with required things, withing given time-frame and guidelines, with 100% satisfaction, as we are having experienced team.

$120 USD in 3 days
(4 Reviews)

Hello, I work full-time with Airbus and my main tech at work is Google Apps Script for Google Spreadsheets so I'm very comfortable with this subject and I'd love to work on these tasks. If you're interested, you can ch More

$120 USD in 1 day
(1 Review)

Hello, I am an experienced and skilled developer ready to assist you with your project. I can write the code you need to pull stock market data from the FINRA API and import it into Google Apps Script. Specifically, I More

$140 USD in 7 days
(0 Reviews)

Hello I read your project description and sure I can do this. I have a good knowledge of Google Apps Scripts, it is a cloud-based JavaScript platform that lets you integrate with and automate tasks across Google produc More

$150 USD in 2 days
(0 Reviews)

Hello, I understood the project but have few doubts, please text me so i can clear all my questions right away and to confirm my skills and expertise you can have a look to my profile

$300 USD in 5 days
(0 Reviews)