Discussions

Hi,

This is a following question of:

https://docs.deweydata.io/discuss/69bcbc453b7a8bfbe99e289a

I understand ‘XOM-MOBIL’ and ‘XOM’ both refer to Exxon Mobil. But XOM-MOBIL is not the stock exchange ticker and it mixes with some custom tickers like 'NURSING-A' and 'MALL-A' in weekly patterns plus. A valid exchange-traded tickers reference list such as "https://www.sec.gov/files/company_tickers_exchange.json" will miss POIs with tickers like ‘XOM-MOBIL’ because of the 'hyphen'. The ConsumerEdge’s Company Detail dataset suggested by you still has wrong ticker symbols with extra hyphen which make it hard to use directly. What is your suggestion on extracting POIs related to all public companies and their clean stock exchange tickers?

One more question: As I know, Advan weekly patterns is based on SafeGraph. Does the weekly patterns plus has changed any company or brand information? If the POIs and companies are the same in Advan weekly pattern plus and SafeGraph, I can use the company name in SafeGraph Brand Info dataset to screen valid public companies in weekly patterns plus because the Brand Infor dataset has correct stock tickers.