I am attempting to design a simple reporting feature for some financial market data.
I have a few sets of data, and I am trying to figure out what will be the best way to organize the tables, in particular for reporting.
I am using Microsoft SQL Server Express, which I am comfortable with for simple tasks and I've designed a few reports.
I have one table with
Trade data, which is basically a log, with
Profit and some other information. Simple and easy.
I want to link each trade entry with some data specific to that entry. For example, in my Trade Table, I might have 200 entries. Each entry, however has pricing data from before and after the trade date that I would like to get.
I want to produce a report that lists the trade data, adjusted for parameters which I can do. The report could display a graph to show trade specific data that is more detailed than can just be fit in columns from the current record.
Any ideas or references to check out would be greatly appreciated.