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
|
|
|
|
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.
|
|
|
|
|
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.