Skip to contents

Based on a ticker (id of a stock) and time period, this function will download stock price data from Yahoo Finance and organizes it in the long format. Yahoo Finance <https://finance.yahoo.com/> provides a vast repository of stock price data around the globe. It cover a significant number of markets and assets, being used extensively in academic research and teaching. In the website you can lookup the ticker of a company.

Usage

yf_get(
  tickers,
  first_date = Sys.Date() - 30,
  last_date = Sys.Date(),
  thresh_bad_data = 0.75,
  bench_ticker = "^GSPC",
  type_return = "arit",
  freq_data = "daily",
  how_to_aggregate = "last",
  do_complete_data = FALSE,
  do_cache = TRUE,
  cache_folder = yf_cachefolder_get(),
  do_parallel = FALSE,
  be_quiet = FALSE
)

Arguments

tickers

A single or vector of tickers. If not sure whether the ticker is available, search for it in YF <https://finance.yahoo.com/>.

first_date

The first date of query (Date or character as YYYY-MM-DD)

last_date

The last date of query (Date or character as YYYY-MM-DD)

thresh_bad_data

A percentage threshold for defining bad data. The dates of the benchmark ticker are compared to each asset. If the percentage of non-missing dates with respect to the benchmark ticker is lower than thresh_bad_data, the function will ignore the asset (default = 0.75)

bench_ticker

The ticker of the benchmark asset used to compare dates. My suggestion is to use the main stock index of the market from where the data is coming from (default = ^GSPC (SP500, US market))

type_return

Type of price return to calculate: 'arit' - arithmetic (default), 'log' - log returns.

freq_data

Frequency of financial data: 'daily' (default), 'weekly', 'monthly', 'yearly'

how_to_aggregate

Defines whether to aggregate the data using the first observations of the aggregating period or last ('first', 'last'). For example, if freq_data = 'yearly' and how_to_aggregate = 'last', the last available day of the year will be used for all aggregated values such as price_adjusted. (Default = "last")

do_complete_data

Return a complete/balanced dataset? If TRUE, all missing pairs of ticker-date will be replaced by NA or closest price (see input do_fill_missing_prices). Default = FALSE.

do_cache

Use cache system? (default = TRUE)

cache_folder

Where to save cache files? (default = yfR::yf_cachefolder_get() )

do_parallel

Flag for using parallel or not (default = FALSE). Before using parallel, make sure you call function future::plan() first. See <https://furrr.futureverse.org/> for more details.

be_quiet

Flag for not printing statements (default = FALSE)

Value

A dataframe with the financial data for working days, when markets are open. All price data is measured at the unit of the financial exchange. For example, price data for META (NYSE/US) is measures in dollars, while price data for PETR3.SA (B3/BR) is measured in Reais (Brazilian currency).

The return dataframe contains the following columns:

ticker

The requested tickers (ids of stocks)

ref_date

The reference day (this can also be year/month/week when using argument freq_data)

price_open

The opening price of the day/period

price_high

The highest price of the day/period

price_close

The close/last price of the day/period

volume

The financial volume of the day/period

price_adjusted

The stock price adjusted for corporate events such as splits, dividends and others -- this is usually what you want/need for studying stocks as it represents the actual financial performance of stockholders

ret_adjusted_prices

The arithmetic or log return (see input type_return) for the adjusted stock prices

ret_adjusted_prices

The arithmetic or log return (see input type_return) for the closing stock prices

cumret_adjusted_prices

The accumulated arithmetic/log return for the period (starts at 100%)

The cache system

The yfR`s cache system is basically a bunch of rds files that are saved every time data is imported from YF. It indexes all data by ticker and time period. Whenever a user asks for a dataset, it first checks if the ticker/time period exists in cache and, if it does, loads the data from the rds file.

By default, a temporary folder is used (see function yf_cachefolder_get, which means that all cache files are session-persistent. In practice, whenever you restart your R/RStudio session, all cache files are lost. This is a choice I've made due to the fact that merging adjusted stock price data after corporate events (dividends/splits) is a mess and prone to errors. This only happens for stock price data, and not indices data.

If you really need a persistent cache folder, which is Ok for indices data, simply set a path with argument cache_folder (see warning section).

Warning

Be aware that when using cache system in a local folder (and not the default tempdir()), the aggregate prices series might not match if a split or dividends event happens in between cache files.

Examples


# \donttest{
tickers <- c("TSLA", "MMM")

first_date <- Sys.Date() - 30
last_date <- Sys.Date()

df_yf <- yf_get(
  tickers = tickers,
  first_date = first_date,
  last_date = last_date
)
#> 
#> ── Running yfR for 2 stocks | 2022-08-24 --> 2022-09-23 (30 days) ──
#> 
#>  Downloading data for benchmark ticker ^GSPC
#>  (1/2) Fetching data for MMM
#> ! 	- not cached
#>  	- cache saved successfully
#>  	- got 21 valid rows (2022-08-24 --> 2022-09-22)
#>  	- got 100% of valid prices -- Got it!
#>  (2/2) Fetching data for TSLA
#> ! 	- not cached
#>  	- cache saved successfully
#>  	- got 21 valid rows (2022-08-24 --> 2022-09-22)
#>  	- got 100% of valid prices -- Well done !
#>  Binding price data
#> 
#> ── Diagnostics ─────────────────────────────────────────────────────────────────
#>  Returned dataframe with 42 rows -- Youre doing good!
#>  Using 295.7 kB at /tmp/RtmpzXikYO/yf_cache for 1 cache files
#>  Out of 2 requested tickers, you got 2 (100%)

print(df_yf)
#> # A tibble: 42 × 11
#>    ticker ref_date   price_open price_…¹ price…² price…³ volume price…⁴ ret_ad…⁵
#>  * <chr>  <date>          <dbl>    <dbl>   <dbl>   <dbl>  <dbl>   <dbl>    <dbl>
#>  1 MMM    2022-08-24       141.     142.    140.    141. 1.54e7    141. NA      
#>  2 MMM    2022-08-25       141.     143.    141.    143. 4.74e7    143.  0.0122 
#>  3 MMM    2022-08-26       144.     144.    129.    129. 3.84e7    129. -0.0954 
#>  4 MMM    2022-08-29       129.     129.    125.    126. 5.05e7    126. -0.0209 
#>  5 MMM    2022-08-30       127.     128.    123.    125. 3.45e7    125. -0.0125 
#>  6 MMM    2022-08-31       125.     126.    124.    124. 3.16e7    124. -0.00408
#>  7 MMM    2022-09-01       124.     126.    124.    126. 3.10e7    126.  0.0103 
#>  8 MMM    2022-09-02       126.     126.    121.    122. 1.23e7    122. -0.0317 
#>  9 MMM    2022-09-06       121.     122.    116.    117. 3.07e7    117. -0.0415 
#> 10 MMM    2022-09-07       117.     121.    116.    121. 3.76e7    121.  0.0339 
#> # … with 32 more rows, 2 more variables: ret_closing_prices <dbl>,
#> #   cumret_adjusted_prices <dbl>, and abbreviated variable names ¹​price_high,
#> #   ²​price_low, ³​price_close, ⁴​price_adjusted, ⁵​ret_adjusted_prices
# }