Hello to all ,

I am contacting the forum because I need to know if does anyone knows how to put real time quotes in Excel spreadsheets in an historic array of data with the last row updating second by second where I can choose the number of periods in the array like 1000 or 5000 periods and in several time frames like 1-5-15-30-60-day-week timeframes.
I am a Qlink subscriber from www.Quote.com and the product is great but they just provide american markets and I need this features to european and Forex markets.
Or , does anyone knows a similiar product provided by other company?

In this page http://www.quote.com/home/qcharts/qlink.asp?option=qlink you can see what I need , this array of data shown is the array Qlink provides and the last row of the array is updating second by second.

This is all I need .I hope QuoteCenter has this feature.

Thank you all and best regards

Andrea

Hi Andrea-

Welcome to the forum!

Yes, the QC program can provide a DDE link to Excel. MetaStock can too, if receiving QC data. It would be real time if you subscribed to the appropriate exchanges. The DDE capability is pretty expansive and can include technical and/or fundamental data. The method you choose to implement the DDE link will determine the Excel format you see. You can set it up cell by cell or as a predefined array. One of the limitations to the cell by cell method is quickly reaching your authorized symbol count as defined by your QC subscription.

This is not an Excel support forum, but I have uploaded a few DDE examples that you can explore. You will need to change the path names for the links. I suggest that you check out the QC forum for more information; the QC FAQ; the QC built-in help; and, the MS d/l forum are also places to look for additional information. You can expand these basic capabilities via VBA such as found in the auto-recording example available in the QC d/l section.

http://forum.equis.com/drm_main.php?mode=drm_cat_view&cat=11

HTH,

G

p.s. I was confused by your use of URGENT in the thread title, so I abbreviated it. Please refer to the forum rules for more information.

---

Traders' Consortium

Hello Stockman.

Thank you for your answer in the quotecenter forum.

I tried to call the technical support to see if they know of any application to put historical array of data in excel with the last row updating in real time but they said it´s not possible. It´s possible only in a snapshot basis

I feel really frustrated cause I thought it would be possible.

I think it may not be difficult to build something in VB but I dont know anything about it , I have zero skills on programing.

The application I use from quote.com called Qlink is very small, it has 401kb so I think it is very simple to do something like that. Do you know anyone that does this? Or a company that has a software to do this ?
Thank you

AndreaSilva:

Hello Stockman.

Thank you for your answer in the quotecenter forum.

I tried to call the technical support to see if they know of any application to put historical array of data in excel with the last row updating in real time but they said it´s not possible. It´s possible only in a snapshot basis

I feel really frustrated cause I thought it would be possible.

I think it may not be difficult to build something in VB but I dont know anything about it , I have zero skills on programing.

The application I use from quote.com called Qlink is very small, it has 401kb so I think it is very simple to do something like that. Do you know anyone that does this? Or a company that has a software to do this ?
Thank you

Take a look at g_stockman's post again and take a look at the example he mentions.
I think what you're looking for just might be possible.

---

Equis International, Inc.
A Thomson Reuters Company
90 S. 400 W Suite 620
SLC, UT 84101

hmm... there was a misunderstanding somewhere. This is absolutely possible. I have a daily solution in use. The examples that I have posted here in the QC forum and the d/l sections are primitive, but they should give you an idea of what's possible. You will need programming skills- or have a good friend who does- in order to get a system working for this purpose.

With DDE, the data will be available in the receiving application immediately- or as often as your source data is updated. That is, in our case, the data array from QC or MS will be available in Excel immediately. There is no need for additional code to enable this. Just look in the User's Manual and in the built-in help for more information.

My previous VBA reference was pertaining to how to store this real time information. I suppose you can have any number of unique requirements, but one super simple method is to copy the current data to a new workbook every so often. e.g., every hour, minute, second, day, etc. In that vein, you should check out the auto-recorder macro that is posted here: http://forum.equis.com/drm_main.php?mode=drm_file_view&cat=11&file=26. It could be developed into so much more, but that was not my intent. Instead, it was to demonstrate a beginning foundation for DDE capabilities. In my own trading, I have this data going to an Access database. So, that is another possibility you could consider developing.

For what it's worth, when I'm told that something is impossible to achieve, that makes me want it even more. I have heard that a couple of times here on the forum too, and believe me, most things can be done. Remember, QC is brand new to the individual consumer, so we are all learning it's uses and limitations. I am not a programmer, but if I can figure it out, I know you can. I am just a average user with an interest in programming. In fact, I'm the guy sitting in the back of the class. ;-)

---

Traders' Consortium

Thank you for your replies,

I think I have found a way . I have to pay a programmer to do me the job :D .

The main issue here is if the quote center has backfill of historic data in order to do the same thing that Qlink does.

If anyone here can do that , say the price , and I´ll pay.

I leave an attachment of a excel spreadsheet below

