Financial Data API

Stock Price API

The ROIC.ai Stock Price API provides historical daily price data and latest quotes for over 60,000 publicly traded companies. Every response includes open, high, low, close, adjusted close, volume, VWAP, and daily change metrics.

Use these endpoints to power charting applications, backtest trading strategies, build portfolio trackers, or feed price data into financial models and spreadsheets.

Available Endpoints

EndpointDescription
Historical Stock PricesGet daily OHLCV price data with date range filtering, custom limits, and sort order
Latest Stock PriceGet the most recent trading day's price data for any company

Common Use Cases

  • Stock charting. Build interactive price charts with OHLCV candlestick data and volume bars
  • Backtesting. Download historical price series to test trading strategies against real market data
  • Portfolio tracking. Fetch latest prices for a list of holdings to calculate portfolio value and daily P&L
  • Spreadsheet models. Import price data directly into Google Sheets or Excel using the TSV format option
  • Event studies. Analyze stock price behavior around earnings dates, product launches, or macro events
  • Technical analysis. Use daily price and volume data to compute moving averages, RSI, Bollinger Bands, and other indicators

Response Format

All stock price endpoints return the following fields for each trading day:

FieldDescription
dateTrading date (YYYY-MM-DD)
openOpening price
highHighest price during the day
lowLowest price during the day
closeClosing price
adj_closeSplit and dividend adjusted closing price
volumeNumber of shares traded
vwapVolume-weighted average price
changeDollar change from previous close
change_percentPercentage change from previous close

Authentication

All stock price endpoints require an API key. Apple (AAPL) data is available on the free tier. Access to other companies requires a premium subscription.

See the Authentication page for details on passing your API key.

Next Steps

  1. Get historical stock prices with date range filtering
  2. Fetch the latest quote for any ticker
  3. Use format=excel to import prices directly into Google Sheets or Excel