LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Storing an array in a cell Blue Max Excel Worksheet Functions 9 March 18th 09 12:54 PM
Storing data and its format jodleren Excel Discussion (Misc queries) 0 March 30th 07 01:26 PM
storing data JK57 Excel Worksheet Functions 3 May 1st 06 12:16 AM
Storing data Bob Mckenzie New Users to Excel 3 July 30th 05 07:33 PM
Storing non-user data ChrisJForeman Excel Programming 1 November 22nd 03 05:55 PM


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"