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.