Jump to content
  • 0

Easy Modelling of Historic data Watch List performance



I have what I would think is an easy problem - how to get a report or chart of past performance for a particular watch list. I'm not sure if there is some easy way to do this via watchlist and charting functionality within the platform, or if I need to be looking at APIs/IG lab or whatever.

Alternatively, is there an easy way to download daily closing price data for the stocks in a watch list? Then I could just do the modelling in excel.

For example, I have two watchlists I've created -

The first one is of seven stocks from which I will be trade once a month, and I want to see how an equal value allocation across all 7 stocks would have performance over say the past 7 years (eg. plot to the total value of a model portfolio based on daily closing price if I'd invested $1,000 in each of the 7 stocks seven years ago). And going forward I'd like to use a similar equal value allocation model (rebalanced each month) as a benchmark against which I could compare my actively traded portfolio (that allocates to a subset of 2 of these 7 stocks each month).

The second example is where I have an allocation of stocks in a watch list I'd like to backtest performance of a particular allocation eg. Set the initial allocation and rebalance to that value allocation annually and see how it would have gone over the past 7 years or whatever time period.

eg. If I have the following watchlist and want to see how it would have performed with a particular asset allocation eg. 

7.5% BetaShares Commodities Basket ETF - Currency Hedged (Synthetic)

7.5% ETFS Physical Gold - GOLD

40% SPDR Portfolio Long Term Treasury ETF

15% iShares 7-10 Year Treasury Bond ETF

30% Vanguard Total Stock Market Index Fund ETF Sh AE - VTI

Link to comment

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • General Statistics

    • Total Topics
    • Total Posts
    • Total Members
    • Most Online
      10/06/21 10:53

    Newest Member
    Joined 28/09/22 02:42
  • Posts

    • Stocks: AAPL, AMZN, NVDA, TSLA, GOOGL, BRK.B, SQ, META, NFLX, ENPH, MSFT, BAC, JPM. Elliott Wave  US Stock Bear Market: AMZN, AAPL, NVDA, TSLA, GOOGL, BRK.B, SQ, META, NFLX, ENPH, MSFT, BAC, JPM, GS. Elliott Wave Technical Analysis  Stock Makret News: Options activity hints U.S. stock market has not reached bottom- Barclays Stock Market Summary: Elliott Wave Count: Wave (ii) or (iv) depending on the stock. Analysis US Stocks: Tesla TSLA, Amazon AMZN, Nvidia (NVDA), Apple AAPL, Microsoft MSFT, Berkshire Hathaway (BRK/B),Block, Inc (SQ), Meta Platforms, Netflix (NFLX), Enphase (ENPH), Alphabet GOOGL. XFL Finance Sector ETF, JPMorgan JPM & Bank of America BAC, Goldman Sachs Group Inc (GS) Stock Market Trading strategies: The market is still trending lower in the medium term. Continue on the short side of the market and short the corrective rally today. We are holding wide stops through wave fours and will exit at Wave 5 of (1) Video Chapters 00:00 NASDAQ 100 03:59 Apple (AAPL) 08:08 NVIDIA (NVDA) 10:31 Amazon (AMZN) 15:18 Meta Platforms (META) 17:22 Netflix (NFLX)  22:09 Enphase (ENPH) 24:26 Tesla (TSLA) 30:27 Alphabet (GOOGL)  32:02 Microsoft (MSFT) 34:10 Berkshire Hathaway (BRK.B) 37:27 Block Inc. (SQ)  39:05 Banks JPM, GS 51:01 End. Thanks for supporting! Analyst Peter Mathers TradingLounge™ Australian Financial Services Licence - AFSL 317817 Source: tradinglounge com    
    • The market debut of German sports car maker Porsche is looking like it will be at the top end of expectations. IGTV’s Jeremy Naylor explains how will impact on Volkswagen. vow    
    • What markets to trade on Wednesday: USD/JPY, AUD/USD, Dax & BOO With economic data key on Wednesday IGTV’s Jeremy Naylor looks at how it would affect the Yen, the Aussie and the Dax. On the corporate agenda Boohoo (BOO) delivers H1 earnings.          
  • Create New...