Integration spotlight: AlphaVantage

Overview

Our AlphaVantage integration is basically you’re one-stop-shop for any information you need about Foreign Exchange (FX) rates or stock prices. Don’t believe us? Just check out the plethora of functionality our integration brings to the table :wink:.

Make sure to check the allowed physical currencies and digital currencies.

Functions

Function Description
FX

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.
FX_INTRADAY_ALPHAVANTAGE Get the intraday time series for an FX pair.
FX_WEEKLY_ALPHAVANTAGE Get the weekly time series of an FX pair.
FX_MONTHLY_ALPHAVANTAGE Get the monthly time series of an FX pair.
Stock Market Close Time Series

STOCK_DAILY_ALPHAVANTAGE Get the daily time series of an equity.
STOCK_INTRADAY_ALPHAVANTAGE Get the intraday time series of an equity.
STOCK_MONTHLY_ALPHAVANTAGE Get the monthly time series of an equity.
STOCK_WEEKLY_ALPHAVANTAGE Get the weekly time series of an equity.
Stock Adjusted Time Series

STOCK_DAILYADJUSTED_ALPHAVANTAGE Get the daily adjusted time series of an equity.
STOCK_MONTHLYADJUSTED_ALPHAVANTAGE Get the monthly adjsuted time series of an equity.
STOCK_WEEKLYADJUSTED_ALPHAVANTAGE Get the weekly adjusted time series of an equity.
Other

STOCK_ALPHAVANTAGE Get the latest global quote for an equity.
SECTOR_ALPHAVANTAGE Get the S&P500 real-time and historical sector performances.
STOCK_SEARCH_ALPHAVANTAGE Search for equity data using a company name or symbol.

FX

FX_ALPHAVANTAGE

Use FX_ALPHAVANTAGE when you want to get the real-time FX rate for a physical or cryptocurrency pair. You can use these data rows to make things even simpler:

  • Currency names to get the actual name of the currencies
  • Exchange rate to get the exchange rate along with when it was last updated

Syntax

FX_ALPHAVANTAGE(from_currency, to_currency)

Parameter Mandatory Description
from_currency Yes A three-letter physical or digital currency code to convert from. For example: "USD" or "BTC".
to_currency Yes A three-letter physical or digital currency code to convert to. For example: "USD" or "BTC".

Examples

To get the real-time exchange rate of Euros to Polish Zloty:

=FX_ALPHAVANTAGE("EUR","PLN")

FX example

FX_DAILY_ALPHAVANTAGE

Use FX_DAILY_ALPHAVANTAGE to get the daily open, high, low, and close for a currency pair for a date range.

Syntax

FX_DAILY_ALPHAVANTAGE(from_currency, to_currency, [interval])

Parameter Mandatory Description
from_currency Yes A three-letter physical or digital currency code to convert from. For example: "USD" or "BTC".
to_currency Yes A three-letter physical or digital currency code to convert to. For example: "USD" or "BTC".
interval No The date range to return daily exchange rates for. For example: "[2019-11-22;2019-11-29]" or ">2019-12-01". By default, returns the most recent daily rates.

Examples

To get the daily exchange from Euros to US Dollars for the month of August:

=FX_DAILY_ALPHAVANTAGE("EUR","USD","[2020-08-01;2020-09-01]")

FX daily example

FX_INTRADAY_ALPHAVANTAGE

Use FX_INTRADAY_ALPHAVANTAGE when you want to see more precise fluctuations of a currency throughout one or more days. For example, you can see how an FX rate changes every hour or even every minute.

Syntax

FX_INTRADAY_ALPHAVANTAGE(from_currency, to_currency, sample, [interval])

Parameter Mandatory Description
from_currency Yes A three-letter physical or digital currency code to convert from. For example: "USD" or "BTC".
to_currency Yes A three-letter physical or digital currency code to convert to. For example: "USD" or "BTC".
sample Yes The time interval between two data points. Choose either:
- "1min"
- "5min"
- "15min"
- "30min"
- "60min"
interval No The date range to return daily exchange rates for. For example: "[2019-11-22;2019-11-29]" or ">2019-12-01". By default, returns the most recent daily rates.

Examples

To see how the FX rate from US Dollar to Euros changes every 5 minutes on since 2020-09-29:

=FX_INTRADAY_ALPHAVANTAGE("USD","EUR","5min","2020-09-29")

FX Intraday example

FX_WEEKLY_ALPHAVANTAGE

Use FX_WEEKLY_ALPHAVANTAGE to get the last open, high, low, and close for a currency pair of a week for a date range.

Syntax

Parameter Mandatory Description
from_currency Yes A three-letter physical or digital currency code to convert from. For example: "USD" or "BTC".
to_currency Yes A three-letter physical or digital currency code to convert to. For example: "USD" or "BTC".
interval No The date range to return monthly exchange rates for. For example: "[2019-11-22;2019-11-29]" or ">2019-12-01". By default, returns the most recent rates, even for partial weeks.

Examples

If you want to get the weekly FX rate for Australian Dollars to Polish Zloty from July to August 2020:

=FX_WEEKLY_ALPHAVANTAGE("AUD","PLN","[2020-07-01;2020-08-31]")

FX weekly example

FX_MONTHLY_ALPHAVANTAGE

Use FX_MONTHLY_ALPHAVANTAGE to get the last open, high, low, and close for a currency pair of a month for a date range.

Syntax

FX_MONTHLY_ALPHAVANTAGE(from_currency, to_currency, [interval])

Parameter Mandatory Description
from_currency Yes A three-letter physical or digital currency code to convert from. For example: "USD" or "BTC".
to_currency Yes A three-letter physical or digital currency code to convert to. For example: "USD" or "BTC".
interval No The date range to return monthly exchange rates for. For example: "[2019-11-22;2019-11-29]" or ">2019-12-01". By default, returns the most recent rates, even for partial months.

Examples

If you want to get the monthly average for Australian Dollars to Polish Zloty from January to August 2020:

=FX_MONTHLY_ALPHAVANTAGE("AUD","PLN","[2020-01-01;2020-08-31]")

FX monthly example

Stock Market Close Time Series

STOCK_DAILY_ALPHAVANTAGE

Use STOCK_DAILY_ALPHAVANTAGE to get the daily market close price of a stock.
Use STOCK_MONTHLY_ALPHAVANTAGE when you want to get the market close price of a stock on the last day of one or more weeks.
Use STOCK_MONTHLY_ALPHAVANTAGE when you want to get the market close price of a stock on the last day of one or more months.

Syntax

ADJUSTED_STOCK_FUNCTION(symbol, [interval])

Parameter Mandatory Description
symbol Yes The stock symbol. For example: "AAPL" or "AMZN".
interval No The date range to return the daily time series for. For example: "[2019-11-22;2019-11-29]" or ">2019-12-01". By default, returns the most current data.

Examples

If you want to get the daily stock price of Amazon since the 2020-09-15:

=STOCK_DAILY_ALPHAVANTAGE("AMZN",">2020-09-15")

Stock daily example

If you want to get the weekly stock price of Apple between 2020-08-01 and 2020-09-15:

=STOCK_WEEKLY_ALPHAVANTAGE("AAPL","[2020-08-01;2020-09-15]")

Stock weekly example

If you want to get the adjusted monthly stock price of Microsoft between the 2020-01-01 and 2020-08-31:

=STOCK_MONTHLYADJUSTED_ALPHAVANTAGE("MSFT","[2020-01-01;2020-08-31]")

Stock monthly example

Stock Adjusted Time Series

Use STOCK_DAILYADJUSTED_ALPHAVANTAGE to get the daily adjusted price of a stock.
Use STOCK_WEEKLYADJUSTED_ALPHAVANTAGE when you want to get the adjusted close price of a stock on the last day of one or more weeks.
Use STOCK_MONTHLYADJUSTED_ALPHAVANTAGE when you want to get the adjusted close price of a stock on the last day of one or more months.

Syntax

ADJUSTED_STOCK_FUNCTION(symbol, [interval])

