Answers to a Deficient trading database query

(Last Updated On: May 28, 2015)

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 asking
NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Subscribe For Latest Updates

Sign up to best of business news, informed analysis and opinions on what matters to you.
Invalid email address
We promise not to spam you. You can unsubscribe at any time.


Check NEW site on stock forex and ETF analysis and automation

Scroll to Top