storing financial data in array
 

Hi,

I need to store some financial data from an application that will always
return the latest price. As I need to store this latest price for about 10
different contracts (whose contract name will change over time as different
contracts expire), would it be possible to create some type of array for
this purpose?

Or can an array not be used like this? Any suggestions are welcome.

Example
The application will fire the following event whenever there is a new price.
It returns Price,Volume,Time,Contract.
Where in this example contract would be EUA or JYA.

LastPrice(EUA)="9944"
LastPrice(JYA)="00976"

Thanks.

storing financial data in array
 

You can use:


ActiveWorkbook.Names.Add Name:="UK_Rate", RefersToR1C1:="=1.62"

and whanever the UK rate changes, change from 1.62 to the new rate.


you can use as well one array
check this sub:

Sub Macro3()
'(UK,Italy,Portugal, Chile, France, Spain,Germany...)
Dim Rates
Rates = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
'when a new value comes for "UK"
Rates(0) = 5
End Sub

if you know
rates(0) belong to "UK rate" when the new value comes
rates(0)=5, if 5 is the new valu

--
Message posted from http://www.ExcelForum.com