PDA

View Full Version : Solved: Recording changes in values



Grantx
11-19-2007, 11:21 AM
Please refer to the attachment.

This is a sequence of values over a time period. Ignore the figures in the centre columns.

As you can see, the figures either side of the columns vary over time. For example, the change on the previous in the top right figure in red is ?5. Values can also increase ? first figure in left column has gone from 82 t0 184 (+182).

Is it possible to determine a change in a cell?s value from its previous value (and inserted to the next column ? left/right)?

Presumably this would entail ?remembering? or temporarily retaining - I have seen this directly in Excel but can?t remember the details.

I have included part of the code below if it helps.

There is a related, but separate, question which I will post in due course.

Any suggestions greatly appreciated.

Grant.


Else
Buy1 = .FeedFields(FFBuy1): BidSize = .FeedFields(FFBidSize)
Sale1 = .FeedFields(FFSell1): AskSize = .FeedFields(FFAskSize)
'---
ExcelDoc.Sheets(1).Cells(nRow, 3).Value = Buy1
ExcelDoc.Sheets(1).Cells(nRow, 4).Value = Sale1
ExcelDoc.Sheets(1).Cells(nRow, 5).Value = BidSize
ExcelDoc.Sheets(1).Cells(nRow, 6).Value = AskSize
ExcelDoc.Sheets(1).Cells(nRow, 7).Value = .Close(0, Data)
ExcelDoc.Sheets(1).Cells(nRow, 8).Value = .Volume(0, Data)
'---
ExcelDoc.Sheets(1).Cells(13, 14).Value = BidSize 'Bid volume
ExcelDoc.Sheets(1).Cells(14, 14).Value = .LimitVol(2, osBuy, 0, Data)
ExcelDoc.Sheets(1).Cells(15, 14).Value = .LimitVol(3, osBuy, 0, Data)
ExcelDoc.Sheets(1).Cells(16, 14).Value = .LimitVol(4, osBuy, 0, Data)
ExcelDoc.Sheets(1).Cells(17, 14).Value = .LimitVol(5, osBuy, 0, Data)
ExcelDoc.Sheets(1).Cells(18, 14).Value = .LimitVol(6, osBuy, 0, Data)
ExcelDoc.Sheets(1).Cells(19, 14).Value = .LimitVol(7, osBuy, 0, Data)
ExcelDoc.Sheets(1).Cells(20, 14).Value = .LimitVol(8, osBuy, 0, Data)
ExcelDoc.Sheets(1).Cells(21, 14).Value = .LimitVol(9, osBuy, 0, Data)
ExcelDoc.Sheets(1).Cells(22, 14).Value = .LimitVol(10, osBuy, 0, Data)

Bob Phillips
11-19-2007, 11:30 AM
That would be done by using change event code, but that would be within Excel, not from within some automation as yours seems to be.