Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Criar função cotahist_etf_options_superset #50

Closed
wilsonfreitas opened this issue Aug 1, 2022 · 1 comment
Closed

Criar função cotahist_etf_options_superset #50

wilsonfreitas opened this issue Aug 1, 2022 · 1 comment

Comments

@wilsonfreitas
Copy link
Collaborator

wilsonfreitas commented Aug 1, 2022

Criar função cotahist_etf_options_superset equivalente a cotahist_equity_options_superset.

Também podemos ter cotahist_index_options_superset

@wilsonfreitas
Copy link
Collaborator Author

Talvez uma alternativa mais democratica seja criar uma função cotahist_options_by_symbol_superset

refdate <- getdate("last bizday", Sys.Date(), "Brazil/B3")
ch <- cotahist_get(refdate, "yearly")
yc <- yc_mget(first_date = as.Date("2022-01-01"), last_date = refdate)

symbol_ <- "PETR4"

eqs <- ch[["HistoricalPrices"]] |>
  filter(.data$cod_negociacao == symbol_) |>
  rb3:::format_equity(TRUE)
eqs_opts <- ch[["HistoricalPrices"]] |>
  filter(.data$tipo_mercado %in% c(70, 80)) |>
  rb3:::format_options(TRUE) |>
  filter(cod_isin == eqs$cod_isin[1])
op <- inner_join(eqs_opts, eqs,
  by = c("refdate", "cod_isin"),
  suffix = c("", ".underlying")
) |>
  select(-c(.data$cod_isin)) |>
  mutate(
    fixing_maturity_date = following(.data$maturity_date, "Brazil/ANBIMA")
  ) |>
  inner_join(yc |> select(.data$refdate, .data$forward_date, .data$r_252),
    by = c("refdate", "fixing_maturity_date" = "forward_date")
  )

wilsonfreitas added a commit that referenced this issue Aug 13, 2022
This function returns a superset with all options accordingly to the passed symbol.

It works with equities and ETF.

Issued #50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant