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)




"You have an excellent product !!!!!!" - Comment from Arely
"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
"I am a hedge fund manager here. It’s funny, I have a Bloomberg terminal and a Bridge feed, but I still like having my DTN feed!" - Comment from Feras
"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
"Just a thank you for the very helpful and prompt assistance and services. You provided me with noticeably superior service in my setup compared to a couple of other options I had looked at." - Comment from John
"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
"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
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"Thank God for your Data Feed as the only Zippers I see are on my pants (LOL), and no more 200 pip spikes to mess up charts." - Comment from Spiro via Email
Home  Search  Register  Login  Blogs Recent Posts

Information on Various DTN Products:
DTN IQFeed | DTN ProphetX | DTN Ag | NxCore
Follow DTN_IQFeed 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: 179
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: 1741
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: 179
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: Wed November 22, 2017 11:40 PM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003