thank you one more time

Andrea, your worksheet is essentially the same as the auto-recording sample. Did you try that and run into a problem? I could probably do this for you in a brief time, but maybe what I'm describing is not going to suit you. Let me know. If you'd like me to dial in the auto-recorder with a specific security, I'll be happy to do that for you. Other minor tweaks, I can take care of too. I just don't have the time to partake in a brand new custom project. There are a bunch of Excel programming sites that could assist you with custom programming. If your needs are lofty, you might search that avenue too. The source of the data is not that important to the solution. It's more of an Excel thing.

---

Traders' Consortium

Did I miss something blazingly obvious here? Hope not. Anyway this is all available in the XL folder you will find in QuoteCenter's install folder. That's right, it's all here. Free. There are several interesting Excel Add-ins but the one you want (I think, go ahead and try both) is BExtra and/or BTools.

One of these will install a menu called "Reuters Tools" in Execl. From there you will have access to both a history generator (historic quotes) and real-time. You will want to add the date field since it will not add the date by default.

The tools take some getting used to. Here is what the DDE string it produces from the wizard looks like. It is far better to use the Wizard even though it takes time since the DDE strings can get "gnarly"

>>

=BDDE|HIST!'\\\\<DEFAULT>\\MSFT.INT=DAY.SPAN=1.FARD=01/03/06.NEARD=01/31/06.PRDS=21.EXCEL.QE=FLD_LAST,FLD_DATE'

<<

This creates an array of the last price for the day (period I chose though you can get tick data back a few days) and labels it. By the way it does no good to just cut and past this in, the Wizard does some things behind the scenes.

Anyway, hope this helps.

So, sorry. The example I gave showed only the history data array. Of course this doesn't upate in real time. In the tool you get this from the "Ticker" menu item instead of the "History" menuItem. The wizard looks identical so it's easy to get mixed up. I am showing just the date but I think you can get all the granularity of time you want. There is a "Datafileds" PDF to show you what fields are available or you can search from the wizard itself and browse through.

All you need to do is fill in the amount of history you want to see through the History Wizard as described,

Then, choose your fields and then choose "copy link".

Now, switch to "Ticker" wizard by going back to the Reuters Tools menu and choose the same fields. Voila, these will update in real time and here is what that string looks like:

=BDDE|TKR!'\\\\<DEFAULT>\\MSFT/FLD_BF_TE_LAST,EDT'

Hey Bryan-

Welcome to the forum!

The question deals with storing data every xx period of time- keeping the history and adding the newest real time value to the history list. BTools will enable the DDE interface and the BTools XLS samples show cell formula syntax and how to construct a formula macro, but a real storage solution in not provided. Sooner or later you will run out of worksheet rows... or memory... or both. Real time QC updates in Excel prove to be memory intense. The QC application will also be taxing your system. Then, if you want to track any of these as an alert response by pulling up a chart in MS at the same time... well, you get it. A partial solution is to minimize your Excel footprint. The included XLS examples don't come close to addressing that.

Another problem with creating multiple cell entries is that you are going to kill your securities count very quickly. Each of these macro fields will subtract 1 security from your quota, plus and additional one on top of the total. This is in addition to the overhead of your symbol counts running in the QC application. As you can see, it would be impossible to track an S&P 500 index or maybe even the NASDAQ 100 before you run out of the standard allocation. After that, the real time updates in DDE stop or become so erratic that their usefulness stops.

It's more complicated than the canned solution. What are you doing to get around these issues? Maybe we can trade some solutions.

IMO, the answer is not a QC DDE answer at all. Cutting and pasting at the end of the day is easier and can be automated to some degree. Unless you are looking for a worksheet that tracks fundamentals in real time- is that even a factor in active trading??- then the most viable solution that I've found so far lies in MS, not in QC.

That's my 0.02.

G :)

---

Traders' Consortium

Ah, ok. Yes, the storage solution is indeed not there. And that is never my problem because as you say I'd be running MS on history. Actually what I would do then is punt the BTools interface and code it myself in another tool that makes DDE requests. Thing is, unless you guys have another approach, the BTools is much more efficient at collectiing than any other DDE query seems to be. Actually it's faster in my experience to pull things in through the tool than to use QC itself.

I'd actually go have a look at willowsolutions.com since they wrote the original tool for reuters. The syntax in the tips areas is different but there might be a solution there that could be adapted. Seems like what we have is the old BridgeStation version not the new Reuters version. Or something, anyway it's different. But there may be some good coding examples there.


Sorry for missing only the entire point of the post. There is so much going on in BTools I made the assumption the original poster was unaware of them.

thanks for the tip of willowsolutions, they have lots of stuff . <i just dont understand why they dont reply to the email i´ve sent :eek:

I found a way to do what i want with the DDE excel sheet of interactive brokers.

thanks to all

regards