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)




"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy via Email
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"DTN feed was the only feed that consistently matched Bloomberg feed for BID/ASK data verification work these past years......DTN feed is a must for my supply & demand based trading using Cumulative Delta" - Comment from Public Forum Post
"I have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim
"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
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post
"Thank God for your Data Feed as the only Zippers I see are on my pants (LOL), and no more 200 pip spikes to mess up charts." - Comment from Spiro via Email
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"Boy, probably spent a thousand hours trying to get ******* API to work right. And now two hours to have something running with IQFeed. Hmmm, guess I was pretty stupid to fight rather than switch all this time. And have gotten more customer service from you guys already than total from them… in five years." - Comment from Jim
Home  Search  Register  Login  Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »Archive (2017 and earlier) »DTN.IQ Client Software Support »Using function in DLLs from EXCEL
Author Topic: Using function in DLLs from EXCEL (1 messages, Page 1 of 1)

TLikins
-Interested User-
Posts: 32
Joined: Jul 11, 2005

Howdy


Posted: Oct 6, 2005 10:14 AM          Msg. 1 of 1
I'm trying to lookup symbols using a function in one of the DTN libraries.
The reference manual specifies the way to call these function.
1. Enable the lib in the references (check)
2. Declare sub or function - here'e mine.
Private Declare Sub LookupSymbol Lib _
"C:\Program Files\DTN\IQFeed\DTNSymbollookup" (Symbol As String, Results As String)

Sub getsymbol()
Dim Symbol As String
Dim Results As String
Symbol = "IBM"
Call LookupSymbol(Symbol, Results)
Debug.Print Results
End Sub


3. Step into sub.
4. Fails at Call - Error message states:

Run-time error '453'
Can't find DLL entry point LookupSymbol in C:\Program Files\DTN\IQFeed\DTNSymbollookup.

I've tried variation in these parameters but it's not working.
Any ideas about what's wrong?

Thanks for your help!
 

 

Time: Sun May 5, 2024 4:35 AM CFBB v1.2.0 7 ms.
© AderSoftware 2002-2003