Jump to content
  • 0

Easy Modelling of Historic data Watch List performance


rembo

Question

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
  • image.png

  • Posts

    • The mischievous amphibian who became a meme legend? Well, meet Apu, his wide-eyed, optimistic cousin, taking the internet by storm – and now, perhaps, the world of finance. Apu, also known as Peepo or Helper, is a kinder, gentler Pepe variant. Tired of the often-scammy memecoin scene, Apu (or rather, Apu's devoted community) decided to create something different: $APU, a "fairly launched, fully transparent coin" built by and for "all frens." Here's where things get interesting. $APU's narrative is one of resilience and community power. Fueled by the cryptocurrency community's enthusiasm, $APU was initially launched with the best of intentions. However, the dream took a nasty turn when the original developer pulled the rug – a disheartening scenario for many crypto enthusiasts. Today, $APU stands as a testament to community empowerment. It's a beacon of hope for projects facing similar challenges, a reminder that collaboration and resilience can transform setbacks into stepping stones. It's also worth noting that another community-driven memecoin, $MASSA, recently found a home on the Bitget exchange. Could this be a sign of things to come for $APU? What are your thoughts? Does Apu's story inspire you? Can a memecoin truly become a legitimate force in the volatile world of cryptocurrency? Share your thoughts and predictions in the comments below!
    • The price shown on the graph is the price after the IG's fee taken. That is the reason for discrepancy.
    • I am a relatively newbie. I have seen similar and also have seen automated closed position has a loss though the close price I have set was above the price I have bought. After about 6 months with a lot of mysterious losses though my closing price was above the opening price, I discovered this was because of the amount charged for opening/closing a position. This is right below BUY and SELL boxes on the right in very small font. This amount vary from  0.9 to 33 or more depending on the level of trading at the time you open or close. It also happens (god knows why it is set to be so, except that the trader is not watching) when there is a lot of buying and selling going on, like an important news has suddenly been out and the result was not the market expected. As a result, I delete all my automated BUY/SELL values before I stop trading for the day. Remember, the the software is set up to favor the IG, not the retail seller. That is why 70% or more end up in loss.  
×
×
  • Create New...
us