Google Sheets Automation for LEAP Options Screener with Barchart, Google Finance, – Upwork

I need a Google Sheets expert to automate a LEAP options screener using data from Barchart and Google Finance. The goal is to create a dynamic spreadsheet where I can input stock tickers, and the sheet will automatically retrieve and populate various financial data points from these sources and perform specific calculations.

Project Requirements:

1. Google Sheets Setup:
• The sheet will have the following headers in the first row:
• Ticker
• Company Name
• Put-Call Ratio
• Buy/Sell Rating
• 52-Week High
• 52-Week Low
• Current Price
• Resistance Level 1
• Resistance Level 2
• Resistance Level 3
• Financial Strength
• Growth Rank
• 10-Year Annualized Return
• Free Cash Flow
• Final Recommendation (Call/Put)
• Strike Price
• Expiration Date
• Stop Loss
2. Data Retrieval:
• Barchart:
• Automatically retrieve and populate the following data based on the stock ticker:
• Put-Call Ratio
• Buy/Sell Rating
• Resistance Levels
• Financial Strength
• Growth Rank
• 10-Year Annualized Return
• Free Cash Flow
• Google Finance:
• Automatically retrieve and populate the following data:
• Company Name
• Current Price
• 52-Week High
• 52-Week Low
3. Automation:
• Develop a Google Apps Script that automates the retrieval of data from Barchart and Google Finance. The script should run whenever I input a new ticker symbol or when manually triggered.
4. Calculations:
• Calculate the Final Recommendation (Call/Put) based on specific criteria using Put-Call Ratio and Buy/Sell Rating.
• Calculate Strike Price, Expiration Date (6 months from the current date), and Stop Loss with predefined formulas.
5. Documentation:
• Provide clear instructions on how to use and maintain the sheet, including how to add more tickers and trigger the automation.

Deliverables:

• A fully functional Google Sheet with automated data retrieval and calculations.
• A brief guide explaining how to use and maintain the sheet.

Skills Required:

• Experience with Google Sheets and Google Apps Script
• Ability to integrate data from Barchart and Google Finance
• Familiarity with financial data, especially options trading

Posted On: August 18, 2024 23:15 UTC
Category: Financial Analysis & Modeling
Skills:Financial Analysis, Forecasting, MATLAB, Company Valuation, Google Sheets, Google Apps Script, Automation, Python

Skills: Financial Analysis, Forecasting, MATLAB, Company Valuation, Google Sheets, Google Apps Script, Automation, Python
Country: USA

click to apply