I'm an amateur programmer. I'd like to develop a software application to analyze real-time market data notably derivatives, futures,options (like the interface provided by stock trading firms ). Please teach me if the following approach is correct, ie the knowledge or software needed etc:
1. Use a DB to read the real-time feed from data provider : what should be the right DB to
use. I know it should be a time-serious one. SQL, Mysql, oracle or others ?
2. If the real-time data is ASCII, how can it be converted to those that can be read by
the DB and then my window application(with GUI) for calculation and analysis ? Should I have
to write codes or just use some add-ins ?
3. How should i code the program to retrieve the changing data in the data base so that
the analysis software screen data also asynchronously ? (like the RTD in excel )
4. Which other aspects of programming / knowledge do I need to learn to develop the above ?
5. Some people suggest using c#, c+ or C++ because they are for real-time application. Yet, I know some famous software (like the Optionvue ) was written by Pascal. Pascal / Delphi offers RAD IDE which speeds up developing time.
6. Are there web resources/ books I can refer to for more information ?