New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
Streaming data in excel without VB code
2 posts
• Page 1 of 1
Streaming data in excel without VB code
by jdp » Mon Jan 02, 2012 12:53 am
I receive live prices via a DDE link and I would like to capture the data into various increments like 5min open high low and close format. Is there a way to automatically capture and convert the tick data into various time increments like 5min and 10 minutes without using VB code?
- 0
- jdp
- Rookie
- Posts: 1
- Joined: Dec 31, 2011
- Reputation: 0
Re: Streaming data in excel without VB code
by Sisyphus » Mon Jan 02, 2012 3:10 am
I very much doubt that.
But don't the people who sell the live data to you provide past data in CSV format for download?
Have a great day!
But don't the people who sell the live data to you provide past data in CSV format for download?
Have a great day!
- 0
Have a great day! 
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
- Sisyphus
- Former Moderator
- Posts: 4454
- Joined: Dec 7, 2011
- Location: Shanghai
- Reputation: 203
- Excel Version: 2010
2 posts
• Page 1 of 1
Return to Macros and VBA Questions
Who is online
Users browsing this forum: Majestic-12 [Bot] and 226 guests