Pinned Loading

1. An extract from a correlation matrix... An extract from a correlation matrix calculation tool

   1

   # Select all non-ETF stocks

   2

   df = pd.read_sql("SELECT Symbol FROM symbols_valid_meta WHERE etf='n'", db)

   3

   4

   # Load all available history dates

   5

   total_df = pd.read_sql("SELECT DISTINCT date FROM history", db)

2. The third extract from our correlati... The third extract from our correlation matrix tool

   1

   merged.astype(dtype='float16').round(decimals=2)

   2

   print("Calculating correlation")

   3

   4

   with ProgressBar():

   5

       merged = merged.corr().compute()

3. Utility functions for showing/hiding... Utility functions for showing/hiding toolbar in response to a user click whilst allowing uninterrupted scrolling.

   1

   val SCROLL_THRESHOLD = 10f

   2

   3

   var showingTaskbar: HashMap<Toolbar, Boolean> = hashMapOf()

   4

   var x = 0f

   5

   var y = 0f

4. Second extract from correlation matr... Second extract from correlation matrix tool

   1

   print("Setting dataframe index")

   2

   dataframes = [df.set_index("date", drop=True) for df in dataframes]

   3

   4

   print("Merging dataframes")

   5

   merged = pd.concat(dataframes, axis=1, keys=range(len(dataframes)), join='outer', copy=False)