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

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/...php?t=envbadac

--
Regards,
Tom Ogilvy

"dwt" wrote in message
...
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

Tom,

thanks, that gives me a place to get started..

d

"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/...php?t=envbadac

--
Regards,
Tom Ogilvy

"dwt" wrote in message
...
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

Hi David,

I too have an Excel spreadsheet which gets streaming data for
currencies, but I am not able to get previous day's OHLC,
are you able to get those info ?
Can you please tell me how I can do it.

Thanks.
Mukesh


"dwt" wrote:

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

Hello.
Did you resolve the issue? I would be grateful to receive a soultion on how
to fire a macro on DDE data update.

"dwt" wrote:

Tom,

thanks, that gives me a place to get started..

d

"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/...php?t=envbadac

--
Regards,
Tom Ogilvy

"dwt" wrote in message
...
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

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/...php?t=envbadac

--
Regards,
Tom Ogilvy

"dwt" wrote in message
...
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