PortfolioTesteR (version 0.1.4)

sql_adapter_adjusted: 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
)

Value

data.table with Date column and adjusted prices per symbol

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)

Examples

if (FALSE) { # requireNamespace("RSQLite", quietly = TRUE) && file.exists("sp500.db")
# \donttest{
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)
# }
}