Re: How to pull all strikes for a given expiration?
Well, I know what you mean, but I don't really agree. There are lots of things that can be criticised about it, but there's no denying it works very well, once you've worked your way around the various oddities. ? I'm certainly not aware of any other free API that comes anywhere close to it in terms of breadth and depth of functionality. ? ? ?
toggle quoted message
Show quoted text
|
Re: CUSIP/ISIN in ActiveX API using VBA in Excel
The problem here is that the secIdList property is actually a generic object of type ComList<ComTagValue, TagValue>, and generic objects cannot be mapped into COM objects (which is why the Excel Object Browser shows it simply as being of type Object). ? So you can't access any of the members of this type. However all is not lost because the ComList<ComTagValue, TagValue>, ?type implements the IList<ComWrapper<T>> interface, which should enable the members of the list to be iterated over using For Each, something like this: ? Dim s As String Dim tv As ComTagValue For Each tv In ContractDetails.secIdList ??? s = s & tv.tag & ": " & tv.value & ";" Next ? MsgBox s, , "SecIdList" ? I haven't been able to actually try this because at the moment I can't seem to make the damn ActiveX Excel workbook work at all (I rebuilt the ActiveX control from the latest files in the Github repository, and at the moment neither the C# API nor the ActiveX API will connect successfully – they just hang). ? Richard ? ?
toggle quoted message
Show quoted text
From: [email protected] <[email protected]> On Behalf Of praditik@...
Sent: 18 February 2021 14:17
To: [email protected]
Subject: [TWS API] CUSIP/ISIN in ActiveX API using VBA in Excel? Hello,
I have been trying to get ISIN and CUSIP from ActiveX API and failed everytime. I am using reqContractDetails and trying to read secIdList.?
I have successfully received the required info while using python API (So my account has necessary subscription). However, how exactly do I read secIdList in VBA while using ActiveX client?
I tried to assign the secIdList to TwsLib.ComTagValueList and also checking if secIdList is Null. Everytime I receive error in bold statements.? Function writeContractName(contractDetails As TWSLib.IContractDetails, reqid As Long) ? ? contractName = contractDetails.longName ? ? Debug.Print IsNull(contractDetails.secIdList) ? ? If IsNull(contractDetails.secIdList) = False Then ? ? ? ? Debug.Print contractDetails.secIdList(0).tag
I tried looking everywhere and could not arrive at a satisfactory explanation for this issue!
Thanks and Regards,
Pratik
|
Re: How to pull all strikes for a given expiration?
Ain't the whole TWS API feels like that? :)
On Thu, Feb 18, 2021 at 3:29 PM Richard L King < rlking@...> wrote: The short answer is "no". ? Longer answer: ? reqSecDefOptParams is one of those API functions that appears to have been designed by a trainee programmer on a Friday afternoon after a liquid lunch (hence the stupid name), coded by another trainee the following Friday based on the beer mat that the first guy sketched it out on, tested to see whether it gives anything back at all but not whether it actually meets the specification, and then lobbed into the build for us poor API users to try and make sense of. ? I've never had anything good to say about it, and I've never heard anyone else say anything good about it. ? Having said that it can be useful, and I do use it in my platform. But the simple fact is that you can't tell whether anything it returns is actually valid unless you go and get the relevant contract details. ? ? ? How do I pull all strikes for a given expiration?? I found this API: Which gives me all combinations of expirations and strikes, but the documentation notes:? "?returns a list of expiries and a list of strike prices. In some cases it is possible there are combinations of strike and expiry that would not give a valid option contract." Instead, I'd simply like the list of strikes available for a particular expiration.? Any way to get that? ?
|
Re: "BEST queries are not supported for this contract” when requesting historical trade bars
Thanks, I was having that exact same issue.
toggle quoted message
Show quoted text
I was getting that error a lot and also came up empty searching for what it meant. I did eventually realize that it was happening when I was requesting historical data from before the IPO date of a stock. When I changed from blindly requesting the last
30 days to doing a reqHeadTimestamp and asking from max(Head, 30 days ago), most of my BEST queries not supported errors went away. I realize that doesn't solve your issue, but may give a clue, or help others.
|
Re: How to pull all strikes for a given expiration?
The short answer is "no". ? Longer answer: ? reqSecDefOptParams is one of those API functions that appears to have been designed by a trainee programmer on a Friday afternoon after a liquid lunch (hence the stupid name), coded by another trainee the following Friday based on the beer mat that the first guy sketched it out on, tested to see whether it gives anything back at all but not whether it actually meets the specification, and then lobbed into the build for us poor API users to try and make sense of. ? I've never had anything good to say about it, and I've never heard anyone else say anything good about it. ? Having said that it can be useful, and I do use it in my platform. But the simple fact is that you can't tell whether anything it returns is actually valid unless you go and get the relevant contract details. ? ?
toggle quoted message
Show quoted text
From: [email protected] <[email protected]> On Behalf Of Crow
Sent: 18 February 2021 06:08
To: [email protected]
Subject: [TWS API] How to pull all strikes for a given expiration?? How do I pull all strikes for a given expiration?? I found this API: Which gives me all combinations of expirations and strikes, but the documentation notes:? "?returns a list of expiries and a list of strike prices. In some cases it is possible there are combinations of strike and expiry that would not give a valid option contract." Instead, I'd simply like the list of strikes available for a particular expiration.? Any way to get that? ?
|
Retrieve trailing stop level
If I have an open position with an attached trailing stop order, can I somehow retrieve the price where the stop is sitting at the moment?
|
Re: Order field to identify a strategy
I have used permID and stored it locally to identify strategy mapping. It works seamlessly across sessions and days. So as everyone else already said, I think, using permID with local mapping in your program should be able to do the trick.
|
CUSIP/ISIN in ActiveX API using VBA in Excel
Hello, I have been trying to get ISIN and CUSIP from ActiveX API and failed everytime. I am using reqContractDetails and trying to read secIdList.? I have successfully received the required info while using python API (So my account has necessary subscription). However, how exactly do I read secIdList in VBA while using ActiveX client? I tried to assign the secIdList to TwsLib.ComTagValueList and also checking if secIdList is Null. Everytime I receive error in bold statements.?
Function writeContractName(contractDetails As TWSLib.IContractDetails, reqid As Long)
? ? Dim rowNum As Long
? ??
? ? contractName = contractDetails.longName
? ??
? ? Debug.Print IsNull(contractDetails.secIdList)
? ??
? ??
? ? If IsNull(contractDetails.secIdList) = False Then
? ? ? ? Debug.Print contractDetails.secIdList(0).tag
? ? End If
End Function
 I tried looking everywhere and could not arrive at a satisfactory explanation for this issue! Thanks and Regards, Pratik
