Answers to a Deficient trading database query
I sent out my trading database with a mention in a recent Meetup webinar I hosted. A query came up from a Meetup follower:
I reviewed your test database and I have few comments.1) have you considered normalizing the various security tables into a single table? The benefit will be realized once you need to deal with a common object which contains multiple instrument/security type. for example portfolio table. I have the design and I can send you the high level schema.
First, as I mentioned in my Meetup, this database is a lazy quick & dirty way to implement something to get it working so keep that in mind. I have seen quite a number of database schemas but please send it out.
2) How do you deal with the variety of tickers assigned to the same security. Example: Google or Yahoo can assign different ticker to the same index.
The best way to treat each security in its own table for optimal performance
3) can you point me o a sample code which provide new ticker for IPO. Currently I use a process which inserts into the database new tickers only at the End of trading day. This is done only once my program realizes that a new ticker is in the daily feed, but does not exist in the ticker list. I prefer to be pre-emptive and detect IPO ahead of time, not after the fact.
These are hard to find. As mentioned, I would think maybe IQFeed has it in their news where you need to filter. I am sure there maybe there are some online databases if you search via Google.
You mentioned that IB is providing such an IPO feed. However, I’m looking for a free feed.
Thanks to him for askingFACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!