Parameter Mandatory Description
symbol Yes The stock symbol. For example: "AAPL" or "AMZN".
interval No The date range to return the daily time series for. For example: "[2019-11-22;2019-11-29]" or ">2019-12-01". By default, returns the most current data.

Examples

If you want to get the adjusted daily stock price of Amazon since the 2020-09-20:

=STOCK_DAILYADJUSTED_ALPHAVANTAGE("AMZN",">2020-09-20")

Stock daily adjusted example

If you want to get the adjusted weekly stock price of Apple between the 2020-07-01 and 2020-08-31:

=STOCK_MONTHLYADJUSTED_ALPHAVANTAGE("AAPL","[2020-07-01;2020-08-31]")

Stock weekly adjusted example

If you want to get the adjusted monthly stock price of Microsoft between the 2020-01-01 and 2020-08-31:

=STOCK_MONTHLYADJUSTED_ALPHAVANTAGE("MSFT","[2020-01-01;2020-08-31]")

Stock monthly adjusted example

Other

SECTOR_ALPHAVANTAGE

Use SECTOR_ALPHAVANTAGE to get real time and historical sector performance, based on the S&P 500 index.

Sectors include:

  • Real estate
  • Energy
  • Materials
  • Information Technology
  • Financials
  • Industrials
  • Health Care
  • Consumer Staples
  • Consumer Discretionary
  • Utilities
  • Communication Services

Syntax

SECTOR_ALPHAVANTAGE()

Examples

To get the sector performance, just use:

=SECTOR_ALPHAVANTAGE()

Sector example

STOCK_ALPHAVANTAGE

Use STOCK_ALPHAVANTAGE to get the latest-available global quote for an equity. And if you quickly want some info, use these data rows:

  • Price and volume to get the price, volume, and the latest trading day for the stock
  • High and low to get the high and low for the latest trading day for the stock

You can use our STOCK_SEARCH_ALPHAVANTAGE function to find the correct stock symbol based on a company name. $$

Syntax

STOCK_ALPHAVANTAGE(symbol)

Parameter Mandatory Description
symbol Yes The stock symbol. For example: "AAPL" or "AMZN".

Examples

To get the latest global quote for Amazon:

=STOCK_ALPHAVANTAGE("AMZN")

Stock example

STOCK_INTRADAY_ALPHAVANTAGE

Use STOCK_INTRADAY_ALPHAVANTAGE when you want to get the performance of a stock throughout the day. You can set how often to sample the data anywhere from 1 to 60 minutes.

Syntax

STOCK_INTRADAY_ALPHAVANTAGE(symbol, sample, [interval])

Parameter Mandatory Description
symbol Yes The stock symbol. For example: "AAPL" or "AMZN".
sample Yes The time interval between two data points. Choose either:
- "1min"
- "5min"
- "15min"
- "30min"
- "60min"
interval No The date range to return the intraday time series for. For example: "[2019-11-22;2019-11-29]" or ">2019-12-01". By default, returns the most current data.

Examples

=STOCK_INTRADAY_ALPHAVANTAGE("MSFT","30min",">2020-09-28")

Stock intraday example

STOCK_SEARCH_ALPHAVANTAGE

Use STOCK_SEARCH_ALPHAVANTAGE when you want to get some key equity data for a company using just keywords. It’ll find the best matches based on your keywords and return their stock symbol, full company name, some trading data, and a confidence score.
And if you’re feeling lucky, use the Best match recommended row to get details about the first result, or, use the Best matches recommended table to get all of the matches and their data into a table.

Syntax

STOCK_SEARCH_ALPHAVANTAGE(keywords)

Parameter Mandatory Description
keywords Yes One or more keywords of a company. For example: "microsoft".

Examples

To find equity results for xiaomi:

=STOCK_SEARCH_ALPHAVANTAGE("xiaomi")

Stock search example

Summary

That was a lot - we know. But we did say that we have a plethora of functionality to make sure that you can get the right information you want, at the right time.
And don’t forget to check out these templates to get you started:

Right, well, looks like it’s a good time to build an investment app :rocket:!

1 Like