Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers, Unverified Users
Joined: 9/22/2008(UTC)
Posts: 114
Location: Salt Lake City
|
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);
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
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 [:D]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
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.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers, Unverified Users
Joined: 9/22/2008(UTC)
Posts: 114
Location: Salt Lake City
|
The TED Spread (3 month Libor - TBill) is now available from QuoteCenter.
The symbol is: us<3MS
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 4/1/2005(UTC)
Posts: 2
|
Hi,
I am a consumer of the service EoD RTD
I have the following problem:
I would like to insert in the database the index TED SPREAD, does it exist?
Does this index exist in the database?
Regards
|
|
|
|
|
|
| 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.
