|
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'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.
"For anyone considering using DTN.IQ for a data feed, my experience with the quality of data and the tech support has been very positive." - Comment from Public Forum
"I just wanted to say how happy I am with your service. I was able to download the API docs last week and I was able to replicate Interactive Brokers historical bar queries and realtime bar queries over the weekend. That was about one of the fastest integrations that I've ever done and it works perfectly!!!!" - Comment from Jason via Email
"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
"You have an excellent product !!!!!!" - Comment from Arely
"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
"IQFeed version 4 is a real screamer compared to anything else I have seen." - Comment from Tom
"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
"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
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
|
|
|
|
Joined: |
Jul 26, 2023 11:31 AM |
Last Post: |
Aug 21, 2023 12:46 PM |
Last Visit: |
Aug 21, 2023 04:52 PM |
Website: |
|
Location: |
|
Occupation: |
|
Interests: |
|
|
|
jaesle has contributed to 6 posts out of 21119 total posts
(0.03%) in 132 days (0.05 posts per day).
20 Most recent posts:
Can someone explain the option data naming convention. I see that there's data for
AAPL2325H175
and I am guessing that this corresponds to:
AAPL 23 (year) 25 (day of the month) H (is this meant to be the month as the 8th letter in the alphabet?) 175 (strike price)
Is that a correct interpretation?
I found out I was using the wrong port. Should have been 9100...
I am having difficultly accessing historical data. When I send the command
HTX ,GOOG,5 or HTD,GOOG,1
All I get back are timestamps.
eg
T,20230817 15:12:44
What am I missing?
What I don't understand is that if I run the iQConnect app from my (slightly improved) code and then start a separate app with the socket connection, then it works.
But when I try and use this line
s = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
in the connect.py application (see below) then the connection is refused. Why does the line work in a separate application but not in the connect.py app?
Can you give me a hint as to another possible resolution?
Thanks!
=== connect.py file ===
import time import win32api
def readline(textfile): filename = textfile + '.txt' temp = open (filename,'r') content = temp.read() return content
product = readline('product') login = readline('login') password = readline('password')
iqfeed_args = ("-product %s -version 0.5 -login %s -password %s -autoconnect" % (product, login, password))
win32api.ShellExecute(0,'open', 'IQConnect.exe', iqfeed_args,'',1)
# give myself 10 seconds to start the other app time.sleep(10)
I figured it out. I created and ran a separate app that opens iQConnect and logs in, then I run my app and everything works fine.
If I have iQConnect running, then my app works.
However when I try and start iQConnect in my app, I can't connect and it says:
ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it
The log appears below. What am I missing?
Python code ===
import subprocess import socket
pr = open("product.txt", "r") product = pr.read() l = open("login.txt", "r") login = l.read() p = open("password.txt", "r") password = p.read()
subprocess.run(["IQConnect.exe","-product",product,"-version","0.5","-login",login,"-password",password,"-autoconnect"])
host = '127.0.0.1' port = 9300
s = socket.socket(socket.AF_INET, socket.SOCK_STREAM) s.connect((host, port))
===
=== IQConnect Log File Opened On Wed Jul 26 12:37:18 === Current Log Levels,Connectivity,Information,Admin Current IQFeed Version,6.2.0.25 STATUS Connectivity 21188 0 2023-07-26 12:37:18 Creating trader account verification thread. Status idle STATUS Connectivity 20540 0 2023-07-26 12:37:18 Initializing the login thread STATUS Connectivity 14916 0 2023-07-26 12:37:18 Getting login from registry: STATUS Connectivity 14916 0 2023-07-26 12:37:18 Getting Password from registry: (0 characters) STATUS Connectivity 14916 0 2023-07-26 12:37:18 Either login or password not saved. Clearing autoconnect and saveinfo flags STATUS Connectivity 20540 0 2023-07-26 12:37:18 Retrieving IP addresses. STATUS Connectivity 20540 0 2023-07-26 12:37:18 Connecting to server (login.interquote.com) on port 60020. STATUS Connectivity 20540 0 2023-07-26 12:37:18 Connect Process: Status 1. STATUS Connectivity 14916 0 2023-07-26 12:37:18 Processing Command Line STATUS Connectivity 20540 0 2023-07-26 12:37:18 Connect Process: Status 2. STATUS Connectivity 14916 0 2023-07-26 12:37:18 Received product ID from 3rd party application: (16 characters) STATUS Connectivity 14916 0 2023-07-26 12:37:18 Received product version from 3rd party application: (0.5) STATUS Connectivity 14916 0 2023-07-26 12:37:18 Received login from 3rd party application: (5xxxx0) STATUS Connectivity 14916 0 2023-07-26 12:37:18 Recieved password from 3rd party application: (20 characters) STATUS Connectivity 14916 0 2023-07-26 12:37:18 Received autoconnect from 3rd party application STATUS Connectivity 14916 0 2023-07-26 12:37:18 Adding Product. Request Auth 0 STATUS Connectivity 14916 0 2023-07-26 12:37:18 Adding Product to authentication list (1:0) STATUS Connectivity 14916 0 2023-07-26 12:37:18 Ignoring autoconnect from 3rd party application because we don't have credentials yet. STATUS Information 14916 0 2023-07-26 12:37:18 Initialization complete. STATUS Connectivity 20540 0 2023-07-26 12:37:18 Connect Process: Status 3. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connected to server 14. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 0 (12.36.218.210:60000) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 1 (0.0.0.0:4000) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 2 (0.0.0.0:4000) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 3 (12.36.218.210:60009) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 4 (0.0.0.0:4000) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 5 (12.36.218.211:60005) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 6 (12.36.218.212:60012) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 7 (12.36.218.148:60003) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 8 (0.0.0.0:60015) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 9 (12.36.218.210:60050) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 10 (12.36.218.210:60014) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 11 (12.36.218.202:60045) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 12 (12.36.218.211:60013) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 13 (12.36.218.211:60018) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Initiating disconnection from server 14. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connection to server 14 closed. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connection to server (14) closed gracefully. STATUS Connectivity 20540 0 2023-07-26 12:37:19 1 products left to authenticate. Ready STATUS Connectivity 20540 0 2023-07-26 12:37:19 Resetting socket in authentication thread. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Waiting for user or server list. 1 : 0 STATUS Connectivity 14916 0 2023-07-26 12:37:19 Initiating a login of type (0). STATUS Connectivity 20540 0 2023-07-26 12:37:19 Clearing previous authenticationResult. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connecting To Login Server - 12.36.218.210:60000 STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connecting to server (12.36.218.210) on port 60000. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connect Process: Status 1. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connect Process: Status 2. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connect Process: Status 3. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connected to server 0. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Clearing previous authenticationResult. STATUS Connectivity 20540 0 2023-07-26 12:37:19 No products pending authentication. Checking for unauthenticated products. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Authentication Successful STATUS Connectivity 20540 0 2023-07-26 12:37:19 Setting symbol limit to 500 STATUS Connectivity 20540 0 2023-07-26 12:37:19 Processed Server 15 (12.36.218.206:60002) STATUS Connectivity 20540 0 2023-07-26 12:37:19 Authentication Successful STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connection to server 0 closed. STATUS Connectivity 20540 0 2023-07-26 12:37:19 Connection to server (0) closed gracefully. STATUS Connectivity 20540 0 2023-07-26 12:37:19 0 products left to authenticate. Ready STATUS Connectivity 14916 0 2023-07-26 12:37:19 Authentication Complete - Debug value = 1 STATUS Connectivity 20540 0 2023-07-26 12:37:19 Resetting socket in authentication thread. STATUS Connectivity 14916 0 2023-07-26 12:37:19 Connecting to quote server (12.36.218.206, 60002). STATUS Connectivity 14916 0 2023-07-26 12:37:19 Login Initiated without IQ32.dll STATUS Connectivity 14916 0 2023-07-26 12:37:19 Cleared QuoteServer Send Buffer STATUS Connectivity 14916 0 2023-07-26 12:37:19 Successful connection to quote server made. STATUS Connectivity 21100 0 2023-07-26 12:37:19 Processed Server 16 (12.36.218.206:60013) STATUS Connectivity 21100 0 2023-07-26 12:37:19 Processed Server 15 (12.36.218.206:60004) STATUS Connectivity 21100 0 2023-07-26 12:37:19 Processed Server 0 (12.36.218.212:60000) STATUS Connectivity 21100 0 2023-07-26 12:37:19 Processed Server 3 (12.36.218.212:60009) STATUS Connectivity 21100 0 2023-07-26 12:37:19 Processed Server 5 (12.36.218.212:60005) STATUS Connectivity 21100 0 2023-07-26 12:37:19 Processed Server 7 (12.36.218.150:60003) STATUS Connectivity 21100 0 2023-07-26 12:37:19 Processed Server 9 (12.36.218.210:60050) STATUS Connectivity 21100 0 2023-07-26 12:37:19 Processed Server 11 (12.36.218.202:60045) STATUS Connectivity 21100 0 2023-07-26 12:37:19 Processed Server 13 (12.36.218.210:60018) STATUS Information 14916 0 2023-07-26 12:37:20 NO CLIENTS CONNECTED SINCE STARTUP. SHUTTING DOWN IN 30 SEC. STATUS Information 14916 0 2023-07-26 12:37:21 SHUTTING DOWN IN 29 SEC. STATUS Information 14916 0 2023-07-26 12:37:22 SHUTTING DOWN IN 28 SEC. STATUS Information 14916 0 2023-07-26 12:37:23 SHUTTING DOWN IN 27 SEC. STATUS Information 14916 0 2023-07-26 12:37:24 SHUTTING DOWN IN 26 SEC. STATUS Information 14916 0 2023-07-26 12:37:25 SHUTTING DOWN IN 25 SEC. STATUS Information 14916 0 2023-07-26 12:37:26 SHUTTING DOWN IN 24 SEC. STATUS Information 14916 0 2023-07-26 12:37:27 SHUTTING DOWN IN 23 SEC. STATUS Information 14916 0 2023-07-26 12:37:28 SHUTTING DOWN IN 22 SEC. STATUS Information 14916 0 2023-07-26 12:37:29 SHUTTING DOWN IN 21 SEC. STATUS Information 14916 0 2023-07-26 12:37:30 SHUTTING DOWN IN 20 SEC. STATUS Information 14916 0 2023-07-26 12:37:31 SHUTTING DOWN IN 19 SEC. STATUS Information 14916 0 2023-07-26 12:37:32 SHUTTING DOWN IN 18 SEC. STATUS Information 14916 0 2023-07-26 12:37:33 SHUTTING DOWN IN 17 SEC. STATUS Information 14916 0 2023-07-26 12:37:34 SHUTTING DOWN IN 16 SEC. STATUS Information 14916 0 2023-07-26 12:37:35 SHUTTING DOWN IN 15 SEC. STATUS Information 14916 0 2023-07-26 12:37:36 SHUTTING DOWN IN 14 SEC. STATUS Information 14916 0 2023-07-26 12:37:37 SHUTTING DOWN IN 13 SEC. STATUS Information 14916 0 2023-07-26 12:37:38 SHUTTING DOWN IN 12 SEC. STATUS Information 14916 0 2023-07-26 12:37:39 SHUTTING DOWN IN 11 SEC. STATUS Information 14916 0 2023-07-26 12:37:40 SHUTTING DOWN IN 10 SEC. STATUS Information 14916 0 2023-07-26 12:37:41 SHUTTING DOWN IN 9 SEC. STATUS Information 14916 0 2023-07-26 12:37:42 SHUTTING DOWN IN 8 SEC. STATUS Information 14916 0 2023-07-26 12:37:43 SHUTTING DOWN IN 7 SEC. STATUS Information 14916 0 2023-07-26 12:37:44 SHUTTING DOWN IN 6 SEC. STATUS Information 14916 0 2023-07-26 12:37:45 SHUTTING DOWN IN 5 SEC. STATUS Information 14916 0 2023-07-26 12:37:46 SHUTTING DOWN IN 4 SEC. STATUS Information 14916 0 2023-07-26 12:37:47 SHUTTING DOWN IN 3 SEC. STATUS Information 14916 0 2023-07-26 12:37:48 SHUTTING DOWN IN 2 SEC. STATUS Information 14916 0 2023-07-26 12:37:49 SHUTTING DOWN IN 1 SEC. STATUS Information 14916 0 2023-07-26 12:37:50 SHUTTING DOWN. STATUS Information 14916 0 2023-07-26 12:37:50 Ping Results: Round Trip Time: 33ms STATUS Connectivity 21100 0 2023-07-26 12:37:50 Authorizations Thread shutting down (156384765) - Context was terminated STATUS Information 14916 0 2023-07-26 12:37:50 IQConnect Exit
|
|