I was following your guidance to use the following items for PE: TR.FwdPE or TR.RelValPENTM (for PE NTM).
However, I got 2,091 missing PE values when using TR.FwdPE for the 2,930 tickers that I tried to pull data for. TR.RelValPENTM also has more than 2,000 missing values. May I just kindly know if that’s the best I can have for PE, or if I’m missing something? Or do those stocks just not have forecasted PE? (They are from I/B/E/S?)
I’m attaching my code and the tickers I am using to identify stocks, as well as the list of tickers I’m interested in. Is it better to use RICs than identifier to pull data via API? (And since I’m using tickers, should I find the bridge between RIC and ticker first?). I would appreciate being corrected if I’m wrong.