[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Re: Excel DDE Link



PureBytes Links

Trading Reference Links

Ok, I'll post something when I get the time.
 
d

On Thu, Nov 13, 2008 at 4:28 PM, tipequity <l3456@xxxxxxxxxx> wrote:
Hi Dingo, I think I can use IB's DDE link to get price data for US
equities and options  to Excel 2007. I'll know by this weekend.
Therefore at this time using ole to get prices from AB to excel is
only of intellectual curiosity vs necessity. If you have the time, I
would love to see how it is done. TIA

--- In amibroker@xxxxxxxxxxxxxxx, dingo <waledingo@xxx> wrote:
>
> So what do need in terms of help?  What version of XL are you using?
>
> Lets take this via private mail so we don't clog up the form. You
can get my
> email address from my Yahoo profile.
>
> d
>
> On Thu, Nov 13, 2008 at 1:17 AM, tipequity <l3456@xxx> wrote:
>
> > Dingo, I would appreciate any help that you could provide with
OLE.
> > TIA
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, dingo <waledingo@> wrote:
> > >
> > > Its much faster and more reliable. As to your option problem - I
> > don't have
> > > enuf experience with options to comment.
> > >
> > > If you need help with the OLE part for Excel then I'll be glad
to
> > help.
> > >
> > > d
> > >
> >  > On Wed, Nov 12, 2008 at 10:37 PM, tipequity <l3456@> wrote:
> > >
> > > > Thanks for the suggesion Dingo. What is the advantage of using
> > ole vs
> > > > ddl? I have equity prices in AB but not option prices. I don't
> > know
> > > > if it makes sense to have option chains in AB!
> > > >
> > > > --- In amibroker@xxxxxxxxxxxxxxx, dingo <waledingo@> wrote:
> > > > >
> > > > > If your data is in AB you can get it to excel via OLE and
not
> > have
> > > > to use
> > > > > dde.
> > > > >
> > > > > d
> > > > >
> > > >  > On Wed, Nov 12, 2008 at 9:15 PM, tipequity <l3456@> wrote:
> > > > >
> > > > > > Thanks Brian, it seems interactive broker has dde link to
> > excel. I
> > > > > > use excel to make certain calculations to see which
options to
> > > > buy or
> > > > > > sell.
> > > > > >
> > > > > > --- In amibroker@xxxxxxxxxxxxxxx, "brian_z111"
<brian_z111@>
> > > > wrote:
> > > > > > >
> > > > > > > Who doesn't provide DDE access?
> > > > > > >
> > > > > > > You can google a URL quicker than you can write a post;-
)
> > > > > > >
> > > > > > > I'll trade you my links for your info ....
> > > > > > >
> > > > > > > what are you going to use Excel for that you can't do
in AB?
> > > > > > >
> > > > > > > http://www.iqfeed.net/index.cfm?
> > > > displayaction=data&section=services
> > > > > > >
> > > > > > > http://www.esignal.com/esignal/features.aspx#
> > > > > > >
> > > > > > >
> > > > > >
> > > >
> >
http://www.interactivebrokers.com/php/apiUsersGuide/apiguide/excel/dde
> > > > > > > _for_excel.htm
> > > > > > >
> > > > > > >
> > > > > > > brian+z
> > > > > > >
> > > > > > >
> > > > > > > --- In amibroker@xxxxxxxxxxxxxxx, "tipequity" <l3456@>
> > wrote:
> > > > > > > >
> > > > > > > > Is anybody aware of a broker that provides streaming
US
> > equity
> > > > > > and
> > > > > > > > option prices via a DDE link to excel spreadsheet? Or
> > perhaps
> > > > a
> > > > > > > data
> > > > > > > > provider that has a plugin for AB and a DDE link for
> > excel!
> > > > TIA
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ------------------------------------
> > > > > >
> > > > > > **** IMPORTANT ****
> > > > > > This group is for the discussion between users only.
> > > > > > This is *NOT* technical support channel.
> > > > > >
> > > > > > *********************
> > > > > > TO GET TECHNICAL SUPPORT from AmiBroker please send an e-
mail
> > > > directly to
> > > > > > SUPPORT {at} amibroker.com
> > > > > > *********************
> > > > > >
> > > > > > For NEW RELEASE ANNOUNCEMENTS and other news always check
> > DEVLOG:
> > > > > > http://www.amibroker.com/devlog/
> > > > > >
> > > > > > For other support material please check also:
> > > > > > http://www.amibroker.com/support.html
> > > > > >
> > > > > > *********************************
> > > > > > Yahoo! Groups Links
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > **** IMPORTANT ****
> > > > This group is for the discussion between users only.
> > > > This is *NOT* technical support channel.
> > > >
> > > > *********************
> > > > TO GET TECHNICAL SUPPORT from AmiBroker please send an e-mail
> > directly to
> > > > SUPPORT {at} amibroker.com
> > > > *********************
> > > >
> > > > For NEW RELEASE ANNOUNCEMENTS and other news always check
DEVLOG:
> > > > http://www.amibroker.com/devlog/
> > > >
> > > > For other support material please check also:
> > > > http://www.amibroker.com/support.html
> > > >
> > > > *********************************
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> > ------------------------------------
> >
> > **** IMPORTANT ****
> > This group is for the discussion between users only.
> > This is *NOT* technical support channel.
> >
> > *********************
> > TO GET TECHNICAL SUPPORT from AmiBroker please send an e-mail
directly to
> > SUPPORT {at} amibroker.com
> > *********************
> >
> > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> > http://www.amibroker.com/devlog/
> >
> > For other support material please check also:
> > http://www.amibroker.com/support.html
> >
> > *********************************
> > Yahoo! Groups Links
> >
> >
> >
> >
>



------------------------------------

**** IMPORTANT ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

*********************
TO GET TECHNICAL SUPPORT from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
*********************

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html

*********************************
Yahoo! Groups Links

<*> To visit your group on the web, go to:
   http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
   Individual Email | Traditional

<*> To change settings online go to:
   http://groups.yahoo.com/group/amibroker/join
   (Yahoo! ID required)

<*> To change settings via email:
   mailto:amibroker-digest@xxxxxxxxxxxxxxx
   mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
   amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
   http://docs.yahoo.com/info/terms/


__._,_.___

**** IMPORTANT ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

*********************
TO GET TECHNICAL SUPPORT from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
*********************

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html

*********************************




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___