|
How place orders before AND after market hours?
What is the magic combination of settings that lets you place orders through the API both before and after market hours?? I can use outsideRth(true) on an order and place it after market hours, but not before market hours.? If I set this to false then I can place it before market hours but not after market hours. In TWS -> Global Settings -> Presets -> Stocks I can set either "Allow order to be activated, triggered, or filled outside RTH" or I can set "Allow order to be routed and executed during pre-open session".? But I cannot check both.? They are apparently mutually exclusive.
So what is the combination of parameters that let you place an order anytime from 4:00 am to 8:00 pm?
Thanks!
|
Re: Order field to identify a strategy
Hi all,
I use trade references stored in the order reference field, it usually works without problem. Track the order id, order reference and your internal tracking identifier, and you should be able to piece it all together.
What I have experienced is position reports being lagged by many minutes, and execution reports arrive in an arbitrary order, but the order references do seem to be stable.
Best wishes,
M?
Tracking within your own process is not working why?
If these are LMT orders can you not track them by LMT price you set, quantity of shares, and time? Time is of course always after you submitted but at least order one was maybe executed before order four was placed even if they have same amount of share and LMT price so not a certain certain way but some certainty...?
- Bruce
Thank you very much. Will investigate.
-- +44 (0) 7528 551604?
Gulfstream Software - Winner Risk Management Awards 2010
This message is subject to :
|
How can I get yesterday's volume at some moment of time for a stock?
I want to compare the current volume of a stock with yesterday's volume at the same time.
Thank you.
|
Re: Has anyone done a stock gap scanner
You can do this with the API function reqScannerSubscription.
https://interactivebrokers.github.io/tws-api/market_scanners.html
|
Re: How to pull all strikes for a given expiration?
See some useful hints here:
How do I pull all strikes for a given expiration?? I found this API:
Which gives me all combinations of expirations and strikes, but the documentation notes:?
"?returns
a list of expiries and a list of strike prices. In some cases it is possible there are combinations of strike and expiry that would not give a valid option contract."
Instead, I'd simply like the list of strikes available for a particular expiration.?
Any way to get that?
|
How to pull all strikes for a given expiration?
How do I pull all strikes for a given expiration?? I found this API:
Which gives me all combinations of expirations and strikes, but the documentation notes:?
"?returns
a list of expiries and a list of strike prices. In some cases it is possible there are combinations of strike and expiry that would not give a valid option contract."
Instead, I'd simply like the list of strikes available for a particular expiration.?
Any way to get that?
|
Re: Order field to identify a strategy
Tracking within your own process is not working why?
If these are LMT orders can you not track them by LMT price you set, quantity of shares, and time? Time is of course always after you submitted but at least order one was maybe executed before order four was placed even if they have same amount of share and LMT price so not a certain certain way but some certainty...?
- Bruce
Thank you very much. Will investigate.
|
Re: Is there a good reason to not use LATEST API vs Stable?
Hey Bruce,?
I'm not even counting the things I have to wrap/fix with the API..? just the fact that on occasion portions will stop working.. Maybe with an undocumented error code if you're lucky..? FA accounts stopped giving me positions one day, but only in prod, not paper. Took them 3 weeks to figure that one out.??
If you want to fix the API itself.. Why not start with the fact ID in Contract isn't readonly.? Absolutely love it when my hash/equals methods aren't deterministic.??
And then there is their object names, er Interfaces which don't start with I..? etc..? ?I'll literally start twitching if I keep thinking about the OO Anti patterns they stuck themselves with..
Thankfully, I wrapped the whole thing and get an "ObservableCollection<Position> Positions"? type interface for the rest of my app to use..?
Cheers
|
Re: Historical bars and WAP
So I probably answered my own question via an experiment - getting the same 5 secs bars as real-time and as historical. They seem to match exactly except for field naming and precision.
Docs here are basically wrong -?.
"average" and "barCount" fields of historical bars are the same as "wap" and "count" fields of real-time bars except that "wap" in real-time bars has decimal precision of 3 digits after period and "average" of historical bars seem to have only 2 digits precision. I checked just for one symbol of stocks and options and it seems to hold true. Perhaps, there are occasional discrepancies - I didn't check at large scale.
On Wed, Feb 17, 2021 at 1:03 AM Alex Gorbachev < ag@...> wrote: Hi all,
Is WAP available for historical bars?
Looking at the API docs .
WAP is supposed to be present in the historical bars but I don't see it (I'm using ib_insync?Python module if that makes any difference). I can see WAP is returned in real-time bars but not in historical. I can see average. I wonder if that's basically WAP and just named differently than in the docs. I'm using IB Gateway?978.
{'average': 801.119,
?'barCount': 13,
?'close': 801.26,
?'date': datetime.datetime(2021, 2, 16, 16, 42, 30, tzinfo=datetime.timezone.utc),
?'high': 801.3,
?'low': 800.92,
?'open': 801.0,
?'volume': 20}
Also, I'm using 5 seconds bars in both cases (real-time and historical) and whatToShow='TRADES'.
Thanks in advance, Alex
|
Re: Order field to identify a strategy
Thank you very much. Will investigate.
|
Re: Order field to identify a strategy
Except for forex, markets are open for only part of a day as
opposed to continuous 24/7 trading.
The general idea is markets open at a specific time and then
close at a specific time and that is one trading session. Trading
on the next day is a different session.
Different financial instruments have different rules for when a
session starts and ends. A single session on the major futures
exchanges spans calendar days - opening in the evening one day,
going past midnight until the afternoon or the next day. Can make
you crazy since a trade can occur on Monday evening but counts as
the Tuesday trading day.
Back to the OrderRef, people have observed that the field is
returned for executions in the same session as the order was
placed but is empty if the order executed in a subsequent session.
On 2/17/2021 2:40 PM, corneliu
maftuleac wrote:
toggle quoted message
Show quoted text
Thanks Nick.
What is a session definition?
|
Re: Is there a wrapper api/sdk around that abstracts core trading functionality on top of the base ibkr api?
The IB libraries are needlessly complicated and convoluted in my
view.
My plain C library gets the job of reading messages done with a
single function twsGetMsg() which returns a union with the message
filled in. That's it. A message is physically just a bunch of
fields read from the socket - how complicated can they make such a
simple thing?
On 2/17/2021 2:49 PM, Ajay Joglekar
wrote:
toggle quoted message
Show quoted text
You described exactly my own physiological
reaction after reading tws api :-)
On Wed, Feb 17, 2021, 9:39 AM
Alex Gorbachev < ag@...> wrote:
I looked around and my head started to hurt from the
design of the TWS API. :) So I went directly to ib_insync
which seems to be somewhat well maintained.
It's actually not too dissimilar from TWS API but just
removes some annoying plumbing.
|
Despair
Dmitry Shevkoplyas