Hello all,
I have a client application which streams financial data to my pc. I can then have the same real time streaming data sent to excel (although I don't think it is DDE -- perhaps the data is being sent directly to the cells as a simple value). Because I have different market data streaming into the same worksheet the columns for each section vary, but as an example, the currency data section has the following columns: A2 - Currency, D2 - the bid, E2 - ask, F2 - high, G2 - low, H2 - close, I2 - net change, J2 - net pct change, K2 - yearly bid high, L2 - Pct Chng 3 Mon, and M2 - Pct Chng 6 Mon.
The worksheet name is Market Watch. The range address starts at A2 to M2 (columns B2 and C2 are hidden as they are unnecessary).
I want to capture the data as it changes i.e as a new price comes in for each quote. Also, something I'm not sure about is that I might want to use the data in my own charting package at some point so would I need to get a time stamp added automatically (excel can do this?) for each price but does excel have a function for millisecond time stamps or is there another way to do this?
The data I want to capture should just go to worksheet 2, AKA Market Watch Saved and basically have the same column names. Realistically & ideally I would prefer this data to go directly into Access but I don't know if it's possible to capture the data from excel and send it directly into Access, is it?!?!
Thanks for reading and hopefully your help!
Cheers,
Venge.
I have a client application which streams financial data to my pc. I can then have the same real time streaming data sent to excel (although I don't think it is DDE -- perhaps the data is being sent directly to the cells as a simple value). Because I have different market data streaming into the same worksheet the columns for each section vary, but as an example, the currency data section has the following columns: A2 - Currency, D2 - the bid, E2 - ask, F2 - high, G2 - low, H2 - close, I2 - net change, J2 - net pct change, K2 - yearly bid high, L2 - Pct Chng 3 Mon, and M2 - Pct Chng 6 Mon.
The worksheet name is Market Watch. The range address starts at A2 to M2 (columns B2 and C2 are hidden as they are unnecessary).
I want to capture the data as it changes i.e as a new price comes in for each quote. Also, something I'm not sure about is that I might want to use the data in my own charting package at some point so would I need to get a time stamp added automatically (excel can do this?) for each price but does excel have a function for millisecond time stamps or is there another way to do this?
The data I want to capture should just go to worksheet 2, AKA Market Watch Saved and basically have the same column names. Realistically & ideally I would prefer this data to go directly into Access but I don't know if it's possible to capture the data from excel and send it directly into Access, is it?!?!
Thanks for reading and hopefully your help!
Cheers,
Venge.
