# Tidy Quantitative Financial Analysis

## Documentation for package ‘tidyquant’ version 1.0.12

- DESCRIPTION file.
- User guides, package vignettes and other documentation.
- Package NEWS.

## Help Pages

A C D E F G H I L M N P Q R S T V W Y

tidyquant-package | tidyquant: Integrating quantitative financial analysis tools with the tidyverse

## -- A --

ABS | Excel Statistical Mutation Functions
AS_DATE | Excel Date and Time Functions
AS_DATETIME | Excel Date and Time Functions
AVERAGE | Excel Statistical Summary Functions
AVERAGE_IFS | Excel Summarising "If" Functions
av_api_key | Set Alpha Vantage API Key

## -- C --

CEILING_DATE | Excel Date and Time Functions
CEILING_DAY | Excel Date and Time Functions
CEILING_MONTH | Excel Date and Time Functions
CEILING_QUARTER | Excel Date and Time Functions
CEILING_WEEK | Excel Date and Time Functions
CEILING_YEAR | Excel Date and Time Functions
CHANGE | Excel Statistical Mutation Functions
CHANGE_FIRSTLAST | Excel Statistical Summary Functions
coord_x_date | Zoom in on plot regions using date ranges or date-time ranges
coord_x_datetime | Zoom in on plot regions using date ranges or date-time ranges
COR | Excel Statistical Summary Functions
COUNT | Excel Statistical Summary Functions
COUNT_DAYS | Excel Date and Time Functions
COUNT_IFS | Excel Summarising "If" Functions
COUNT_UNIQUE | Excel Statistical Summary Functions
COV | Excel Statistical Summary Functions
CREATE_IFS | Excel Summarising "If" Functions
CUMULATIVE_MAX | Excel Statistical Mutation Functions
CUMULATIVE_MEAN | Excel Statistical Mutation Functions
CUMULATIVE_MEDIAN | Excel Statistical Mutation Functions
CUMULATIVE_MIN | Excel Statistical Mutation Functions
CUMULATIVE_PRODUCT | Excel Statistical Mutation Functions
CUMULATIVE_SUM | Excel Statistical Mutation Functions

## -- D --

DATE | Excel Date and Time Functions
DATEVALUE | Excel Date and Time Functions
DATE_SEQUENCE | Excel Date and Time Functions
DATE_TO_DECIMAL | Excel Date and Time Functions
DATE_TO_NUMERIC | Excel Date and Time Functions
DAY | Excel Date and Time Functions
deprecated | Deprecated functions
DMY | Excel Date and Time Functions
DMY_H | Excel Date and Time Functions
DMY_HM | Excel Date and Time Functions
DMY_HMS | Excel Date and Time Functions
DOM | Excel Date and Time Functions
DOW | Excel Date and Time Functions

## -- E --

EDATE | Excel Date and Time Functions
EOMONTH | Excel Date and Time Functions
excel_date_functions | Excel Date and Time Functions
excel_financial_math_functions | Excel Financial Math Functions
excel_if_functions | Excel Summarising "If" Functions
excel_pivot_table | Excel Pivot Table
excel_ref_functions | Excel Reference Functions
excel_stat_mutation_functions | Excel Statistical Mutation Functions
excel_stat_summary_functions | Excel Statistical Summary Functions
EXP | Excel Statistical Mutation Functions

## -- F --

FANG | Stock prices for the "FANG" stocks.
FIRST | Excel Statistical Summary Functions
FLOOR_DATE | Excel Date and Time Functions
FLOOR_DAY | Excel Date and Time Functions
FLOOR_MONTH | Excel Date and Time Functions
FLOOR_QUARTER | Excel Date and Time Functions
FLOOR_WEEK | Excel Date and Time Functions
FLOOR_YEAR | Excel Date and Time Functions
FV | Excel Financial Math Functions

## -- G --

geom_barchart | Plot Financial Charts in ggplot2
geom_bbands | Plot Bollinger Bands using Moving Averages
geom_bbands_ | Plot Bollinger Bands using Moving Averages
geom_candlestick | Plot Financial Charts in ggplot2
geom_chart | Plot Financial Charts in ggplot2
geom_ma | Plot moving averages
geom_ma_ | Plot moving averages

## -- H --

HOLIDAY_SEQUENCE | Excel Date and Time Functions
HOLIDAY_TABLE | Excel Date and Time Functions
HOUR | Excel Date and Time Functions

## -- I --

IRR | Excel Financial Math Functions

## -- L --

LAG | Excel Statistical Mutation Functions
LAST | Excel Statistical Summary Functions
LEAD | Excel Statistical Mutation Functions
LOG | Excel Statistical Mutation Functions

## -- M --

MAX | Excel Statistical Summary Functions
MAX_IFS | Excel Summarising "If" Functions
MDAY | Excel Date and Time Functions
MDY | Excel Date and Time Functions
MDY_H | Excel Date and Time Functions
MDY_HM | Excel Date and Time Functions
MDY_HMS | Excel Date and Time Functions
MEDIAN | Excel Statistical Summary Functions
MEDIAN_IFS | Excel Summarising "If" Functions
MIN | Excel Statistical Summary Functions
MINUTE | Excel Date and Time Functions
MIN_IFS | Excel Summarising "If" Functions
MONTH | Excel Date and Time Functions
MONTHDAY | Excel Date and Time Functions

