HomeReady-2-GoPortfolioRankingScreenerStockETFToolsCommunityHelp
ForumsEmail UserPollsFeature RequestsGroups


  Index  | Recent Threads  | Who's Online  | User List  | Search
  Search  
Quick Go »
Thread Status: Normal
Total posts in this thread: 4
[Request a Feature] [Add To My Favorites] [Watch this Thread]
Author
Previous Thread This topic has been viewed 1047 times and has 3 replies Next Thread
hyper
Advanced Member


AUSTRALIA
Joined: Jun 1, 2006
Posts: 137
Status: Offline

Feature Request: Be able to use data of other stocks or indices Reply to this Post
Reply with Quote

There should be a way to reference another stock so that we can do comparisons with other stocks or ETFs.

The next step is then to be able to reference the indices in the same manner as referencing other stocks.

A simple example of how this could be applied is to specify in the buy rules to only buy stocks if the S&P 500 index is above its moving average. More specific industry or sector indices could also be used in place of the general S&P 500 index.


In Metastock, we can reference another security using the Security() function:

Here are some examples so that you can see the syntax:

Security("$SPX",C)

gives the most recent close value of the S&P 500 index.


Mov(Security("$SPX",C),20,E)

gives the 20-day exponential moving average of the close values of the S&P 500 index.


HHV(Security("$SPX",H),20)

gives the highest value of the high of the S&P 500 index over the previous 20 days.
View the feature request here.
[Nov 5, 2007 11:03:29 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
hyper
Advanced Member


AUSTRALIA
Joined: Jun 1, 2006
Posts: 137
Status: Offline

Re: Feature Request: Be able to use data of other stocks or indices Reply to this Post
Reply with Quote

 
only buy stocks if the S&P 500 index is above its moving average.


In Metastock syntax, this would look like:

Security("$SPX",C) > Mov(Security("$SPX",C),200,S)

and you would put something like this in the buy rules in a Portfolio123 simulation/portfolio/screener.
[Nov 6, 2007 3:27:08 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
jcbrick
Member
Member's Avatar

UNITED STATES
Joined: Feb 4, 2007
Posts: 19
Status: Offline
Re: Feature Request: Be able to use data of other stocks or indices Reply to this Post
Reply with Quote

I've been considering writing about this for some time. It's a sterling request and could allow users to guage the broader impact of the market rather than merely the already provided Industry indicators. I'd also like to see the ability to use technicals on indices or market indicators such as within an Eval statement.

Jon
[Nov 6, 2007 8:47:03 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


UNITED STATES
Joined: Jan 1, 1970
Posts: 3980
Status: Offline

Feature Request Closed Reply to this Post
Reply with Quote

Please see the function GetSeries() which can be used in many TA functions
----------------------------------------
Portfolio123 Staff
[Apr 7, 2010 11:46:14 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
[Show Thread Printable Version]

Free Trial  /  Log In
Username or Email
Password
Stay logged in
Can't remember username or password?