Hi there, I'm about to start a project I have been thinking about for a long while. I basically wish to analyse stock market data. I already have the data in a table and I'm now in the process of writing my own indicators and oscillators. I hope to learn while re-inventing this wheel and perhaps explore different things unavailable in most stocks analysis software I found.
I would love to do an sql query that would look like the following ones. I wonder if they are possible and valid applications for SQL and what would be the proper implementation for these. I know I can calculate all this using C, but it would be most useful (to my later projects) to do it in SQL directly (my last example gives you an idea where I'm going). select max(opening_price, closing_price, high_price) - min(opening_price, closing_price, low_price) as day_range... select closing_price, moving_average(20,closing_price), exp_mov_avg(20,closing_price)... select closing_price, moving_average( funky_oscillator( closing_price ) )... I think creating a module and using virtual tables may be an idea... but doing the above selects would involve some serious twists I think. What I'd need are virtual functions or something like that... Can you guys confirm with me whether I'm asking too much and I should concentrate on a C or C++ implementation of my functions, or is there a way to make it happen in sqlite? Thanks, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