## -- N --

NET_WORKDAYS | Excel Date and Time Functions
NOW | Excel Date and Time Functions
NPV | Excel Financial Math Functions
NTH | Excel Statistical Summary Functions

## -- P --

palette_dark | tidyquant palettes for use with scales
palette_green | tidyquant palettes for use with scales
palette_light | tidyquant palettes for use with scales
palette_tq | tidyquant palettes for use with scales
PCT_CHANGE | Excel Statistical Mutation Functions
PCT_CHANGE_FIRSTLAST | Excel Statistical Summary Functions
pivot_table | Excel Pivot Table
PMT | Excel Financial Math Functions
PV | Excel Financial Math Functions

## -- Q --

QDAY | Excel Date and Time Functions
quandl_api_key | Query or set Nasdaq Data Link API Key
quandl_search | Search the Nasdaq Data Link database
QUARTER | Excel Date and Time Functions
QUARTERDAY | Excel Date and Time Functions

## -- R --

RATE | Excel Financial Math Functions
RETURN | Excel Statistical Mutation Functions
ROUND_DATE | Excel Date and Time Functions
ROUND_DAY | Excel Date and Time Functions
ROUND_MONTH | Excel Date and Time Functions
ROUND_QUARTER | Excel Date and Time Functions
ROUND_WEEK | Excel Date and Time Functions
ROUND_YEAR | Excel Date and Time Functions

## -- S --

scale_color_tq | tidyquant colors and fills for ggplot2.
scale_colour_tq | tidyquant colors and fills for ggplot2.
scale_fill_tq | tidyquant colors and fills for ggplot2.
scale_manual | tidyquant colors and fills for ggplot2.
SECOND | Excel Date and Time Functions
SQRT | Excel Statistical Mutation Functions
STDEV | Excel Statistical Summary Functions
SUM | Excel Statistical Summary Functions
SUM_IFS | Excel Summarising "If" Functions

## -- T --

theme_tq | tidyquant themes for ggplot2.
theme_tq_dark | tidyquant themes for ggplot2.
theme_tq_green | tidyquant themes for ggplot2.
tidyquant | tidyquant: Integrating quantitative financial analysis tools with the tidyverse
tidyquant_conflicts | Conflicts between the tidyquant and other packages
tiingo_api_key | Set Tiingo API Key
TODAY | Excel Date and Time Functions
tq_exchange | Get all stocks in a stock index or stock exchange in 'tibble' format
tq_exchange_options | Get all stocks in a stock index or stock exchange in 'tibble' format
tq_fund_holdings | Get all stocks in a stock index or stock exchange in 'tibble' format
tq_fund_source_options | Get all stocks in a stock index or stock exchange in 'tibble' format
tq_get | Get quantitative data in 'tibble' format
tq_get_options | Get quantitative data in 'tibble' format
tq_index | Get all stocks in a stock index or stock exchange in 'tibble' format
tq_index_options | Get all stocks in a stock index or stock exchange in 'tibble' format
tq_mutate | Mutates quantitative data
tq_mutate_ | Mutates quantitative data
tq_mutate_fun_options | Mutates quantitative data
tq_mutate_xy | Mutates quantitative data
tq_mutate_xy_ | Mutates quantitative data
tq_performance | Computes a wide variety of summary performance metrics from stock or portfolio returns
tq_performance_ | Computes a wide variety of summary performance metrics from stock or portfolio returns
tq_performance_fun_options | Computes a wide variety of summary performance metrics from stock or portfolio returns
tq_portfolio | Aggregates a group of returns by asset into portfolio returns
tq_portfolio_ | Aggregates a group of returns by asset into portfolio returns
tq_repeat_df | Aggregates a group of returns by asset into portfolio returns
tq_transform | Deprecated functions
tq_transform_xy | Deprecated functions
tq_transmute | Mutates quantitative data
tq_transmute_ | Mutates quantitative data
tq_transmute_fun_options | Mutates quantitative data
tq_transmute_xy | Mutates quantitative data
tq_transmute_xy_ | Mutates quantitative data

## -- V --

VAR | Excel Statistical Summary Functions
VLOOKUP | Excel Reference Functions

## -- W --

WDAY | Excel Date and Time Functions
WEEK | Excel Date and Time Functions
WEEKDAY | Excel Date and Time Functions
WEEKNUM | Excel Date and Time Functions
WEEKNUM_ISO | Excel Date and Time Functions
WORKDAY_SEQUENCE | Excel Date and Time Functions

## -- Y --

YEAR | Excel Date and Time Functions
YEARFRAC | Excel Date and Time Functions
YEAR_ISO | Excel Date and Time Functions
YMD | Excel Date and Time Functions
YMD_H | Excel Date and Time Functions
YMD_HM | Excel Date and Time Functions
YMD_HMS | Excel Date and Time Functions