logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
StorkBite  
#1 Posted : Sunday, September 18, 2005 4:15:27 AM(UTC)
StorkBite

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995

Was thanked: 14 time(s) in 10 post(s)
Quote:
is it possible to export real time data to excel by macro?
I might be hung up on the word 'export'... do you mean 'copy' or perhaps 'link'? If so... 1) If you want to copy current field values, just right-click and copy, then paste into Excel. This will not update. 2) If you want to copy updating (dynamic) values, create an OLE link. This method is easy, but restrictive since the data table cannot be altered after creation. You could however extract static values from the Excel table. This is also the easiest way to copy RT indicator data. Look up 'OLE links' in the User's Manual. This method is compatible with any RT data provider. See this example: http://forum.equis.com/drm_main.php?mode=drm_file_view&cat=4&file=24
garykong  
#2 Posted : Sunday, September 18, 2005 8:39:23 AM(UTC)
garykong

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 4/30/2005(UTC)
Posts: 112

Thanks hayseed, it seems that there offers a lot of flexibility when using external formulae without compromising the efficiency!! g_stockman, thanks for your advice re the ability to link the real time data.. BTY, where can I download the QuoteCenter's DDE tools? For your info, I am using a local data provider... I would like to try your method and there is a need to install the DDE tools... thanks! Gary
StorkBite  
#3 Posted : Sunday, September 18, 2005 8:51:23 AM(UTC)
StorkBite

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995

Was thanked: 14 time(s) in 10 post(s)
Hey Gary- You will need QuoteCenter to run the DDE for QC worksheet. To enable the plug-in: start Excel, click TOOLS | ADDINS, then go to C:\\Program Files\\Equis\\QuoteCenter \\XL_Files. Double-click 'btools.xla'. This will enable the macro to access information from QC. See the Quick Start Guide p.25 for more information.
garykong  
#4 Posted : Monday, September 19, 2005 3:58:19 AM(UTC)
garykong

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 4/30/2005(UTC)
Posts: 112

hi g-stockman, I couldn't find the folder C:\\Program Files\\Equis\\QuoteCenter \\XL_Files probably due to the fact that I installed the Signal (Broadcast Version). How can I do that then?.. Gary
StorkBite  
#5 Posted : Monday, September 19, 2005 4:21:36 AM(UTC)
StorkBite

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995

Was thanked: 14 time(s) in 10 post(s)
I think it depends on whether your data provider offers you a DDE feature to retrieve the data into programs other than MS. While MS can communicate with your data provider, you need for Excel to communicate with your provider. There are 3rd party programs that advertise being able to do things like this, but I don't have any experience with them. My only knowledge is with QC. Sorry. I'd check with your data provider first. Not recommending anything, but these are some of the Google hits: http://www.trading-tools.com/ddechartupdater.htm
Users browsing this topic
Guest (Hidden)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.