Modify the bulk script to store results for a large (index scale) number of stocks in a postgresql database, so that we can get both the historical carbon betas and their trends (increasing or decreasing) for all the stocks in an index universe.
From this, we can find stocks to construct the BMG index factor and then determine, through studying their disclosures and #4, which ones should be part of the BMG index going forward based on their positive (Brown) and negative (Green) carbon betas and the trends in those betas (declining trend means they are becoming less sensitive and would more likely be excluded.)
Modify the bulk script to store results for a large (index scale) number of stocks in a postgresql database, so that we can get both the historical carbon betas and their trends (increasing or decreasing) for all the stocks in an index universe.
From this, we can find stocks to construct the BMG index factor and then determine, through studying their disclosures and #4, which ones should be part of the BMG index going forward based on their positive (Brown) and negative (Green) carbon betas and the trends in those betas (declining trend means they are becoming less sensitive and would more likely be excluded.)