Join the 80,000 other DTN customers who enjoy the fastest, most reliable data available. There is no better value than DTN!

(Move your cursor to this area to pause scrolling)




"Just a thank you for the very helpful and prompt assistance and services. You provided me with noticeably superior service in my setup compared to a couple of other options I had looked at." - Comment from John
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"I have been using IQFeed now for a few years in MultiCharts and I have zero complaints. Very, very rare to have any data hiccups or anything at all go wrong." - Comment from Public Forum
"I just wanted to tell you what a fine job you have been doing. While *******, from what I hear, has been down and out, off and on, IQ feed has held like a champ this week." - Comment from Shirin
"I am a hedge fund manager here. It’s funny, I have a Bloomberg terminal and a Bridge feed, but I still like having my DTN feed!" - Comment from Feras
"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum
"Version 4.0.0.2 has been working well for me and I appreciate that it is now a much tighter client to work with. I feel I can go to press with my own application and rely on a stable platform" - Comment from David in IA.
"I've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
"I "bracket trade" all major news releases and I have not found one lag or glitch with DTN.IQ feed. I am very comfortable with their feed under all typical news conditions (Fed releases, employment numbers, etc)." - Comment from Public Forum
"I was on the phone with a friend who uses CQG and right after the Fed announcement, CQG was as much as 30 seconds behind DTN.IQ. Some quotes were off by as much as 15-18 cents. Your feed never missed a beat." - Comment from Roger
Home  Search  Register  Login  Blogs Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTN_IQFeed on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »IQFeed Developer »IQFeed Developer Support »Historical data requests in 64-bit VBA
Author Topic: Historical data requests in 64-bit VBA (8 messages, Page 1 of 1)

jonnyb
-DTN Evangelist-
Posts: 112
Joined: Aug 15, 2012


Posted: Aug 6, 2013 09:13 AM          Msg. 1 of 8
Hello,

About a year ago I posted about retrieving historical data in VBA. At the time, some upgrades needed to happen to the client before it would work, but the bigger issue was that it was only 32-bit compatible. Is it now possible to do it in Excel 2010 64-bit?

DTN_Steve_S
-DTN Guru-
Posts: 2042
Joined: Nov 21, 2005


Posted: Aug 6, 2013 09:28 AM          Msg. 2 of 8
Unfortunately our COM interfaces are only available via 32bit binaries which makes them inaccessible to 64bit applications. COM is the only way to get the data into VBA natively.

Alternatively, you can use sockets to communicate with IQFeed across the 32bit/64bit application boundries but socket libraries/implementations for VBA are pretty few and far between.

jonnyb
-DTN Evangelist-
Posts: 112
Joined: Aug 15, 2012


Posted: Aug 6, 2013 09:58 AM          Msg. 3 of 8
Thanks Steve. Bummer. Any plans to introduce some 64bit COM interfaces?

DTN_Steve_S
-DTN Guru-
Posts: 2042
Joined: Nov 21, 2005


Posted: Aug 6, 2013 10:00 AM          Msg. 4 of 8
None at this time.

DTN_Steve_S
-DTN Guru-
Posts: 2042
Joined: Nov 21, 2005


Posted: Aug 15, 2013 12:40 PM          Msg. 5 of 8
The latest beta we posted yesterday should allow you to use our COM interfaces within 64bit applications.

jonnyb
-DTN Evangelist-
Posts: 112
Joined: Aug 15, 2012


Posted: Aug 15, 2013 12:42 PM          Msg. 6 of 8
That's great, thanks for letting me know. I'll give it whirl later and see how it goes.

jonnyb
-DTN Evangelist-
Posts: 112
Joined: Aug 15, 2012


Posted: Jun 10, 2018 07:36 PM          Msg. 7 of 8
I never did get around to this and now I've forgotten how to even begin. Is there an example somewhere showing VBA and historical data pulls? Thanks.

DTN_Tim Walter
-DTN Guru-
Posts: 1238
Joined: Apr 25, 2006


Posted: Jun 11, 2018 05:36 AM          Msg. 8 of 8
Good morning,

I don't have anything VBA based unfortunately. I am sorry.

We have moved farther away from COM since the earlier posts. while it is there for backwards compatibility, we are not doing adding any new COM functionality. Based on this I would try to stick to the socket code outlined in the current documentation.

Tim
 

 

Time: Tue October 23, 2018 5:18 AM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003