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 use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"There is no doubt that IQFeed is the best data provider. I am very satisfied with your services. And IQFeed is the only one that I would recommend to my friends. Now, most of them are using your product in China." - Comment from Zhezhe
"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
"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
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"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 will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
"Excellent datafeed !!!" - Comment from Arely
"I was with ******* for 4 years at $230 a month, this is a huge savings for me, GOD BLESS YOU PEOPLE," - Comment from T.S. via Email
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 21185 total posts (0.01%) in 3,475 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: Thu April 25, 2024 6:20 AM CFBB v1.2.0 7 ms.
© AderSoftware 2002-2003