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.
"I've been using IQFeed 4 in a multi-threaded situation for the last week or two on 2600 symbols or so with 100 simultaneous daily charts, and I have had 100% responsiveness." - Comment from Scott
"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
"Thanks for all of your help. Great customer service deserves to be recognized which one the reasons I've been a customer of DTN for over 10 years!" - Comment from Stuart
"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post
"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum
"I used to have *******, but they are way more money for the same thing. I have had no probs with data from DTN since switching over." - Comment from Public Forum Post
"As a past ******* customer(and not a happy one), IQ Feed by DTN is a much better and cheaper product with great customer support. I have had no problems at all since switching over." - Comment from Public Forum
"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken
"If you want customer service that answers the phone, your best bet is IQFeed. I cannot stop praising them or their technical support. They are always there for you, and they are quick. I have used ****** too but the best value is IQFeed." - Comment from Public Forum
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 »Product Support »ProphetX Support »Custom daily chart - ratio of two ETFs - how to do ?
Author Topic: Custom daily chart - ratio of two ETFs - how to do ? (3 messages, Page 1 of 1)

AMA
-DTN Evangelist-
Posts: 183
Joined: Aug 1, 2007


Posted: Mar 2, 2012 04:28 PM          Msg. 1 of 3
Ok, got a new one here...checked the manual, nothing there(that I found), so ask the pros:

* charting two ETFs; ETF#1 and ETF#2. All is well...single/individual charts or both on one chart...

* I'd like to create a chart that shows the ratio between the two - say ETF#1 divided by ETF#2

* Daily chart. Nothing super fancy, just one ETF divided by the other ETF.

* I've seen & tried the stuff about showing two charts on one, but in this case I want a new chart that has a custom calculation between the two. Simple division, but you get the point here.

Any way to do this?

DTN_Jay_Froscheiser
-VP, Product Operations-
Posts: 1746
Joined: May 3, 2004

DTN IQFeed/DTN.IQ/DTN NxCore


Posted: Mar 2, 2012 05:18 PM          Msg. 2 of 3
You can use standard math formulas in the symbol fields throughout ProphetX. Thus, in a chart, you can enter the symbol as SPY/DIA for example directly into the symbol field. You can also enter this into a Quote Sheet which would then allow you link multiple formula symbols to a chart window.

In addition, you could enter a symbol such as SPY/DIA*100 (just and example) to take the value and multiple it by 100. I often do this in quote sheets or charts to calculate holdings in a position (AAPL-32.45)*100 for example would calculate your profit on 100 shares of AAPL purchased at $32.45.

I would suggest Searching ProphetX Help for "Formulas" then looking at the "Adding Symbols to Quote Windows" to see the various things you can do with symbols. Most of this works within charts as well.

Hope this helps.

Jay Froscheiser
Telvent DTN

AMA
-DTN Evangelist-
Posts: 183
Joined: Aug 1, 2007


Posted: Mar 2, 2012 05:24 PM          Msg. 3 of 3
WOW! You're good, man...and fast, too

Just what I was looking for...

Thanks
 

 

Time: Mon October 18, 2021 4:02 PM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003