Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

MixedHerbs

Comparing Relative Strength

Recommended Posts

Hello. :)

 

I have a pension policy that allows me to allocate money across 361 funds. I want to build a list of those funds in Excel together with price history. I would calculate Relative Strength by comparing each fund to an index made up of all funds in the list.

 

My intention is to sort the list so that the funds with the highest strength appear at the top.

 

My question is, how do you compare Relative Strength over time? Comparing it on a single day is easy, but choosing a fund that has the higher strength over the last three months (say) is trickier.

 

Peter.

Share this post


Link to post
Share on other sites

Hi,

This is exactly what I have been doing. I copy the latest fund prices into Excel weekly, but then I actually import those into Amibroker for checking. This let's me also see the charts and gives a much better feel than just looking at the figures. I don't have a system as such, but I rank then by 3 weeks moving average change, and also look at the 1 week change, and maximum recent losing and gaining weeks. Works pretty well for keeping me in the upper performing funds so far.

Share this post


Link to post
Share on other sites
Hello. :)

 

I have a pension policy that allows me to allocate money across 361 funds. I want to build a list of those funds in Excel together with price history. I would calculate Relative Strength by comparing each fund to an index made up of all funds in the list.

 

My intention is to sort the list so that the funds with the highest strength appear at the top.

 

My question is, how do you compare Relative Strength over time? Comparing it on a single day is easy, but choosing a fund that has the higher strength over the last three months (say) is trickier.

 

Peter.

 

Peter,

 

I do not know anything about you. But, if your pension policy is to be used for retirement, then you are choosing the absolute worst strategy you can choose to allocate the money you need to have later in life when you no longer wish to work. You are infinitely better off allocating your pension assets in a manner consistent with your risk profile and making money over time instead of trying to time the market using a lagging indicator. Keep your retirement money sacred. The average mutual fund buyer losses money in a mutual fund because they buy at the wrong time and sell at the wrong time. Your strategy puts you firmly into this group.

 

If you stand to inherit a boat load of cash or have a job or live in a country where you will receive a guaranteed payment at retirement that will be more than enough, then i suppose you could risk losing the bulk of your pension account and it won't make a difference to you.

 

MM

Share this post


Link to post
Share on other sites

Mixed,

 

i use this techinque in excel. do you have a data feed? my data feed is eSignal.

it supports DDE. this allows reading data (stock prices) directly in excel.

if you have a data feed and are calculating the relative strength, you only need to add a row that display's (current) today prices.

 

here is the eSignal support:

 

=winros|LAST!nov

 

gets today's value for NOV

(other prices available, eg change, high, low,)

peter.

Share this post


Link to post
Share on other sites
MightyMouse, - sector relative strength is a well researched anomaly that's documented to lead towards abnormal. Check google scholar and elsewhere for confirmation.

 

Friend, you may gamble your retirement money any way you wish. Go for it and I will hope a long with you that I am wrong in this instance.

Share this post


Link to post
Share on other sites
Hello. :)

 

I have a pension policy that allows me to allocate money across 361 funds. I want to build a list of those funds in Excel together with price history. I would calculate Relative Strength by comparing each fund to an index made up of all funds in the list.

 

My intention is to sort the list so that the funds with the highest strength appear at the top.

 

My question is, how do you compare Relative Strength over time? Comparing it on a single day is easy, but choosing a fund that has the higher strength over the last three months (say) is trickier.

 

Peter.

 

Ending Fund Price - Beginning Fund Price

__________________________________

 

Ending Index Price - Beginning Index Price

 

 

 

The higher the ratio the higher the RS.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • Date: 22nd November 2024.   BTC flirts with $100K, Stocks higher, Eurozone PMI signals recession risk.   Asia & European Sessions:   Geopolitical risks are back in the spotlight on fears of escalation in the Ukraine-Russia after Russia reportedly used a new ICBM to retaliate against Ukraine’s use of US and UK made missiles to attack inside Russia. The markets continue to assess the election results as President-elect Trump fills in his cabinet choices, with the key Treasury Secretary spot still open. The Fed’s rate path continues to be debated with a -25 bp December cut seen as 50-50. Earnings season is coming to an end after mixed reports, though AI remains a major driver. Profit taking and rebalancing into year-end are adding to gyrations too. Wall Street rallied, led by the Dow’s 1.06% broadbased pop. The S&P500 advanced 0.53% and the NASDAQ inched up 0.03%. Asian stocks rose after  Nvidia’s rally. Nikkei added 1% to 38,415.32 after the Tokyo inflation data slowed to 2.3% in October from 2.5% in the prior month, reaching its lowest level since January. The rally was also supported by chip-related stocks tracked Nvidia. Overnight-indexed swaps indicate that it’s certain the Reserve Bank of New Zealand will cut its policy rate by 50 basis points on Nov. 27, with a 22% chance of a 75 basis points reduction. European stocks futures climbed even though German Q3 GDP growth revised down to 0.1% q/q from the 0.2% q/q reported initially. Cryptocurrency market has gained approximately $1 trillion since Trump’s victory in the Nov. 5 election. Recent announcement for the SEC boosted cryptos. Chair Gary Gensler will step down on January 20, the day Trump is set to be inaugurated. Gensler has pushed for more protections for crypto investors. MicroStrategy Inc.’s plans to accelerate purchases of the token, and the debut of options on US Bitcoin ETFs also support this rally. Trump’s transition team has begun discussions on the possibility of creating a new White House position focused on digital asset policy.     Financial Markets Performance: The US Dollar recovered overnight and closed at 107.00. Bitcoin currently at 99,300,  flirting with a run toward the 100,000 level. The EURUSD drifts below 1.05, the GBPUSD dips to June’s bottom at 1.2570, while USDJPY rebounded to 154.94. The AUDNZD spiked to 2-year highs amid speculation the RBNZ will cut the official cash rate by more than 50 bps next week. Oil surged 2.12% to $70.46. Gold spiked to 2,697 after escalation alerts between Russia and Ukraine. Heightened geopolitical tensions drove investors toward safe-haven assets. Gold has surged by 30% this year. Haven demand balanced out the pressure from a strong USD following mixed US labor data. Silver rose 0.9% to 31.38, while palladium increased by 0.9% to 1,040.85 per ounce. Platinum remained unchanged. Always trade with strict risk management. Your capital is the single most important aspect of your trading business.   Please note that times displayed based on local time zone and are from time of writing this report.   Click HERE to access the full HFM Economic calendar.   Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding of how markets work. Click HERE to register for FREE!   Click HERE to READ more Market news. Andria Pichidi HFMarkets Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
    • A few trending stocks at support BAM MNKD RBBN at https://stockconsultant.com/?MNKD
    • BMBL Bumble stock watch, pull back to 7.94 support area with high trade quality at https://stockconsultant.com/?BMBL
    • LUMN Lumen Technologies stock watch, pull back to 7.43 support area with bullish indicators at https://stockconsultant.com/?LUMN
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.