View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 2
Default TS1 Reuters Links in Excel

I was interested in the parameters passed to Reuters. We
have routines which query Reuters which are derived from
the Reuters history wizard. That works, but it would be
nice to know what these parameters mean - at east before
it become totally obsolete.

Thanks.


-----Original Message-----
Reuters TS1 is a little arcane, the best way to think of

it is as a funtion
which returns an array.
My memory of ts1 a hazy as I have mainly been working

with Bridge lately.
Do you want a full breakdown of the parameters or an

understanding of how
the call actually works?


"Chris" wrote in message
...
Hello again Excel Community -

Sorry for the cross-post, but I have called Reuters and
checked the net extensively, and I can not seem to find
any solid documentation of the Reuters TS1 link

protocol.

The TS1 links is an array formula that looks like
{=REUTER|TS1!'/RI=.DJI /PE=D /EN=EARLIEST /EV=260 /FI=-
600,19,12,13,6,32'}. Most of this is pretty clear what

it
is, but I am a bit surprised that I can not seem to find
anywhere the complete specification.

These links can be used by Excel to query Reuters for
historical data so they are important.

Any help will be appreciated.

Chris
.




.