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
  • Posts

    • Sainsburys full year earnings and Unilever’s first quarter trading update both say the same thing, UK consumers are in for higher prices. The war in Ukraine, supply chain issues and the effects of ongoing Covid all to blame.      
    • US Dollar (DXY) Daily Price and Analysis US Q1 GDP may stall the greenback’s advance. A 20-year high nears for the US dollar. The multi-month US dollar rally continues with the greenback printing a fresh high today ahead of the first look at US Q1 GDP at 12.30 GMT. The US dollar basket (DXY) has been boosted by renewed weakness in the Euro and the Japanese Yen, as investors move from lower-yielding to higher-yielding currencies, while safe-haven flows continue to benefit the greenback. The US growth release later in the session is expected to show a sharp slowdown from the robust Q4 figure of 6.9%. The markets are currently pricing in growth of just 1% for the first three months of this year, with the slowdown mainly due to a reduction in inventory accrual over the quarter. This release is unlikely to move the greenback, unless there is a large miss or beat, as the Fed believe that 2022 US growth will be robust enough to let them tighten monetary policy sharply without damaging the economy. The latest US Core PCE data – the Fed’s preferred inflation reading – is released on Friday and this may have more effect on the US dollar than today’s GDP data. For all market moving economic data and events, see the DailyFX Calendar. The ongoing US dollar rally has been aided by weakness across a range of G7 currencies including the Euro, the Japanese Yen, and the British Pound. The Euro continues to battle with lowly growth expectations, exacerbated by energy concerns, the British Pound is mired by weak economic data, while the Japanese Yen is in freefall as the BoJ continues with its ultra-loose monetary policy.   The US dollar continues to press higher and looks set to break above 103.96, the March 2020 high. Above here the US dollar would be back at levels last seen nearly two decades ago. The March resistance will likely hold in the short-term, especially with month-end portfolio rebalancing at the end of the week, but US dollar strength is set to continue in the months ahead. USDOLLAR (DXY) WEEKLY PRICE CHART – APRIL 28, 2022 {{THE_FUNDAMENTALS_OF_BREAKOUT_TRADING}} What is your view on the US Dollar – bullish or bearish?   Apr 28, 2022 | DailyFX Nick Cawley, Strategist
    • While Tesla has nothing directly to do with Elon Musk buying Twitter - TSLA stock closed down 12% on news that Musk may have to sell stock and use other holdings to stand against the loan to finalise the purchase of the social media giant.        
  • Create New...