Ok, Experts! Here's the big one:
1) I've created a Trading Application using Excel for XP 2002, which generates Signals in real-time.
2) The data for that Signal Engine sits inside Excel, in the form of OHLC, where each letter represents a Column Heading and each Row represents a "Bar" of data (as we call it in the financial markets), or what you database Experts call, a Record. Thus: Cell A1 (for example) would contain the OpenPrice, Cell B1 the HighPrice, Cell C1 the LowPrice and Cell D1 the ClosePrice. Row "1" is the first record, or "Bar" of data. Each Bar represents a Time-Interval. That Time-Interval (each Bar) is consistent no matter how many records (Rows) of OHLC data is stored.
3) You can think of the entire structure of Columns and Rows containing Bars of Open, High, Low and Close data, the same way you would a Database Table. Thus, the M5 Table contains the 5 Minute Bars of data in the OHLC format. the M15 Table contains the 15 Minute Bars of data in the OHLC format. the M30 Table contains the 30 Minute Bars of data in the OHLC format and so on - up through Table"X" containing the 1 Month Bars of data in the OHLC format. So, in all, there would be eight (8) Tables containing Bars of data in the OHLC format: M5, M15, M30, H1, H4, D1, W1 and MN1. All of these tables are now sitting inside Excel. BUT I WANT TO MOVE THEM.
If I were to create a new SQL Server Express database containing these eight (8) tables (M5 through MN1) where each Row (Record) contains four (4) numeric values in the form of the Open, High, Low and Close, how do give Excel full access to each table and each row (Record) within each table simultaneously?
With the data sitting inside Excel itself, I can easily use Cell Referencing inside all of my formulas, functions and all of the Macro scripts used to maintain and operate the Signal Engine. Thus, all calculations are performed in Excel locally. The FIRST ROW in each Table consists of data being piped in through DDE from a remote DDE Server. Row 2 and higher are all STATIC data. The "Real-Time" component of the database therefore, only applies to the FIRST ROW of data in the database.
That brings me to another question: Can I use DDE topic links inside a SQL Server Express database (for the Open, High, Low and Close on Row 1 of each Table)? If not, that's ok, I can still use the DDE links inside Excel for the first row, while giving Excel access to all other rows and tables via the method you show me here - if it is possible.
Thanks in advance for the help! I really need it. Ted