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

On Fri, 5 Nov 2010 08:54:06 -0700 (PDT), PC User
<(E-Mail Removed)> wrote:

>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/

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?

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