I have modified his work/advice to show how to get a list of all VCTs
1. Go to https://www.theaic.co.uk/aic/find-compa ... istics?set
2. Click on Previous Working Day Button
3 Clcik on AIC Sector Selector Button
4. Click on Deselect all sectors button
5. Click on AIC VCT Sectors button
6. Click on Select all AIC VCT Sectors button
You should now have all the VCTs listed on screen now
7. Click Save/Print button
8. Click Enable Print Mode' button
You can now select all the data - Copy it - including headings - and paste it into a spread sheet where you can manipulate it to your heart's content
This is the data as of today. Note that the Dividend Yield is missing which is a pity but one can undrstand why.
If you like this please go to viewtopic.php?p=191407#p191407 and give ItsAllhttps://www.lemonfool.co.uk/viewt ... 1407AGuess a rec or the thumbs up button equivalent for a neat piece of work.
Code: Select all
Company name Management group AIC sector Traded currency Total assets (m) Last close price NAV Discount / premium (%) Gearing (%) SPTR 1yr (%) SPTR 3yr (%) SPTR 5yr (%) SPTR 10yr (%) NAVTR 1yr (%) NAVTR 3yr (%) NAVTR 5yr (%) NAVTR 10yr (%) 5yr div grth (%pa) Div yld (%)
Industry average Ex 3i - Industry average Ex 3i - - - - -3.42 6.35 331.54 583.15 970.2 5034.52 3.54 43.38 66.74 303.19 3.49 3.39
Industry average ex VCTs ex 3i - Industry average ex VCTs ex 3i - - - - -3.33 6.52 340.29 597.75 995.99 5186.37 3.57 44.14 67.93 309.84 3.49 3.39
Industry average VCTs only - Industry average VCTs only - - - - -6.52 0 1.94 17.89 35.18 156.31 2.26 16.81 27.42 107.88 - -
VCT Generalist Weighted average VCT Generalist - - - - -6.75 0 4.1 16.81 37.4 139.77 4.87 16.19 29.73 97.92 - -
Albion Development VCT Albion Capital VCT Generalist GBX 60.4 76.5 80.76 -5.28 0 18.01 35.54 52.75 117.87 15.19 36.44 49.95 88.58 - -
Albion Enterprise VCT Albion Capital VCT Generalist GBX 66.49 110 115.96 -5.14 0 21.86 41.34 60.34 153.69 21.75 41.39 58.89 99.82 - -
Albion Technology & General VCT Albion Capital VCT Generalist GBX 78.35 74 75.93 -2.54 0 16.19 19.88 28.44 106.63 12.8 23.33 20.39 49.03 - -
Albion VCT Albion Capital VCT Generalist GBX 64.75 72 75.62 -4.79 0 7.85 29.34 48.31 138.89 8.52 27.83 46.93 59.25 - -
Baronsmead Second Venture Trust Gresham House Asset Management VCT Generalist GBX 179.27 74.5 77.71 -4.13 0 -4.97 7.75 21.35 128.64 -5.79 5.44 17.95 101.35 - -
Baronsmead Venture Trust Gresham House Asset Management VCT Generalist GBX 158.06 73.5 76.81 -4.3 0 -4.13 9.8 25.52 148.81 -5.14 6.93 22.33 122.04 - -
British Smaller Companies VCT YFM Private Equity VCT Generalist GBX 79.16 68.5 71.31 -3.95 0 6.27 20.1 49.58 182.78 5.19 11.4 35.66 136.61 - -
British Smaller Companies VCT 2 YFM Private Equity VCT Generalist GBX 57.86 50.55 52.95 -4.54 0 7.5 18.85 35.34 153.84 3.8 9.91 21.56 44.72 - -
Chrysalis VCT Chrysalis VCT Management VCT Generalist GBX 20.3 60 70.18 -14.51 0 12.11 45.35 144.1 172.54 1.88 21.23 48.96 87.11 - -
Crown Place VCT Albion Capital VCT Generalist GBX 51.8 32.5 31.57 2.93 0 19.91 39.44 56.56 210.1 10.97 31.9 48.36 89.97 - -
Downing FOUR VCT D shares Downing VCT Generalist GBX 2.38 15.5 30.3 -48.84 0 69.76 43.02 47.58 - 12.38 19.71 19.86 - - -
Downing FOUR VCT DP67 shares Downing VCT Generalist GBX 5.65 30 50.5 -40.59 0 93.55 32.57 72.33 29.29 3.7 28.79 46.28 17.41 - -
Downing ONE VCT Downing VCT Generalist GBX 113.7 76.5 85.13 -10.13 0 0.93 7.82 16.32 139.34 5.75 11.52 19.45 14.74 - -
Downing THREE VCT F shares Downing VCT Generalist GBX 3.85 23.5 35.6 -33.99 0 87.1 36.82 34.41 - 5.93 19.25 21.9 - - -
Downing THREE VCT H shares Downing VCT Generalist GBX 10.2 60 76.2 -21.26 0 -19.55 -12.02 - - -1.38 0.71 - - - -
Downing THREE VCT J shares Downing VCT Generalist GBX 9.74 95 91.2 4.17 0 -5 -5 - - -3.7 -7.41 - - - -
Downing TWO VCT F shares Downing VCT Generalist GBX 3.87 20 35.8 -44.13 0 -1.07 -15.79 -16.87 - 6.32 18.94 22.04 - - -
Downing TWO VCT G shares Downing VCT Generalist GBX 15.74 60 62.28 -3.65 0 0.68 0.6 -2.78 - -9.2 -2.58 -1.26 - - -
Draper Esprit VCT Elderstreet Investments VCT Generalist GBX 40.31 52.5 58.62 -10.44 0 -0.92 8.39 80.52 122.24 2.12 -1.44 30.05 90.46 - -
Foresight 4 VCT Foresight Group VCT Generalist GBX 111.72 59.5 66.22 -10.15 0 5.13 39.74 15.85 10.99 -4.37 8.06 -12.39 -1.35 - -
Foresight VCT Foresight Group VCT Generalist GBX 133.47 66.5 76.25 -12.78 0 2.04 13.17 12.88 113.23 1.57 4.36 9.78 93.86 - -
Kings Arms Yard VCT Albion Capital VCT Generalist GBX 66.49 21.5 21.9 -1.84 0 6.61 37.77 55.41 218.89 7.58 28.08 37.67 57.56 - -
Maven Income and Growth VCT Maven Capital Partners VCT Generalist GBX 23.95 43 45.3 -5.07 0 2.39 8.45 30.42 294.66 -2.17 6.5 27.44 95.93 - -
Maven Income and Growth VCT 3 Maven Capital Partners VCT Generalist GBX 42.35 57 61.5 -7.32 0 2.07 13.6 40.98 292.04 -1.03 5.31 30.68 76.07 - -
Maven Income and Growth VCT 4 Maven Capital Partners VCT Generalist GBX 54.66 65.5 71.38 -8.24 0 5.32 17.1 36.1 196.64 -1.87 4.53 18.54 70.7 - -
Maven Income and Growth VCT 5 Maven Capital Partners VCT Generalist GBX 36.39 34.6 36.94 -6.33 0 19.21 27.75 94.14 245.01 6.95 21.41 38.73 115 - -
Maven Income and Growth VCT 6 Maven Capital Partners VCT Generalist GBX 21.51 49.5 52.75 -6.15 0 -7.48 0.2 26.99 277.42 -4.5 -6.82 6.38 43.99 - -
Mobeus Income & Growth 2 VCT Mobeus Equity Partners VCT Generalist GBX 46.82 85.5 95.71 -10.66 0 4.62 19.39 58.15 154.58 0.38 17.32 34.31 152.7 - -
Mobeus Income & Growth 4 VCT Mobeus Equity Partners VCT Generalist GBX 57.36 75.5 84 -10.11 0 4.71 16.05 50.36 110.84 1.73 9.04 36.07 88.67 - -
Mobeus Income & Growth VCT Mobeus Equity Partners VCT Generalist GBX 73.7 61.5 68.94 -10.79 0 5.73 20.73 66.42 189.19 3.25 15.33 48.79 141.72 - -
Northern 2 VCT NVM Private Equity VCT Generalist GBX 82.28 59.5 63 -5.56 0 2.5 18.75 42.58 264.66 3.14 18.91 35.39 144.76 - -
Northern 3 VCT NVM Private Equity VCT Generalist GBX 80.19 86 90.51 -4.98 0 1.7 19.16 46.39 232.5 1.57 17.49 35.86 131.98 - -
Northern Venture Trust NVM Private Equity VCT Generalist GBX 89.7 65 68.31 -4.85 0 4.23 22.69 43.06 274.19 3.2 22.91 39.79 185.47 - -
Octopus Apollo VCT Octopus Investments VCT Generalist GBX 117.22 43.7 46.42 -5.87 0 -1.44 5.6 16.99 71.99 -2.19 3.96 10.99 30.16 - -
Octopus Titan VCT Octopus Investments VCT Generalist GBX 692.67 88.5 94.04 -5.9 0 0.84 10.98 37.11 89.68 1.89 11.49 35.23 112.02 - -
Pembroke VCT Oakley Investment Managers VCT Generalist GBX 23.98 100 132.49 -24.52 0 -2.83 -0.1 -1.01 - 22.27 25.72 50.76 - - -
Pembroke VCT B shares Oakley Investment Managers VCT Generalist GBX 44.46 92.5 116.09 -20.32 0 0 3.61 - - 17.87 25.95 - - - -
ProVen Growth and Income VCT Beringea VCT Generalist GBX 109.3 64.5 69.86 -7.67 0 8.26 20.4 26.98 110.14 6.02 21.76 26.62 90.8 - -
ProVen VCT Beringea VCT Generalist GBX 84.9 78.5 83.65 -6.16 0 21.29 33.27 46.68 136.5 11.77 29.78 43.04 105.98 - -
Puma VCT 10 Puma Investments VCT Generalist GBX 20.16 71 72.97 -2.7 0 0 -0.45 - - -0.72 -1.29 - - - -
Puma VCT 11 Puma Investments VCT Generalist GBX 26.91 85 88.2 -3.63 0 1.1 -0.1 - - -0.21 2.09 - - - -
The Income & Growth VCT Mobeus Equity Partners VCT Generalist GBX 78.88 67.5 75.31 -10.37 0 3.66 13.76 45.91 146.9 2.63 9.99 35.61 153.21 - -
Triple Point Income VCT C shares Triple Point Investment Management VCT Generalist GBX 15.11 112.4 112.4 - 0 - - - - 11.29 26.96 36.93 - - -
Triple Point Income VCT D shares Triple Point Investment Management VCT Generalist GBX 14.48 105.7 105.7 - 0 - - - - 8.3 16.2 - - - -
Triple Point VCT 2011 A shares Triple Point Investment Management VCT Generalist GBX 10.5 105.5 105.5 - 0 - - - - 2.24 13.01 - - - -
VCT Generalist Pre Qualifying Weighted average VCT Generalist Pre Qualifying - - - - 1.78 0 -4.37 - - - -3.44 - - - - -
Calculus VCT Calculus Capital VCT Generalist Pre Qualifying GBX 14.22 65 77.17 -15.77 0 -11.08 - - - -4.63 - - - - -
Downing FOUR VCT Generalist shares Downing VCT Generalist Pre Qualifying GBX 37.3 95 87.21 8.93 0 -5 - - - -11.64 - - - - -
Downing TWO VCT K shares Downing VCT Generalist Pre Qualifying GBX 14.79 90 94.1 -4.36 0 -10 -14.29 - - -3.68 -3.98 - - - -
Puma VCT 12 Puma Investments VCT Generalist Pre Qualifying GBX 29.26 92 94.67 -2.82 0 2.17 - - - 0.34 - - - - -
Puma VCT 13 Puma Investments VCT Generalist Pre Qualifying GBX 0 98 92.39 6.07 0 - - - - - - - - - -
Triple Point Income VCT E shares Triple Point Investment Management VCT Generalist Pre Qualifying GBX 28.44 98.25 98.25 - 0 - - - - -0.68 - - - - -
Triple Point VCT 2011 B shares Triple Point Investment Management VCT Generalist Pre Qualifying GBX 7.3 106.9 106.9 - 0 - - - - 6.9 - - - - -
VCT AIM Quoted Weighted average VCT AIM Quoted - - - - -6.85 0 -6.51 25.19 26.19 232 -7.86 23.56 21.28 155.97 - -
Amati AIM VCT Amati Global Investors VCT AIM Quoted GBX 126.28 130.5 141.11 -7.52 0 -9.71 52.11 41.9 332.32 -10.57 56.08 44.62 109.54 - -
Artemis VCT Artemis Investment Management VCT AIM Quoted GBX 25.61 44 48.27 -8.84 0 -19.74 64.15 112.52 330.59 -13.47 59.03 93.6 313.27 - -
Hargreave Hale AIM VCT Canaccord Genuity VCT AIM Quoted GBX 146.93 68.5 71.61 -4.35 0 -4.21 21.48 12.94 199.81 -5.33 17.89 7.92 110.92 - -
New Century AIM VCT MD Barnard and Co VCT AIM Quoted GBX 5.67 73 72.06 1.3 0 4.66 20.77 107.46 74.96 -15.16 9.47 20.61 75.96 - -
New Century AIM VCT 2 MD Barnard and Co VCT AIM Quoted GBX 2.69 62 52.63 17.8 0 15.01 21.32 108.46 83.43 -22.68 0.96 12.18 43.99 - -
Octopus AIM VCT Octopus Investments VCT AIM Quoted GBX 122.49 96 101 -4.95 0 -8.18 14.5 8.31 217.23 -8.6 13.99 7.21 184.94 - -
Octopus AIM VCT 2 Octopus Investments VCT AIM Quoted GBX 85.64 73 77 -5.19 0 -7.61 17.57 6.61 124.89 -8.23 15.24 7.28 106.04 - -
Unicorn AIM VCT Unicorn Asset Management VCT AIM Quoted GBX 171.38 131 147.21 -11.01 0 -1.66 16.13 33.55 246.18 -4.33 11.33 25.39 208.4 - -
VCT Specialist: Healthcare & Biotechnology Weighted average VCT Specialist: Healthcare & Biotechnology - - - - - - - - - - - - - - - -
Seneca Growth Capital VCT Seneca Investment Managers VCT Specialist: Healthcare & Biotechnology GBX 4.47 36 55.1 -34.66 0 -11.44 -15.22 -33.85 128.32 2.04 -13.77 -32.54 27.03 - -
VCT Specialist: Healthcare & Biotechnology Pre Qualifying Weighted average VCT Specialist: Healthcare & Biotechnology Pre Qualifying - - - - - - - - - - - - - - - -
Downing FOUR VCT Healthcare shares Downing VCT Specialist: Healthcare & Biotechnology Pre Qualifying GBX 14.92 100 84.34 18.57 0 0 - - - -14.46 - - - - -
Seneca Growth Capital VCT B shares Seneca Investment Managers VCT Specialist: Healthcare & Biotechnology Pre Qualifying GBX 4.68 100 100.02 -0.02 0 - - - - - - - - - -
VCT Specialist: Environmental Weighted average VCT Specialist: Environmental - - - - -2.8 0 3.29 22.37 42.06 - 2.08 14.69 26.21 - - -
Foresight Solar & Infrastructure VCT Foresight Group VCT Specialist: Environmental GBX 40.34 89 92.53 -3.82 0 -1.55 6.15 7.06 - -4.08 1.75 8.7 - - -
Gresham House Renewable Energy VCT 1 Gresham House Asset Management VCT Specialist: Environmental GBX 28 111 109.76 1.13 0 3.28 14.68 30.83 - 3.27 6.98 18.91 - - -
Gresham House Renewable Energy VCT 2 Gresham House Asset Management VCT Specialist: Environmental GBX 28.52 110 109.16 0.77 0 3.31 13.92 30.62 - -0.22 6.74 18.04 - - -
Ventus 2 VCT Temporis Capital VCT Specialist: Environmental GBX 18.66 71.5 76.5 -6.54 0 8.66 25.06 74.26 47.57 4.36 18.47 43.41 31.51 - -
Ventus 2 VCT C shares Temporis Capital VCT Specialist: Environmental GBX 14.5 121 128.5 -5.84 0 8.11 51.13 81.24 - 2.16 26.72 41.38 - - -
Ventus 2 VCT D shares Temporis Capital VCT Specialist: Environmental GBX 2.56 120 128.8 -6.83 0 0 20.4 - - 2.06 2.83 - - - -
Ventus VCT Temporis Capital VCT Specialist: Environmental GBX 17.22 101 105.6 -4.36 0 1.95 35.91 64.6 106.07 2.43 16.08 29.5 59.13 - -
Ventus VCT C shares Temporis Capital VCT Specialist: Environmental GBX 14.33 121 127 -4.72 0 8.11 51.14 81.37 - 2.02 26.39 40.76 - - -
Ventus VCT D shares Temporis Capital VCT Specialist: Environmental GBX 2.54 120 127.5 -5.88 0 0 20.4 - - 1.84 2.12 - - - -
VCT Specialist: Media, Leisure & Events Weighted average VCT Specialist: Media, Leisure & Events - - - - - - - - - - - - - - - -
Edge Performance VCT H shares Edge Investment Management VCT Specialist: Media, Leisure & Events GBX 6.41 25.5 55.29 -53.88 0 -37.04 -65.18 -67.65 - -11.18 -10.1 -31.56 - - -
Edge Performance VCT I shares Edge Investment Management VCT Specialist: Media, Leisure & Events GBX 33.23 20.5 45.45 -54.9 0 -25.18 -58.66 -63.52 - -1.96 -13.25 -21.7 - - -
VCT Specialist: Technology Weighted average VCT Specialist: Technology - - - - -18.88 0 12.32 32.41 74.52 137.66 0.56 -6.71 5.69 24.2 - -
Oxford Technology 2 VCT Oxford Technology 2 VCT Managers VCT Specialist: Technology GBX 1.62 40 30.4 31.58 0 45.45 171.11 281.25 134.62 -4.1 35.71 60.29 -22.82 - -
Oxford Technology 3 VCT Oxford Technology 3 VCT Managers VCT Specialist: Technology GBX 5.8 62.5 85.5 -26.9 0 19.05 35.67 45.06 138.6 -0.81 3.62 15.22 38.08 - -
Oxford Technology 4 VCT Oxford Technology 4 VCT Managers VCT Specialist: Technology GBX 5.36 29.5 46.5 -36.56 0 -2.99 -37.5 15.15 25.64 8.39 -25.52 -6.56 -19.95 - -
Oxford Technology VCT Oxford Technology VCT Managers VCT Specialist: Technology GBX 2.57 35 47.3 -26 0 -12.5 -5.54 -50.25 339.18 -9.73 -19.32 -24.03 109.75 - -