I intend to create a database with Historical OHLC data. This data will be used by analysis software like Amibroker. I would like to know a general guideline on how to design the database for the aforementioned use case.
I have a doubt regarding the following:
Since the database intends to be "forever", I will need a unique identifier for each tables. From a previous discussion, I realize it should be 'Exchange:TradingSymbol'. Is it still the best way?
I am not interested in bonds. But the instrument list includes bonds under segment 'NSE'. I am having a hard time filtering out bonds. Any advice on how to filter out bonds from instrument list?
Please advice me on the above. Any other advice regarding above is highly appreciated. Thanks.
