sql_adapter_adjusted: Load Adjusted Price Data from SQL Database

In PortfolioTesteR: Test Investment Strategies with English-Like Code

Load Adjusted Price Data from SQL Database

Description

Loads adjusted stock prices (for splits/dividends) from SQLite.

Usage

sql_adapter_adjusted(
  db_path,
  symbols,
  start_date = NULL,
  end_date = NULL,
  auto_update = FALSE,
  frequency = "daily",
  use_adjusted = TRUE
)

Arguments

db_path	Path to SQLite database file
symbols	Character vector of stock symbols to load
start_date	Start date (YYYY-MM-DD) or NULL
end_date	End date (YYYY-MM-DD) or NULL
auto_update	Auto-update database (default: FALSE)
frequency	"daily", "weekly", or "monthly" (default: "daily")
use_adjusted	Use adjusted prices if available (default: TRUE)

Value

data.table with Date column and adjusted prices per symbol

Examples

prices <- sql_adapter_adjusted(
  db_path   = "sp500.db",
  symbols   = c("AAPL", "MSFT"),
  start_date = "2020-01-01",
  end_date   = "2020-12-31",
  frequency  = "monthly"
)
head(prices)

PortfolioTesteR documentation built on Nov. 5, 2025, 5:23 p.m.