troubleshooting Question

Which database can do this search?

Avatar of brettr
brettr asked on
Oracle DatabaseMicrosoft SQL Server 2005FileMaker Pro
18 Comments1 Solution508 ViewsLast Modified:
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.

Will Loving
President, Dedication Technologies, Inc.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros