icon of Alpha Vantage

Alpha Vantage

Get realtime and historical stock and currency data

Connect
icon of Alpha Vantage
Track stocks with Slack alerts Editor
Track stocks with email alerts Editor

Get the most out of Alpha Vantage!

Connecting Alpha Vantage with Rows gives you the power to track realtime and historical stock, FX, and cryptocurrency data using the Alpha Vantage Stock Market API, all in a spreadsheet.

Use cases

Things you can do when using Alpha Vantage with Rows include:

  • Retrieve realtime stock data.
  • Retrieve realtime exchange rates for any pair of digital currency (e.g. Bitcoin) and physical currency (e.g. USD).
  • Returns lists of equities and market data by company name, symbol, or keyword.
  • Retrieve realtime and historical daily, weekly, monthly and intraday stock data.
  • Retrieve realtime bid and ask prices for physical currency (Forex) pairs.
  • Retrieve realtime and historical sector performances calculated from S&P500 incumbents.

Categories

About Alpha Vantage

Alpha Vantage provides stocks, ETFs, mutual funds, forex, and cryptocurrency data feeds that conform to stock API standards and best practices. Its APIs are grouped into four categories; Stock Time Series Data, Physical and Digital/Crypto Currencies, Technical Indicators, and Sector Performances. All APIs are realtime and the latest data points are derived from the current trading day.

alphavantage.co
FX_ALPHAVANTAGE

Get the real-time rates for an FX or Cryptocurrency pair.

FX_DAILY_ALPHAVANTAGE

Get the daily time series of an FX pair (timestamp, open, high, low, close).

FX_INTRADAY_ALPHAVANTAGE

Get the intraday time series for an FX pair (timestamp, open, high, low, close).

FX_MONTHLY_ALPHAVANTAGE

Get the monthly time series of an FX pair (timestamp, open, high, low, close).

FX_WEEKLY_ALPHAVANTAGE

Get the weekly time series of an FX pair (timestamp, open, high, low, close).

GET_BALANCE_SHEET_ALPHAVANTAGE

Get annual and quarterly balance sheets of a company for the last 5 years. This data is generally refreshed on the same day a company reports its latest earnings and financials.

GET_CASH_FLOW_ALPHAVANTAGE

Get annual and quarterly cash flows of a company for the last 5 years.

GET_COMPANY_OVERVIEW_ALPHAVANTAGE

Get company information, financial ratios, and other key metrics for the equity specified. This data is generally refreshed on the same day a company reports its latest earnings and financials.

GET_INCOME_STATEMENT_ALPHAVANTAGE

Get annual and quarterly income statements of a company for the last 5 years. This data is generally refreshed on the same day a company reports its latest earnings and financials.

SECTOR_ALPHAVANTAGE

Get the real-time and historical sector performances of the S&P500.

STOCK_ALPHAVANTAGE

Get the latest global quote for an equity.

STOCK_DAILYADJUSTED_ALPHAVANTAGE

Get the daily adjusted time series (open, high, low, close, volume) of an equity.

STOCK_DAILY_ALPHAVANTAGE

Get the daily time series (open, high, low, close, volume) of an equity.

STOCK_INTRADAY_ALPHAVANTAGE

Get the intraday time series (open, high, low, close, volume) of an equity.

STOCK_MONTHLYADJUSTED_ALPHAVANTAGE

Get the monthly adjusted time series (open, high, low, close, volume) of an equity.

STOCK_MONTHLY_ALPHAVANTAGE

Get the monthly time series (open, high, low, close, volume) of an equity.

STOCK_SEARCH_ALPHAVANTAGE

Search for equity data using a company name or symbol.

STOCK_WEEKLYADJUSTED_ALPHAVANTAGE

Get the weekly adjusted time series (open, high, low, close, volume) of an equity.

STOCK_WEEKLY_ALPHAVANTAGE

Get the weekly time series (open, high, low, close, volume) of an equity.

Alpha Vantage content to help you get started!

Guides

Other resources