Index

_

__init__() (capiq_excel.downloader.timeout.TimeoutWrapper method)

A

add_year_month_column_from_date_string_column() (in module capiq_excel.tools.ext_pandas) append_csv_to_csv() (in module capiq_excel.tools.ext_pandas) append_csv_to_monthly_csv_of_first_date() (in module capiq_excel.tools.ext_pandas)

append_csvs_to_csv() (in module capiq_excel.tools.ext_pandas) append_csvs_to_monthly_csv_of_first_date() (in module capiq_excel.tools.ext_pandas) append_df_to_csv() (in module capiq_excel.tools.ext_pandas) append_df_to_monthly_csv_of_first_date() (in module capiq_excel.tools.ext_pandas)

C

capiq_company_ids (capiq_excel.main.download_data_for_capiq_ids parameter), [1] capiq_excel (module) capiq_excel.addin (module) capiq_excel.combine (module) capiq_excel.downloader (module) capiq_excel.downloader.timeout (module) capiq_excel.downloader.tools (module) capiq_excel.exceptions (module) capiq_excel.fileops (module) capiq_excel.ids (module) capiq_excel.main (module) capiq_excel.tools (module) capiq_excel.tools.dates (module) capiq_excel.tools.ext_pandas (module) capiq_excel.workbook (module) capiq_excel.workbook.commands (module)

capiq_excel.workbook.create (module) capiq_excel.workbook.populate (module) capiq_excel.workbook.wait (module) CapitalIQInactiveException combine_all_capiq_ids_xlsx() (in module capiq_excel.ids) combine_all_capiq_xlsx() (in module capiq_excel.combine) company_id (capiq_excel.workbook.commands.financial_data_command parameter) (capiq_excel.workbook.commands.market_data_command parameter) company_ids (capiq_excel.main.download_data parameter), [1] convert_excel_date_to_pandas_date() (in module capiq_excel.tools.ext_pandas) create_all_xlsx_with_commands() (in module capiq_excel.workbook.create) create_all_xlsx_with_holdings_commands() (in module capiq_excel.workbook.create) create_all_xlsx_with_id_commands() (in module capiq_excel.workbook.create) create_xlsx_with_commands() (in module capiq_excel.workbook.create) create_xlsx_with_holdings_commands() (in module capiq_excel.workbook.create) csv_filepath_list (capiq_excel.tools.ext_pandas.append_csvs_to_csv parameter)

D

data_folder (capiq_excel.main.download_data parameter), [1] data_item (capiq_excel.workbook.commands.financial_data_command parameter) (capiq_excel.workbook.commands.market_data_command parameter) data_item_label (capiq_excel.workbook.commands.financial_data_command parameter) (capiq_excel.workbook.commands.market_data_command parameter)

data_outpath (capiq_excel.main.download_data parameter), [1] date_from_year_month() (in module capiq_excel.tools.ext_pandas) download_capiq_ids() (in module capiq_excel.ids) download_data() (in module capiq_excel.main) download_data_for_capiq_ids() (in module capiq_excel.main)

E

excel_cols() (in module capiq_excel.workbook.create)

F

financial_command_kwargs (capiq_excel.main.download_data parameter), [1] (capiq_excel.main.download_data_for_capiq_ids parameter), [1] financial_data_command() (in module capiq_excel.workbook.commands) financial_data_items (capiq_excel.main.download_data parameter), [1] (capiq_excel.main.download_data_for_capiq_ids parameter), [1]

first_year_month_in_df() (in module capiq_excel.tools.ext_pandas) folder (capiq_excel.ids.download_capiq_ids parameter) (capiq_excel.main.download_data_for_capiq_ids parameter), [1] freq (capiq_excel.workbook.commands.financial_data_command parameter) (capiq_excel.workbook.commands.market_data_command parameter) freq_and_periods_to_begin_date_str() (in module capiq_excel.tools.dates)

G

get_full_date_df_from_date_series() (in module capiq_excel.tools.ext_pandas)

get_path_of_additional_failed_folder_add_if_necessary() (in module capiq_excel.fileops) get_path_of_failed_folder_add_if_necessary() (in module capiq_excel.fileops)

H

holdings_command() (in module capiq_excel.workbook.commands)

I

id_command() (in module capiq_excel.workbook.commands) ids (capiq_excel.ids.download_capiq_ids parameter)

ids_folder (capiq_excel.main.download_data parameter), [1] ids_outpath (capiq_excel.main.download_data parameter), [1]

L

left_merge_df() (in module capiq_excel.tools.ext_pandas)

load_capiq() (in module capiq_excel.addin)

M

market_data_command() (in module capiq_excel.workbook.commands) market_data_items (capiq_excel.main.download_data parameter), [1] (capiq_excel.main.download_data_for_capiq_ids parameter), [1]

move_file_to_failed_folder() (in module capiq_excel.fileops)

N

name_command() (in module capiq_excel.workbook.commands)

num_periods (capiq_excel.workbook.commands.financial_data_command parameter) (capiq_excel.workbook.commands.market_data_command parameter)

O

outer_merge_df() (in module capiq_excel.tools.ext_pandas) outpath (capiq_excel.ids.download_capiq_ids parameter) (capiq_excel.main.download_data_for_capiq_ids parameter), [1] (capiq_excel.tools.ext_pandas.append_csvs_to_csv parameter)

P

populate_all_files_in_folder() (in module capiq_excel.downloader.tools) populate_all_ids_in_folder() (in module capiq_excel.ids)

populate_capiq_for_file() (in module capiq_excel.workbook.populate) populate_capiq_ids_for_file() (in module capiq_excel.workbook.populate)

R

replace_first_line_of_file() (in module capiq_excel.tools.ext_pandas) restart (capiq_excel.main.download_data parameter), [1] (capiq_excel.main.download_data_for_capiq_ids parameter), [1]

right_merge_df() (in module capiq_excel.tools.ext_pandas) run_failed (capiq_excel.main.download_data parameter), [1] (capiq_excel.main.download_data_for_capiq_ids parameter), [1]

S

scale_variables() (in module capiq_excel.tools.ext_pandas)

T

timeout (capiq_excel.main.download_data parameter), [1] (capiq_excel.main.download_data_for_capiq_ids parameter), [1]

TimeoutWrapper (class in capiq_excel.downloader.timeout) today_as_str() (in module capiq_excel.tools.dates)

W

WorkbookClosedException