Saving tick data
in [Programming]
|
Prev: Importing and exporting sheets from spreadsheets
Next: Recommended Web based or DVD VBA Programming Course
From: Saving tick data from dde Saving tick data from on 17 Dec 2009 14:51 Hi, Can any one elabrote how "SetLinkOnData" can be used ... I want to save the tick by tick data i m getting in excel by DDE. Pls help me out as i am not a programmer JAldeep "Tom Ogilvy" wrote: > See the SetLinkOnData method of the workbook if you want to fire a macro to > do the saving. In xl2000 and later you can use the newer Change event. > > What you do with the data is your own choice. > > Some information on working with Access: > > > http://www.erlandsendata.no/english/index.php?t=envbadac > > -- > Regards, > Tom Ogilvy > > "dwt" <dwt(a)discussions.microsoft.com> wrote in message > news:65EEB8DF-3DD6-4291-9836-69C36A6B4468(a)microsoft.com... > > I have an Excel spreadsheet which gets tick data for trading currencies on > > the forex markets. The DDE conversation works just fine, but i need a way > to > > save this data. Does anyone have any experience working in this > enviornment > > and do you have any suggestions. I think it might be best to save the data > to > > an SQL or Access database. > > > > Any thoughts or help with this would be appreciated. > > > > david > > > |