stocks_file | R Documentation |
This function lets the user download his personal Excel with his Portfolio's data, locally or from Dropbox.
stocks_file(
file = NA,
creds = NA,
auto = TRUE,
sheets = c("Portafolio", "Fondos", "Transacciones"),
keep_old = TRUE,
cache = TRUE,
quiet = FALSE
)
file |
Character. Import an Excel file, local or from URL. |
creds |
Character. Dropbox's credentials (see |
auto |
Boolean. Automatically use my local personal file? You might want
to set in into your .Renviron |
sheets |
Character Vector. Names of each sheet containing Portfolio summary, Cash, and Transactions information. Please, keep the order of these tabs. |
keep_old |
Boolean. Include sold tickers even though not currently in portfolio? |
cache |
Boolean. Use daily cache if available? |
quiet |
Boolean. Keep quiet? If not, informative messages will be printed. |
List with portfolio, transactions, and cash data.frames.
Other Investment:
daily_portfolio()
,
daily_stocks()
,
etf_sector()
,
splot_change()
,
splot_divs()
,
splot_etf()
,
splot_growth()
,
splot_roi()
,
splot_summary()
,
splot_types()
,
stocks_obj()
,
stocks_quote()
,
stocks_report()
Other Credentials:
db_download()
,
db_upload()
,
get_credentials()
,
get_tweets()
,
mail_send()
,
queryDB()
,
queryGA()
,
slackSend()
,
stocks_report()
## Not run:
# Load lares dummy portfolio XLSX
file <- system.file("inst/docs", "dummyPortfolio.xlsx", package = "lares")
df <- stocks_file(
file = file,
sheets = c("Portafolio", "Fondos", "Transacciones"),
keep_old = FALSE
)
## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.