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)




"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 noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah
"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
"I started a trial a few weeks back before the market went wild. DTN.IQ didn’t miss anything and beat my other provider. I decided to stay with you because of the great service through all the volatility." - Comment from Mike
"I ran your IQFeed DDE vs. my broker vs. a level II window for some slow-moving options. I would see the level II quote change, then your feed update instantaneously. My broker's DDE, however, would take as much as 30 seconds to update. I am not chasing milliseconds, but half a minute is unacceptable." - Comment from Rob
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"This is an excellent value, the system is generous (allowing for 500 stocks) and stable (and really is tick-by-tick), and the support is fantastic." - Comment from Shirin via Email
"Thank you so much - awesome feed, awesome service!" - Comment from Greg via Email
"IQFeed version 4 is a real screamer compared to anything else I have seen." - Comment from Tom
"I will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
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: Fri May 3, 2024 8:58 PM CFBB v1.2.0 12 ms.
© AderSoftware 2002-2003