phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

Simple Financial Google sheets add-on with Google APP Script

  • Posted:
  • Proposals: 19
  • Remote
  • #4362846
  • Open for Proposals
Hansini P.Volodymyr D.Asif H.Peter C.MD Foysal hosssain O. + 14 others have already sent a proposal.
  • 4

Description

Experience Level: Expert
I am looking for a developer to create a Google Sheets add-on that enables users to enter a stock symbol and retrieve relevant financial data via a third-party API. The goal is to streamline access to financial information and enable dynamic stock evaluation and ranking within Google Sheets.


When the user opens the add-on, When the user opens the add-on, a custom dialog box or sidebar appears. Here, users can input a stock symbol or other parameters. As they type, the system provides auto-suggestions for valid stock symbols and available data types, helping streamline the input process. The financial data is then retrieved via the third-party API and displayed in the spreadsheet—no need for users to manually enter Google Sheets functions.

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Aditya M.

    Hi Janos,

    To ensure the add-on matches your needs perfectly:

    (1) API Source
    - Do you have an active subscription with FinancialModelingPrep or AlphaVantage, or should we use free-tier APIs with limited calls ?
    - This affects data depth, for example 10+ years for CapEx ratios versus trailing 12 months data.

    (2) Stock Ranking Logic
    - For the EV/FCF score, which method works best:
    - Linear scoring where lower EV/FCF equals higher score
    - Tiered thresholds like EV/FCF below 15 as "A", 15-25 as "B"
    - This will align the template with your evaluation method.

    (3) Auto-Suggestions
    - Should symbol suggestions use NASDAQ/NYSE listings or a custom watchlist ?

    Excited to work on this - please share your preferences !

    Best,
    Aditya Maisuriya