Tips & Tricks

Re: MetaStock Indicator - Ted Spread

Heidi B — Thu, 13 Nov 2008 21:31:14 GMT

The TED Spread (3 month Libor - TBill) is now available from QuoteCenter.

The symbol is: us&LT3MS

Re: MetaStock Indicator - Ted Spread

Justin — Tue, 07 Oct 2008 13:22:08 GMT

The Online portion of the Security function can be very stressful on the Equis Data Server. The formulas above are designed to work with EoD Reuters DataLink however, which does not use the Equis Data Server.

That said, if the same output can be accomplished with less code writing that is certainly a good thing.

Re: MetaStock Indicator - Ted Spread

wabbit — Sat, 04 Oct 2008 16:49:33 GMT

I don't do much work Online: securities, but I would guess that each time the security() function is called MS will make a new query to the data server?

If this is the case, wouldn't something like the code below be faster and reduce the server loading?

Code:

LIUSD := Security("Online:LIUSD3MD=",C);
IRX := Security("Online:.IRX",C) / 10;

diff := LIUSD - IRX;
test := diff >= Ref(diff,-1);

grn := test*diff;
red := (test=0)*diff;

{plot as histogram in new window}
red;grn;

untested...

wabbit

MetaStock Indicator - Ted Spread

Heidi B — Fri, 03 Oct 2008 17:13:01 GMT

MetaStock – Indicators – Ted Spread

Do you have a symbol for the Ted Spread?

We do not have a symbol for the Ted Spread; however Reuters Datalink users who have the World Wide Indices Data Package and Futures Data Package can create a custom formula to get the Ted Spread.

Unfortunately at this time we do not have the ability to get the Ted Spread for users of QuoteCenter without having to sign up for Reuters Datalink packages.

How do I set up the Custom Indicator for the Ted Spread?

Open MetaStock
Select the Tools Menu
Select Indicator Builder
Click on New
Under Name Type Ted Spread
Under Formula type:

Security("Online:LIUSD3MD=",C)-(Security("Online:.IRX",C)/10)

Click on OK

These indicators do connect directly to the Reuters Datalink data servers to calculate the value.

You now have an Indicator for the Ted Spread.

If you would like to have 2 colors for the Ted Spread prices based on if the value went up or down from the day before use the formula below.

If(Security("Online:LIUSD3MD=",C)-(Security("Online:.IRX",C)/10)>=Ref(Security("Online:LIUSD3MD=",C)-(Security("Online:.IRX",C)/10),-1),Security("Online:LIUSD3MD=",C)-(Security("Online:.IRX",C)/10),0); If(Security("Online:LIUSD3MD=",C)-(Security("Online:.IRX",C)/10)<Ref(Security("Online:LIUSD3MD=",C)-(Security("Online:.IRX",C)/10),-1),Security("Online:LIUSD3MD=",C)-(Security("Online:.IRX",C)/10),0);