Historic Alpha (gjiiglonnibgjpegmdodpgkihfpcgkgk): For stocks traded at NYSE, NASDAQ, and AMEX: * Analyze Financials Statements * Get End-of-day (EOD) * Browse News... Read More > or Download Now >
Historic Alpha for Google Sheets
Tech Specs
- • Type: Google Sheets Add-on
- • Latest Version: 6
- • Price: Freeware
- • Offline: No
- • Developer: patternchain.com
User Reviews
- • Rating Average
- 1 out of 5
- • Rating Users
- 3
Download Count
- • Total Downloads
- 0
- • Current Version Downloads
- 0
- • Updated: August 15, 2017
Historic Alpha is a free Business Tools Add-on for Google Sheets. You could download the latest version crx file and install it.
More About Historic Alpha
=BalanceSheet(ticker, fiscalYear)
ticker - Enter stock ticker.
fiscalYear - Enter fiscal year .
Example: =BalanceSheet("MSFT","2012") - Returns Microsoft Balance Sheet from 10-K of fiscal year 2012
=IncomeStatement(ticker, fiscalYear)
ticker - Enter stock ticker.
fiscalYear - Enter fiscal year .
Example: =IncomeStatement("MSFT","2012") -; Returns Microsoft Income Statement from 10-K of fiscal year 2012
=Cashflow(ticker, fiscalYear)
ticker - Enter stock ticker.
fiscalYear - Enter fiscal year .
Example: =Cashflow("MSFT","2012") - Returns Microsoft Cashflow Statement from 10-K of fiscal year 2012
=EOD(ticker, startDate, endDate)
ticker - Enter stock ticker.
startDate - Enter *since* when you need EOD information about ticker.
endDate - Enter *until* when you need EOD information about ticker.
Example: =EOD("MSFT", "2012-11-01","2017-05-01") - Returns Ticker EOD information for every day the market was open during specified period.
=NewsOnStock(ticker)
ticker - Enter stock ticker.
Example: =NewsOnStock("MSFT") - Returns the latest news on Microsoft from local newspapers and from specialized media.