Custom Stock Formulas

in Formulas
The first Buycel formulas you should familiarize yourself with are the custom stock formulas


Stock Value Function

  • Syntax: =STOCK(ticker, year, quarter, key)
  • Returns a value from the STOCK database.


Stock Latest Value Function

  • Syntax: =STOCK_LATEST(ticker, key)
  • Returns the most recent value from the STOCK database for a given key.


Stock Relative Value Function

  • Syntax: =STOCK_REL(ticker, key, period)
  • Returns the most recent value from the STOCK database for a given key.

 


After you make these selections, you will be the cell will populate with information pulled from the company SEC financial statements.


Get started building your model!
Demo


Legal Notice – Buycel does not make recommendations or offer investment advice of any kind and is not responsible for the accuracy of data provided by external data sources. Please review our legal policy for further details.