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?

 

1. Open MetaStock
2. Select the Tools Menu
3. Select Indicator Builder
4. Click on New
5. Under Name Type Ted Spread
6. Under Formula type:

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

 

1. 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);

---

Have a wonderful day~!

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

---

"The question of whether a computer can think is no more interesting than the question of whether a submarine can swim."
Edsgar W. Dijkstra

 

MS: 6.52 EOD, 7.x EOD, 8.0 PRO, 9.2 PRO w/QC, 10 PRO w/QC & MDK
For custom MetaStock programming : http://www.wabbit.com.au
My SkyPE status :
My SkyPE account : wabbit.com.au

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.

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

The symbol is: us&LT3MS

---

Have a wonderful day~!