Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Storing an array in a cell | Excel Worksheet Functions | |||
Storing data and its format | Excel Discussion (Misc queries) | |||
storing data | Excel Worksheet Functions | |||
Storing data | New Users to Excel | |||
Storing non-user data | Excel Programming |