Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to jfgw,Rhyd6,eyeball08,Wondergirly,bofh, for Donating to support the site

HYPTUSS - new sectors for Investment Trusts

Discussions regarding financial software
kiloran
Lemon Quarter
Posts: 4112
Joined: November 4th, 2016, 9:24 am
Has thanked: 3252 times
Been thanked: 2855 times

HYPTUSS - new sectors for Investment Trusts

#335245

Postby kiloran » August 23rd, 2020, 12:41 pm

Until now, the stock version of HYPTUSS has used the sector "Equity Investment Instruments" for Investment Trusts.

Itsallaguess had the excellent idea of refining this, using sectors from the AIC website https://www.theaic.co.uk/aic/find-compa ... -companies. An updated version of the Company Data Sheet is available at: http://lemonfoolfinancialsoftware.weebl ... op-up.html
"Equity Investment Instruments" is now only used for ETFs.

You can use this new company_data_sheet.txt to replace the Company Data Sheet in your HYPTUSS. If your HYPTUSS has some personally-defined sectors, just paste the new data below your own..... HYPTUSS will use the first match it finds as it scans down the Company Data Sheet

--kiloran
=========================================
The new sectors are:

IT - Asia Pacific
IT - Asia Pacific Income
IT - Asia Pacific Smaller Companies
IT - Biotechnology & Healthcare
IT - Commodities & Natural Resources
IT - Country Specialist: Asia Pacific - ex Japan
IT - Country Specialist: Europe - ex UK
IT - Debt - Loans & Bonds
IT - Environmental
IT - Europe
IT - European Emerging Markets
IT - European Smaller Companies
IT - Flexible Investment
IT - Global
IT - Global Emerging Markets
IT - Global Equity Income
IT - Global Smaller Companies
IT - Growth Capital
IT - Hedge Funds
IT - Infrastructure
IT - Japan
IT - Japanese Smaller Companies
IT - Latin America
IT - North America
IT - Private Equity
IT - Property - Europe
IT - Property - UK Commercial
IT - Property Securities
IT - Renewable Energy Infrastructure
IT - Technology & Media
IT - UK All Companies
IT - UK Equity & Bond Income
IT - UK Equity Income
IT - UK Smaller Companies

richfool
Lemon Quarter
Posts: 3529
Joined: November 19th, 2016, 2:02 pm
Has thanked: 1208 times
Been thanked: 1294 times

Re: HYPTUSS - new sectors for Investment Trusts

#335253

Postby richfool » August 23rd, 2020, 1:18 pm

Ah, thank you for that. It has helped me find the missing IT's: HDIV, IPE, CMHY, NCYF, etc, which had seemingly disappeared from Citywire's High Yield UK and High Yield Global sectors. They are now under: " Debt - Loans & Bonds".

Itsallaguess
Lemon Half
Posts: 9129
Joined: November 4th, 2016, 1:16 pm
Has thanked: 4140 times
Been thanked: 10032 times

Re: HYPTUSS - new sectors for Investment Trusts

#335295

Postby Itsallaguess » August 23rd, 2020, 5:04 pm

Thanks kiloran, and just to show off this new improvement a little, here's a sample HYP that I've just created using the latest Excel version of the HYPTUSS tool and this latest Company Data Sheet information, and which hopefully shows the improved granularity of the 'Sector Weighting' process, where the owner of a portfolio which contains a relatively large proportion of income-related Investment Trusts can now see a much more useful output from it in relation to the particular sectors those Investment Trusts are aligned with -

https://i.imgur.com/Pn2qge2.png

Cheers,

Itsallaguess


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 27 guests