download_data_osap: Download and Process Open Source Asset Pricing Data

In tidyfinance: Tidy Finance Helper Functions

Download and Process Open Source Asset Pricing Data

Description

This function downloads the data from Open Source Asset Pricing from Google Sheets using a specified sheet ID, processes the data by converting column names to snake_case, and optionally filters the data based on a provided date range.

Usage

download_data_osap(
  start_date = NULL,
  end_date = NULL,
  sheet_id = "1JyhcF5PRKHcputlioxlu5j5GyLo4JYyY"
)

Arguments

start_date	Optional. A character string or Date object in "YYYY-MM-DD" format specifying the start date for the data. If not provided, the full dataset is returned.
end_date	Optional. A character string or Date object in "YYYY-MM-DD" format specifying the start date for the data. If not provided, the full dataset is returned.
sheet_id	A character string representing the Google Sheet ID from which to download the data. Default is "1JyhcF5PRKHcputlioxlu5j5GyLo4JYyY".

Value

A tibble containing the processed data. The column names are converted to snake_case, and the data is filtered by the specified date range if start_date and end_date are provided.

Examples

  osap_monthly <- download_data_osap(start_date = "2020-01-01", end_date = "2020-06-30")

tidyfinance documentation built on April 3, 2025, 6:10 p.m.