Hi guys! Here's my issue. Many of my realtime quotes for forex have data but several other don't. For example, EUR.CAD and EUR.USD. My database is Interactive Brokers. The problem quotes in the realtime window in Amibroker display properly in TWS. The problem symbols also have a problem of being stuck with a March 16, 2023 latest date in Exploration (probable same cause). I have TWS 10.19.2a. At the bottom of the Amibroker window, the message says "No historical data query for ticker id: 1501" which is for EUR.CAD. From the scant nine months of experience I have with Amibroker, I tried the following:
-Double-checking the symbol is correct
-Including the exchange and security type in the symbol and IDEALPRO instead of IDEAL
-Checking the database settings
-Using the latest IB plugin I could find (I have 2.11)
-Deleting a symbol from the database and readding it (EUR.CAD, now it's blank)
-Running exploration to refresh the symbols in the watchlist those tickers are in
-Backfilling long and short time periods for those symbols
-Checking the market data connections status in TWS (green across the board)
-Searching the forum with several keyword combinations for empty quotes, old data in exploration for some symbols, etc.
-Trying the CFD equivalent (instead of cash) for EUR.USD
-From a chart window, clicking on the symbol in the symbol list
-Looking at error messages in IB Controller. Anything related to data or connection is in the information only range (2000-2999)
-Other things I'm forgetting at the moment
By the way, I'm also not getting any realtime quotes on the four cryptos available in TWS either. Other thing of note is I had 5 list of 100 stocks each and they are all ok in the realtime quote window. I had to add the exchange and security to 3-4 of them but then they were ok.
@JaseBond, FWIW, it works for me using EUR.CAD-IDEALPRO-CASH (using both the latest version of TWS, and the officially unsupported 9.81.3 (but recommended by @Tomasz).
@beppe Thanks, I installed 9.81.3 and I'm getting quotes for all FX now. It solves the problem I raised. I thought it would be the same problem for cryptos and it probably also is the version but 9.81.3 doesn't show cryptos even in TWS.
Yeah I did get the message 9.81.3 was desupported as of 2023-07-18. Anyway I'll keep using this one anyways since the problem with FX quotes came from 10.19.2a for me.
@JaseBond I just tried it with TWS 1019.2a and IB Plugin 2.11 as yours. It just works, I have no problem with the above symbols. Thus, I suspect it could be due to a TWS setting (specific to forex market data ?).
Good idea, thanks! Version 981.3 was giving me an error message related to Java so I tried 10.23.2a but the problem with FX is back. I'll revert back to 981.3 and try to fix the Java problem. I combed through the settings as you suggested and clicked one new setting but no change though.
So I went back to 981.3 after installing Java 8 but I'm getting the same error message as before. 981.3 gave me that error message after the first installation. I had rebooted, then it went away so I thought I had succeeded but it was back afterwards and it's back with this reinstall of 981.3. I'm not sure what do do next. I'm on Windows 10 64-bit if that helps. Anyone?
I wouldn't install Java if not necessary. TWS installation packages come with JREs, so you don't need to install a JVM. Actually, if you don't know need Java, remove all TWS, all JVMs, reboot and reinstall TWS. Note that you can have two TWS versions installed at the same time, simply rename desktop shortcuts not to confuse them.
Thanks. I uninstalled 10.23 I had on and uninstalled java and rebooted. I installed 10.19 I had from January to try but it gave me an error message when I tried to launch it. I uninstalled it and rebooted then installed the same 10.23 I had yesterday. I could launch. I'll be able to test some FX trades overnight but the original problem of missing quotes is still there. I will try 981.3 again tomorrow and report back. I appreciate the help!
It is safest to use the stable offline version of TWS rather than the 'latest' version for live trading: the latter is more likely to have bugs.
However, it's not the point. As mentioned previously, it works with both v981.3 and v1019.2a. Look for a solution elsewhere (config, data subscriptions, server locations, antivirus…).
Thanks! I will look at those four things or anything else I can't find if it's not that. I tried 981.3 again in brand new directory (if that changes anything at all) but still same java error message. I just tried 10.23 latest offline and same problem so the issue must be elsewhere as you suggested. I'll report back on that as well.
You might be exceeding 100 real time streaming symbols (The limits add. If for example you have 80 symbols in TWS itself, you would be able only to see 20 extra symbols in AB)
Check View->Symbol Information and make sure that these problematic symbols are NOT marked as "Use only local database for this symbol"
Also as @alligator said - you need only ONE Java installed on the system - I have got Java Version 8 Update 361 and it works fine with both TWS 10.23 and 981
Thanks guys. Here are what I tried based on your suggestions. Still no luck with FX (and crypto) realtime quotes.
I emptied all my realtime window lists and TWS realtime lists. I have 10.23 standalone.
The problematic symbols were not checked to use as local database only.
Disabled my antivirus and closed Amibroker and reopened it.
In the top right corner in TWS, the word Data is highlighted in yellow. When I click on that it I see all market data connections are green. A yellow messages says some market data requires additional subscription for API users. When I click on that, it sends me to the client portal but I see the fee is waived for both cryptos and IDEAL FX for TWS. I looked everywhere I can't find anything extra to add for API users. In the connection window, the More Info link sends me to the connectivity test which shows success across for all tests.
I looked in Global Configuration settings in TWS. I had entered a the Trusted IP address 127.0.0.1 before but the "Allow connections from localhost only" box was not checked but it didn't change anything.
I opened TWS with my real account instead of demo.
I checked the database settings again and flushed the cache. I lowered the max number of symbols from 700 to 100. The other settings are the same as in the guide How to use AmiBroker with Interactive Brokers TWS.
Could anything in Windows Defender Firewall block this? I tried disabling (then enabling again) the inbound rules for TWS.
@alligator , by server locations did you mean the connectivity test?
Thanks Tomasz. Not 100% certain here since I did this over two months ago but my main strategy was to take trades based on a scan of the full S&P 500. It was also to alternatively use the same strategy on over 100 FX pairs so I had six quote boosters and a total of 700 quotes. I was already having the issue with the FX quotes but since my realtime quotes were working for stocks, I parked the issue until recently. Trying to increase the max number of symbols in the Configure Interactive Brokers plugin Window was one of the things I tried.
Back to today, I just created a new IB DB but the problem persists. I left the default settings as you just pointed out. Thanks for all your help!
Out of 40 symbols for FX with IQFeed, this is the only one I'm having an issue with. Not sure if it will help much but that's where I'm at. I tried the force backfill suggested in the troubleshooting guide and it solved another problem of not getting all my data but it didn't work for EURGBP. I kept the settings to default.
It shows properly using the SnapQuote tool from IQFeed:
