Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing Steaming Data Macro problem?
Hello everyone... I am trying to capture the highest high and lowest low in streamin data. What I have done is not working correctly and I am at a loss ho to correct it, here are the results: I am using this: If bid < oldlo Then lo = bid End If oldlo = lo If ask oldhi Then hi = ask End If oldhi = hi I thought this would capture and latch the highest Hi value and lowes low of the stream and increment each time a new hi was or lo wa reached. Instead of latching it, it enters the data request string, <=edemo|tik!id558?ask into the cell and it does not latch the data a I expected it should, it enters the ask string rather than a value... I dont think it is possible to latch anything in the spreadsheet and t the best of my knowledge vb is the only way to accomplish this. I am very lost on how to handle data in this manner. Does anyone have an idea how I can get streaming data to latch an paint an output to a cell that can be further operated on once i excel? a snipped version of the code is below... Dim bid As String Dim ask As String Dim hi As String Dim lo As String Dim oldhi As String Dim oldlo As String bid = server & topic & id & "bid" ask = server & topic & id & "ask" 'HOD and LOD If bid < oldlo Then lo = bid End If oldlo = lo If ask oldhi Then hi = ask End If oldhi = hi ActiveCell.offset(0, 2).Value = bid ActiveCell.offset(0, 3).Value = ask ActiveCell.offset(0, 7).Value = hi ActiveCell.offset(0, 8).Value = l -- rnrs ----------------------------------------------------------------------- rnrss's Profile: http://www.excelforum.com/member.php...fo&userid=2782 View this thread: http://www.excelforum.com/showthread.php?threadid=47492 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
capturing all of the data | Excel Worksheet Functions | |||
Capturing data using a formula | Excel Discussion (Misc queries) | |||
Capturing the selected tab in a worksheet_deactivate macro | Excel Programming | |||
Macro help in capturing server time | Excel Programming | |||
Help : Macro for capturing current system time | Excel Programming |