Support Board
Date/Time: Tue, 06 May 2025 22:34:04 +0000
Charting options mark price in small timeframes
View Count: 301
| [2024-11-18 00:55:53] |
| EverEdge - Posts: 17 |
|
Hello, I'm trying to chart the _mark_ price of a single option in sub-1 minute timeframes, e.g. a 5-second chart. To be clear, I'm not trying to execute off the chart. I use SC to execute futures only and a different platform to execute options. So, the chart would be for analysis only, and we are only charting single options for now, no spreads. To my knowledge, the best way (if not the only way) to get reliable real-time options data into SC is IQ feed. Please let me know if there are other options (no pun). So assume we have IQ feed connected, but the data I'm looking to chart is the then-current "mark" price, not the "last" price which is the price at which the last exchange transaction took place. I will call DTN and ask the same question at their end as to the availability and specificity of the data, but (1) is there a setting or mechanism in SC to specify that I'm looking to chart the mark price of a single option (which would be the same as the mid price of a spread), not last (nor bid, ask, etc.), and, (2) is there any constraint in SC I might not be aware of that would prevent me from _accurately_ displaying, say, a 5-second, 5-tick, or 50-volume chart of a single option, provided that chart update interval is set low, the chartbook does not have heavy items in addition to this chart, the machine has plenty of headroom in terms of cycles, memory, and I/O, and there is non-aggregated, non-filtered options data streaming in? Thanks in advance. |
| [2024-11-20 03:00:49] |
| Sierra_Chart Engineering - Posts: 19461 |
|
We need to know are you asking about futures options from the CME Group, or other options? Sierra Chart does provide futures options from the entire CME Group. For futures options we definitely recommend using the Denali Data Feed. Otherwise, use IQ Feed for other categories of options. In the case of options, you will want to use one of the Recording Modes to get what you want: Data Recording Modes You can then use this study: Bid & Ask Prices And use other arithmetic studies: Using the Basic Arithmetic Studies is there any constraint in SC I might not be aware of that would prevent me from _accurately_ displaying, say, a 5-second, 5-tick, or 50-volume chart of a single option, provided that chart update interval is set low, the chartbook does not have heavy items in addition to this chart, the machine has plenty of headroom in terms of cycles, memory, and I/O, and there is non-aggregated, non-filtered options data streaming in? No concerns with this.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-11-20 03:48:48] |
| EverEdge - Posts: 17 |
|
Thank you for the reply and sorry I wasn't more specific about the option type. I'm talking about equity and equity index options. I'm aware that Denali provides CME futures options. So I'd have to use IQ feed. As far as plotting prices other than "last", in fact, bid or ask price would do as well if mark is not available. Mark is a calculated value in option chains anyway that tends to be the average of the NBB and NBO, but it can differ between brokers. The main issue I'm trying to solve is created by the fact that I conduct analysis on the underlying but trade the single long option for leverage for this group of strategies. The underlying and its option do not have the same amount of liquidity and volume. Therefore, in a very small timeframe e.g. a 5-tick option chart mirroring, say, a 500 volume underlying chart, the underlying may print an entire consolidation pattern but the option chart may show a single horizontal line or a single bar simply because far fewer transactions have occurred in the option as compared to its underlying. So it makes no difference whether and how you "ratio" the underlying vs. option chart aggregations, and whether you use a time-based, tick/transaction-based, or volume-based chart. Still the same basic issue. Without the option chart forming a pattern similar to the underlying chart, it's tough to determine, say, stop location, and get risk off. However, while the underlying is printing those bars in a consolidation pattern, the option bid/ask/mark quotes are, in fact, ticking up and down, very closely mirroring the underlying. So plotting those quotes would solve the problem. The standard option chart won't print those movements because it's based on last price and no transactions are occurring. So, if we could plot bid, ask, or mark instead of last on the option chart, we'd be all set. I have consulted with DTN and they say their streaming price data is based on last (as expected), but they do save bid/ask history data so nothing needs to be calculated (i.e. mark) by using an API call. That's the good news as far as historical charting. The bad news is that they only save the bid/ask history on _transactions_, which is not what we want as per above. The bid/ask data _is_ available on the stream as quotes, but it's not saved unless a transaction has occurred (Please see screenshot). So, the only way to plot all bid/ask data regardless of whether transactions are occurring or not would be to scrape it via code from the IQ feed stream. This is all according to DTN tech support and market data team. Which brings me to the question: Based on your reply, it does sound like SC might have the ability to plot the bid or ask (or even the mark-equivalent with the -BAAVG suffix) in real time from the stream, and then save it in an .scid file. That would be the equivalent of the scraping code that DTN support is talking about. The studies you mentioned look very helpful as well, but I'd like to double-check the data recording mode functionality. I've read the docs. It says: "These data recording suffixes affect the method by which Trade (actual trades) and Quote (Bid and Ask) data are written/recorded to an Intraday chart data file". That sounds like either can be done. If that's accurate, then how do you differentiate between using the suffixes for trade / actual trades as in to plot the bid price only when a trade has occurred (which is not what we want as per above) vs. to plot bid or ask quotes regardless of whether trades are occurring or not (which is what we do want)? Is following the instructions under the "creating a 1-tick bid or ask chart" subheading be sufficient? Thanks again. Much appreciated. |
 image(3).png / V - Attached On 2024-11-20 03:16:36 UTC - Size: 478.32 KB - 55 views |
| [2024-11-21 22:53:55] |
| Sierra_Chart Engineering - Posts: 19461 |
|
Yes this is true: would be to scrape it via code from the IQ feed stream. This is all according to DTN tech support and market data team.
Yes this is fully supported: : Based on your reply, it does sound like SC might have the ability to plot the bid or ask (or even the mark-equivalent with the -BAAVG suffix) in real time from the stream, and then save it in an .scid file.
It sounds like you want to use this recording mode: Data Recording Modes: -BIDASK Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-12-07 18:25:35] |
| EverEdge - Posts: 17 |
|
This is now completely resolved. Most remaining issues were at the IQfeed end, and I had to combine your suggestions with some studies to get it just right, but all set now. Thank you again for your help.
|
To post a message in this thread, you need to log in with your Sierra Chart account: