Stock universe spreadsheet

Does by any chance anyone of you have spreadsheet showing all available stocks to invest in ISA account here on T212? If not maybe someone who knows how to do such a thing could make it? Most of all I need it showing ticker isin and name nothing else at that point. I will use it to find out sth more about companies available to invest i will try to find some new opportunities and put some money in at least few of them xD

If you are just checking then this table is kinda ok in that 90% are available. Hit show all or search.

https://www.trading212.com/en/Trade-Equities?tab=isa

I can make an excel sheet if you need it. Iā€™m very temped to make a website that tracks new additions. Allows you to get alerts and submit requests to T212. Sort the table by best performing in sector etc

3 Likes

That would be a great idea.

Iā€™ve added this suggestion to 212 in the last couple of weeks to apply a filter or scanner on all shares based on different criteria.

Hate having to just rely on my own knowledge of company names or when Iā€™m searching for a particular share, the system throws out a few companies that begin with the first couple of letters and other companies pop up!!

Till now Iā€™ve been using website for that but in spreadsheet I can input some notes add links if I find sth useful etc. All stuff in same place. My library of knowledge xD It would be more comfortable for me. I donā€™t want to force anyone to make sth just thought someone maybe had it for themselves

I made a really janky python program that will do this:

The HTML needs to be updated because I didnā€™t want it to scrape the live site. I was also too lazy to export the data to anything other than a txt file. Iā€™ll upload an excel file for you later with all the stocks if you want.

If that wouldnā€™t be a problem would be great

Here you go: https://1drv.ms/x/s!AtPzhy-MhF0Ria13e2-QUnrAZfQX5Q?e=95w4Dr

If you want the extra info like ticker symbol and currency, well my program isnā€™t that good lol. Iā€™ll maybe make it better and give you an update.

1 Like

Thank you for your work

Like @phildawson said itā€™s on https://www.trading212.com/en/Trade-Equities?tab=isa

T212 donā€™t try to hide it too much. Itā€™s super easily web scrapable in secondsā€¦ hereā€¦

Once itā€™s base-lined itā€™s easy to track the new additions.

I really should automated this output so you guys can just grab it with a copy/paste as itā€™s a recurring query.

Hope it help

Enjoy

1 Like

Youā€™ve made it much easier for me, thanks

OK, I spun it out into a pretty bad piece of code, but it works!

On a ā€œcheapā€ webserver so a little slow (like 20 secondsā€¦ so be patient)

http://finki.me/Trading212/t212_isa.aspx

A live grab of all T212 ISA assets

So just head to this page, copy it out, paste into Excel or G Sheets and ā€œsplit to columnsā€ delimiting by comma!

Sorted

Enjoy

5 Likes

Hi,

Do you know if this link should still be working? I have just visited it and been shown the following error:

[ArgumentException: Argument ā€˜Limitā€™ is Nothing.]
Microsoft.VisualBasic.CompilerServices.ForLoopControl.ForLoopInitObj(Object Counter, Object Start, Object Limit, Object StepValue, Object& LoopForResult, Object& CounterResult) +1219961
ASP.trading212_t212_isa_aspx.Trading212_buildArray() +1533
ASP.trading212_t212_isa_aspx.Page_Load(Object sender, EventArgs e) +16
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
System.Web.UI.Control.OnLoad(EventArgs e) +97
System.Web.UI.Control.LoadRecursive() +61
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693

Kind Regards,

Nah, wonā€™t work. I donā€™t use that domain anymore, forgot to pay the fees and now theyā€™ve cut my service off! Sorry. I run this process from elsewhere nowā€¦ but itā€™s not public, sorry!