Man pages for AZASRS/AZASRS
ASRS Database R API
| append_nav_has_reported | Append column if NAV has reported at end date |
| AZASRS_DATABASE_CONNECTION | Opens a database connection |
| AZASRS_DATABASE_DISCONNECT | Disconnect from database |
| AZASRS__welcome__message__ | Opening Remarks |
| build_grouped_irrs | Create rollup of IRR based off of dates |
| build_grouped_pm_cash_flow | Build PM "Cash Flow" and utilizing NAV to simulate where... |
| build_grouped_pm_metrics | Create rollup of IRR based off of dates |
| build_privm_metrics | Build a tibble of major private market metrics including:... |
| calc_add_qtrs | Calculate a future quarter date |
| calc_appreciation | Appreciation |
| calc_cytd_metadata | Find most recent CYTD compared to end_date |
| calc_dpi | DPI |
| calc_dva | DVA |
| calc_fytd_metadata | Find most recent FYTD compared to end_date |
| calc_grouped_pm_metrics | Calculate the rollup metrics |
| calc_irr | IRR - JD replaced Karl's asrsMethods |
| calc_irr_from_df | IRR from dataframe |
| calc_pme | PME |
| calc_previous_year_qtr | Calculate previous year and quarter |
| calc_time_delta | Calculate time difference |
| calc_tvpi | TVPI |
| calculate_grouped_irr | Calculate the rollup IRR |
| clean_nav_cf | Cleans NAV / CF filtered by date data to sum up by pm_fund_id |
| convert_start_date_nav_to_negative | Convert first NAV to negative |
| filter_cf_between_dates | Collect cash flow between dates |
| filter_dates | Filter dates from NAV / CF joined |
| filter_nav_on_dates | Filter Private market NAV on dates |
| get_account_futures | Get all account_futures |
| get_account_info | Get all account_info |
| get_benchmark_daily_index | Get all benchmark_daily_index |
| get_benchmark_fund_relationship | Get relationships between funds and benchmarks... |
| get_next_quarter | Get next quarter date |
| get_pm_cash_flow_daily | Daily private market cash flows |
| get_pm_fund_info | Get all pm_fund_info |
| get_raw_data_from_azure | Get CSV Data from Azure |
| get_ssbt_composite_bor_daily | Get SSBT composite book of record daily |
| get_ssbt_composite_bor_monthly | Get SSBT composite book of record monthly |
| get_ssbt_composite_info | Query ssbt_composite_info table from database |
| get_total_fund_value | Get total fund value |
| get_value_date | Get value date |
| INITIAL_DATABASE_POPULATION | Initially populates ALL tables via .csv files |
| merge_nav_and_cf | Merge NAV and CF |
| pipe | Pipe operator |
| rolling_p2p_irr | BUILD PRIVATE MARKET P2P IRR TIBBLE |
| send_raw_data_to_azure | Upload Data to Azure |
| test_is_not_rollup | Test ... for rollup |
| UPDATE_DATABASE | Updates database with AZURE files |
