About Dynamic Data Exchange

[PC User]

Microsoft has a dll that will allow MS Excel to link with the
ThinkOrSwim trading platform to retrieve live stock data. I'm trying
to find a way to do the same with MS Access. Does anyone know how to
do this?

References:
About Dynamic Data Exchange
http://msdn.microsoft.com/en-us/library/ms648774

DDE DATA PLUGIN
http://www.amibroker.com/dde.html

 

[Tony Toews]

Microsoft has a dll that will allow MS Excel to link with the
ThinkOrSwim trading platform to retrieve live stock data. I'm trying
to find a way to do the same with MS Access. Does anyone know how to
do this?

Code that works in Excel should work in Access with changes to fit the
Access object model than Excel.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

 

[PC User]

I don't know how to do the link in either Excel or Access. In Access
would I do this in code or is there a menu item that I would use to
link to the dll? Its not an Add-In, so there must be some other way.
Does anyone know of an example of Access connecting with a dll?

 

[PC User]

I already have a working sample database that links with Yahoo Quotes;
however, that is for delayed data. I'm trying to link with the
ThinkOrSwim trading platform to use its real time data. I appreciate
your replies; however, to understand my request I've included a link
that explains the process that Amibroker uses. This works, because
I've used it. The article states that it can be done with Excel;
however, it doesn't say how or give an example spreadsheet. Like you
say, if it can be done in Excel then it can be done in Access. I have
found not samples in either Excel or Access; so I'm posting a request
for information specifically on how to do it with a link to an
example. If no one has a specific answer, maybe someone can refer me
to an Access forum that can help me.

Real Time Dynamic Data Exchange
http://www.amibroker.com/dde.html

Regards,
PC User

 

[sgfee123]

PC User wrote on 11/05/2010 16:53 ET

I already have a working sample database that links with Yahoo Quotes
however, that is for delayed data. I'm trying to link with th
ThinkOrSwim trading platform to use its real time data. I appreciat
your replies; however, to understand my request I've included a lin
that explains the process that Amibroker uses. This works, becaus
I've used it. The article states that it can be done with Excel
however, it doesn't say how or give an example spreadsheet. Like yo
say, if it can be done in Excel then it can be done in Access. I hav
found not samples in either Excel or Access; so I'm posting a reques
for information specifically on how to do it with a link to a
example. If no one has a specific answer, maybe someone can refer m
to an Access forum that can help me

Real Time Dynamic Data Exchang
http://www.amibroker.com/dde.htm

Regards
PC Use

A clever spreadsheet using Thinkorswim, DDE and Excel. Page to near the end o
the thread and find

Dynamic Data Exchange (DDE) with Thinkorswim and Exce

The attachment is called: excel-dde-v2.xl

http://www.elitetrader.com/vb/showthread.php?threadid=223105