I'm currently using FileMaker to store historical stock market index quotes. I like FM because I don't have to get involved with designing an interface at a low level. It also experts and imports text ASCII files easily. Importing data to update/add to existing data works nicely. It suites my needs for most queries but some it doesn't.
Some of the queries I need to run are:
1.) Show all days in SP500 that rallied 50pts or more.
2.) Show previous day (-1 day)of each result that also rallied 50pts or more.
3.) Show -2 day that was negative by 20 pts.
The above queries starts with #1 then builds on that to get #2 and the same to get #3. One result from the above query might look like:
4/5=51pts, 4/4=56pts, 4/3=-23pts
But there may be several similar 3 day results but in different time periods (months/years). Just meaning, it may bring back 10 results.
Another type of query is the above plus bring back +1 day. So the above result would look like:
4/6=30pts, 4/5=51pts, 4/4=56pts, 4/3=-23pts
Even though 4/6 doesn't match the pt criteria, it is the day after 4/5.
Which software will do the above queries but still have some of the FileMaker characteristics mentioned above? I'm fine with some low level programming.
Oracle DatabaseMicrosoft SQL Server 2005FileMaker Pro
What are you "storing" them in?