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 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'm satisfied with IQFeed. It's the most reliable and fastest quote feed I have ever used. Although I'm a resident in China, it's still very fast!" - Comment from Xiaofei
"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
"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
"Thank you so much - awesome feed, awesome service!" - Comment from Greg via Email
"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"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 just wanted to tell you what a fine job you have been doing. While *******, from what I hear, has been down and out, off and on, IQ feed has held like a champ this week." - Comment from Shirin
"I started a trial a few weeks back before the market went wild. DTN.IQ didn’t miss anything and beat my other provider. I decided to stay with you because of the great service through all the volatility." - Comment from Mike
"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
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 21196 total posts (0.01%) in 3,499 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 19, 2024 9:37 PM CFBB v1.2.0 4 ms.
© AderSoftware 2002-2003