logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
happysingh  
#1 Posted : Sunday, March 1, 2009 10:05:31 PM(UTC)
happysingh

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India

Hi, I was thinking of creating a formula in which I can plot the difference between two stocks in form of indicator. What I exactly want is 1 cash stock and its future. I want to plot the difference between spot price and future price in form of indicator. Can someone help. Thanks & Regards Navneet Singhal
Richard Dale  
#2 Posted : Monday, March 2, 2009 12:30:53 AM(UTC)
Richard Dale

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 4/5/2006(UTC)
Posts: 129
Location: Norgate Data

You can use the SECURITY function to do this.

eg. Let's say you have an S&P 500 futures contract already open.

The formula you would use is:
C-SECURITY("C: rading Data\Futures\Cash\$SP",C);

Substitute the path/symbol appropriate to your data.

Note that MetaStock has no way of knowing a relationship between a futures contract and its underlying cash counterpart since the MetaStock data format treats all securities independently in most cases except for composite securities where you define the relationship between two securities.

To create yourself a composite security using the Downloader. File -> New -> Composite Security and follow the instructions from there.

You should also consider the effect of:
a) Dividends (they are already factored into the futures price but most indices are unaffected by cash dividends - i.e. they will drop when a constituent pays out a dividend)
b) Interest rate/holding costs.

Search on "futures fair value" for more information about how to compare futures with their underlying.




Cheers, Richard Norgate Data
happysingh  
#3 Posted : Monday, March 2, 2009 2:20:32 AM(UTC)
happysingh

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India

Hi Richard, Thanks for your idea and guidance. I managed to craete my formula and achive my requirement. Thanks & Regards Navneet Singhal
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.