import pandas as pd
import pinkfish as pf

# format price data
pd.options.display.float_format = '{:0.2f}'.format

# increase display of dataframe rows
pd.set_option('display.max_rows', 1000)

"""
Explanation: Get Symbol Metadata
A useful utility for demonstating the use of the get_symbol_metadata function.  Use this notebook to get the start date, end date and how many years of timeseries for all the symbols in your data cache.
End of explanation
"""


df = pf.get_symbol_metadata(symbols=['msft', 'orcl', 'tsla'])
df.sort_values('num_years', ascending=False).reset_index(drop=True)

"""
Explanation: Get metadata for the symbols below.
Time series will be fetched for any symbols not already cached.
End of explanation
"""


df = pf.get_symbol_metadata(dir_name='data')
df.sort_values('num_years', ascending=False).reset_index(drop=True)

"""
Explanation: Get metadata for all symbols in the cache directory
End of explanation
"""


