DTN IQFeed, DTN.IQ, DTN ProphetX Support Forums

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 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

"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy via Email

"I noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah

"I had always used ******* but for the past 2 weeks have been trying DTN IQFeed. Customer support has been extraordinary. They call just to make sure your problem hasn't recurred." - Comment from Public Forum

"Very impressed with the quality of your feed - ******* is a real donkey in comparison." - Comment from A.C. via Email

"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat

"Previously I was using *******. IQFeed is WAY more economical, and for my charting needs is just as good, if not better." - Comment from Public Forum Post

"It’s so nice to be working with real professionals!" - Comment from Len

"My broker in Davenport suggested I give you a try as he uses your service and says its the best." - Comment from Bill via RT Chat

"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.

Home

Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather

DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter

»Forums Index »Archive (2017 and earlier) »Data and Content Support »SPY VWAP using Excel via IQLink DDE

Author	Topic: SPY VWAP using Excel via IQLink DDE (7 messages, Page 1 of 1)
Ryan -Interested User- Posts: 14 Joined: May 17, 2012	Posted: Jun 11, 2013 12:37 PM Msg. 1 of 7 Hello, As of 1:22 PM ET, using formula "=IQLink\|SPY!VWAP" I receive a reading of ~162.84. This appears to be off. I download tick data and manually calculated VWAP and it comes out closer 163.62. I manually calculated using all trades made on 6/11/2013. Am I missing something? I haven't been using this function, but it appeared to be unrealistically low yesterday as well. Just glancing at some other securities, they appear to be fine. Ryan
DTN_Steve_S -DTN Guru- Posts: 2093 Joined: Nov 21, 2005	Posted: Jun 11, 2013 02:24 PM Msg. 2 of 7 Ryan, upon investigation, we are currently not accounting for Other trade price in the calculation of VWAP but the volume is still being weighted. As a result, symbols with a significant portion of their total daily volume accounted for by Other trades will be off.
etolson -Interested User- Posts: 3 Joined: Oct 21, 2014	Posted: Oct 21, 2014 02:50 PM Msg. 3 of 7 Hello, was this issue ever addressed or is this still a known issue for VWAP? thx
DTN_Tim Walter -DTN Guru- Posts: 1238 Joined: Apr 25, 2006	Posted: Oct 21, 2014 04:26 PM Msg. 4 of 7 Hello, I don't recall this being addressed, so I do not believe the behavior has changed, but in a loose test of GOOG and SPY for today, the data doesn't look off, but that could be luck. Are you seeing something that looks out of sorts for today that I can look at for an example? Tim
etolson -Interested User- Posts: 3 Joined: Oct 21, 2014	Posted: Oct 21, 2014 07:29 PM Msg. 5 of 7 Yes, I'm seeing little vwap problems here and there. I'm looking at period vwap, and that seems to really highlight the issue. For instance, I'm looking at CWEI today. At 10:30:00, the day's VWAP was 71.9932 and the day's volume was 56,309. At 11:00:00, the day's VWAP was 72.0696 and the day's volume was 62,086. So the period volume from 10:30 to 11:00 was 62,086 - 56,309 = 5,777. If you back out what this implies for the period VWAP from 10:30 to 11:00 you get 72.814 because (71.993256,309 + 72.814 5,777) / 62,086 = 72.0696. But there's now way the period VWAP from 10:30 to 11:00 was 72.814 because not a single trade done in that period was below 73.
DTN_Tim Walter -DTN Guru- Posts: 1238 Joined: Apr 25, 2006	Posted: Oct 22, 2014 02:08 PM Msg. 6 of 7 Etolson, Ok, thanks for the example, as mentioned above it does not appear that this has been addressed as of this time, but we will revisit this request and see what we can do. Tim
etolson -Interested User- Posts: 3 Joined: Oct 21, 2014	Posted: Oct 22, 2014 02:11 PM Msg. 7 of 7 Ok, thanks. I assume no users are really using your VWAP field then, as in my opinion this renders it totally useless. Even if only 1% of trades were "other trades", then your VWAP would always be 1% off.