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

  • Posts

    • Massa is making waves in the DeFi space with its innovative approach to blockchain technology. Their unique blockclique architecture boasts a staggering 10,000 transactions per second, putting them at the forefront of scalability and efficiency. Furthermore, their Autonomous Smart Contracts (ASCs) empower fully on-chain dApps, reducing reliance on centralized control. This focus on decentralization is further emphasized by the project's impressive network growth. Their testnet has ballooned to over 8,000 nodes, and their social media presence has exploded with tripling Twitter followers and a Discord community exceeding 105,000. Recent collaborations with Starknet, Umbrella, and Hyperlane solidify their commitment to fostering a robust DeFi ecosystem. Listing on Bitget and the backing of over 100 well-respected investors paints a promising picture for Massa's future as a major DeFi player.
    • Nettensor is making waves in the tech industry by offering a unique combination of AI infrastructure and advanced blockchain solutions. They leverage cutting-edge hardware to deliver fast, efficient, and powerful products designed to streamline the convergence of these two revolutionary technologies. It boasts a comprehensive suite of services, including NetCloud, NetGPU, NetApp Chain, and NetVPN. Notably, their native token, NAO, recently debuted on the Bitget exchange and has been experiencing a positive initial price trend. With its focus on simplifying and elevating the synergy between AI and blockchain, Nettensor is positioned to be a key player in the future of decentralized applications. But will NAO's bullish start translate into long-term success? Only time will tell.
    • The spike in volume you're noticing around 7 pm could be related to the closing of trading sessions or the release of important news. Regarding your experience with a sudden wick spike, this is a common challenge in trading. Setting appropriate stop-loss levels and being prepared for volatility can help manage such risks. As for news sources, financial news outlets like Bloomberg, Reuters, and CNBC can provide valuable insights into market trends. Also, I came across this interesting platform, smarterbusiness.co.uk, which helps businesses find optimal utility providers. While it may not be directly related to trading, having access to the right info and resources can be crucial in any business endeavor.
  • Create New...