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)




"IQFeed version 4 is a real screamer compared to anything else I have seen." - Comment from Tom
"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken
"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"I've been using IQFeed 4 in a multi-threaded situation for the last week or two on 2600 symbols or so with 100 simultaneous daily charts, and I have had 100% responsiveness." - Comment from Scott
"My broker in Davenport suggested I give you a try as he uses your service and says its the best." - Comment from Bill via RT Chat
"Everything is working great ! Very impressive client. The news refreshes better and is more pertinent than the ******* feed I paid $ 100/month for. I Also like the charts a lot." - Comment from Leon
"There is no doubt that IQFeed is the best data provider. I am very satisfied with your services. And IQFeed is the only one that I would recommend to my friends. Now, most of them are using your product in China." - Comment from Zhezhe
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
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: 111
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: 2036
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: 111
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: 2036
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: 2036
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: 111
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: 111
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: 1181
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: Sun June 24, 2018 5:02 PM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003