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)




"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
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"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.
"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
"I have been using IQFeed now for a few years in MultiCharts and I have zero complaints. Very, very rare to have any data hiccups or anything at all go wrong." - Comment from Public Forum
"I just wanted to let you know how fast and easy I found it to integrate IQFeed into our existing Java code using your JNI client. In my experience, such things almost never go so smoothly - great job!" - Comment from Nate
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"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
"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
"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
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
Viewing User Profile for: etolson
About Contact
Joined: Oct 21, 2014 02:48 PM
Last Post: Oct 22, 2014 02:11 PM
Last Visit: Oct 22, 2014 02:11 PM
Website:  
Location:
Occupation:
Interests:
AIM:
ICQ:
MSN IM:
Yahoo IM:
Post Statistics
etolson has contributed to 3 posts out of 21191 total posts (0.01%) in 3,485 days (0.00 posts per day).

20 Most recent posts:
Data and Content Support » SPY VWAP using Excel via IQLink DDE Oct 22, 2014 02:11 PM (Total replies: 6)

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.

Data and Content Support » SPY VWAP using Excel via IQLink DDE Oct 21, 2014 07:29 PM (Total replies: 6)

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.9932*56,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.

Data and Content Support » SPY VWAP using Excel via IQLink DDE Oct 21, 2014 02:50 PM (Total replies: 6)

Hello, was this issue ever addressed or is this still a known issue for VWAP?
thx


Time: Sun May 5, 2024 1:39 AM CFBB v1.2.0 13 ms.
© AderSoftware 2002-2003