Trading system database design

A public forum for discussing the design of software, from the user interface to the code architecture. FogBugz Documentation and Support Get Help Now Contact Design Keyboard Shortcuts About FogBugz. Home Discuss Jobs About. The trading of Software" discussion group has been merged with the main Joel on Software discussion group. The archives will database online indefinitely. Online trading database If you had to implement an online trading system would you use the stock symbol trading the id to link the trading stocks, orders, transactions, portfolio, etc?

Note that the symbol is very short 3 to 5 chars - maximum Don't use Symbols as system. If a stock is suspended temporarily, its symbol changes. If a company is bought, its symbol may change. SE system to benow is private and somebody else uses that symbol. Warlock Tuesday, March 06, I agree with Warlock, using the symbol is a bad idea - system if you're planning on including securities traded on exchanges in several countries. The three main 'standard' ids for securities are CUSIP, SEDOL and ISIN.

CUSIPs are typically used on US exchanges and SEDOLs on the UK and Database exchanges although system seem to be used for most non-US exchanges. Database ISIN is the latest design, designed to be useful for all exchanges although there seem to be some implementation issues.

The Wikipedia has database on all three: RocketJeff Tuesday, March 06, While it has drawbacks database belowthey are relatively design and easily dealt with. If you trading a different identifier you will spend much time translating back and system. BillT Tuesday, March 06, design You use the symbol and country, trading, etc to communicate to the user. The identifier is used both within the system and as the preferable way of identifying the design when communicating to external systems i.

This way the changes to security trading don't impact the entire system - just what the user sees. If the system is only used design an in-house trading system, you might not even have to follow every symbol change NASDAQ symbols have characters database SEC filings system late or based on the financial status of the company. If you get into options, symbols become much more problematic.

For one system, the symbol for design option is often the same as the symbol for an unrelated stock even in the same country. And symbols for a given option change all the time for design reasons. Greg Tuesday, March 06, Why is "never use external identifiers as a database id" so hard for people to grasp?

It does not hurt you in the least to follow it trading, and it saves your bacon so many times it's like "look both ways before crossing the street," or "wash your hands after going to the bathroom. Art Wednesday, March 07, Matt Wednesday, March 07, Thanks guys, I did choose the System route already, but needed more opinions to make sure it is ok. The ids I've worked with are described in http: They're pretty standard and most of the world trading be able to translate them into their local representation.

Katie Lucas Thursday, March 08, Use a surrogate integer id! Steve Moyer Thursday, March 08, If you're not competent to do some simple data modelling like this without consulting a message board, why the hell are you presumably getting paid a fortune to implement trading systems? Booo Saturday, March 10, Well, at least he's looking for information about the best way to do it - I wish the people that wrote several of the very successful trading systems I used had done that.

The last systems I system with very costly and highly recommended stored dates as character strings MM-DD-YY databaseuses floats to store currency database, sometimes stores characters in integer fields i. RocketJeff Monday, March 12, Just because something is programaticaly easy doesn't mean that it's either a good idea or an efficient database. This might apply nowhere as much as it does in relational databases.

David Aldridge Wednesday, March 14, trading Just amazed at the level of detail doing things correctly can require. This topic is archived. No further replies design be accepted. RSS Feed The Design of Software CLOSED A public forum for discussing the design of software, from the user interface to the code architecture.