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)

"The people at Nirvana have very nice things to say about your company and I can see why! Price and service is a potent combination." - Comment from Ed
"I am very pleased with the DTNIQ system for quotes and news." - Comment from Larry
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"I would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.
"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
"I was on the phone with a friend who uses CQG and right after the Fed announcement, CQG was as much as 30 seconds behind DTN.IQ. Some quotes were off by as much as 15-18 cents. Your feed never missed a beat." - Comment from Roger
"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
"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
"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken
"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
»Forums Index »Product Support »DTN.IQ Client Software Support »IQFeed with Sierra Chart - how to export?
Author Topic: IQFeed with Sierra Chart - how to export? (4 messages, Page 1 of 1)

-Interested User-
Posts: 1
Joined: Jul 1, 2013

Posted: Jul 1, 2013 02:13 PM          Msg. 1 of 4
I have Sierra Chart as my charting with IQFeed. I want to maintain a database of my own containing markets I watch with a granularity of one second (don't need all the ticks). If I export from sierra chart, it exports all data from 2006 which is OK for my first export but I need to refresh the data weekly.

I'm wondering if there's a way to get it directly from IQFeed or by using DDE with Excel or something like that? I want:
Symbol,Date,Time,Open, High, Low, Close, Vol

for each second.

I then want to be able to update this weekly by refreshing my database somehow. Would appreciate any ideas.

-DTN Technical Support-
Posts: 228
Joined: May 11, 2004

Posted: Jul 1, 2013 03:18 PM          Msg. 2 of 4

If you use the EXCEL it will only pull in the tick-by-tick data.
You will need a time and sales application that pulls data in 1 second time captures.
From the IQFeed you can request the data in 1 second time blocks.

We have some developer tools that will do the work but nothing available in the regular softwares.

There are some 3rd party softwares that may have the capability to capture the data you are looking for.

-Interested User-
Posts: 4
Joined: Jul 22, 2013

Posted: Jul 22, 2013 12:56 PM          Msg. 3 of 4
are there any open source software for capture tick data?

-DTN Guru-
Posts: 2086
Joined: Nov 21, 2005

Posted: Jul 22, 2013 04:54 PM          Msg. 4 of 4
The only open source software I am aware of that implements IQFeed is TradeLink ( but I do not know much about it's capabilities.


Time: Mon June 27, 2022 2:53 PM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003