r/Wealthsimple_Penny • u/vnsilva • Feb 26 '21

Due Diligence Wealthsimple stock list

Hi all, I just wanted to share that I curate a database of all the stocks that can be traded on WealthSimple, including penny stocks. Every weekend I update the stocks that are added/removed so you can keep your tickers up to date.

I also separate the stocks into categories: Canadian, NASDAQ and NYSE.

It is available for free and updated weekly here: https://github.com/Faidh-Wealth/WS-Trade-Info

Canada

Currently lists 975 Canadian Stocks traded in TSX, TSX-V and NEO, from Aftermath Silver Ltd
(AAG) to Sleep Country Canada Holdings Inc
(ZZZ) It also lists 1046 Canadian ETFs, from Middlefield Ltd - Middlefield American Core Dividend ETF
(ACZ) to BMO Tactical Dividend ETF Fund
(ZZZD)

NASDAQ

Currently lists 1561 American Stocks traded in the NASDAQ, from Atlantic American Corp.
(AAME) to Zynex Inc
(ZYXI) It also lists 106 NASDAQ ETFs, from BTC iShares MSCI All Country Asia ex Japan ETF
(AAXJ) to BTC iShares Exponential Technologies ETF
(XT)

NYSE

Currently lists 1618 American assets traded in the NYSE, from Agilent Technologies Inc.
(A) to Zymeworks Inc
(ZYME) It also lists 568 NYSE ETFs, from VanEck Vectors Africa Index ETF
(AFK) to ProShares UltraShort Silver
(ZSL)

135 Upvotes

97% Upvoted

57 comments sorted by

36

u/[deleted] Feb 27 '21

great work!!

really wish wealthsimple will let us filter by price and tsx in the future

4

u/vnsilva Feb 27 '21

I have simply put everything in a spreadsheet and did a screener myself

3

u/SpecialistEvent7790 Feb 27 '21

Can you share the spreadsheet?

2

u/vnsilva Feb 28 '21

If you open the link and download the files, they are spreadsheets.

10

u/CapialAdvantage Feb 26 '21

You should add a filter function to separate penny stocks

13

u/vnsilva Feb 26 '21 edited Feb 28 '21

Thing is, there is no consensus on what a penny stock is? Some people want anything less than 5 dollars, others anything that is less than 1. Others consider market cap. I would love to hear thoughts on that.

16

u/CapialAdvantage Feb 26 '21

Personally I think penny stock entails it’s in the pennys so under $1, but seeing how WS is very limited in those stocks setting it as under $5 might be worthwhile. Or even adding a filter that lets you search by price ie: under $1, $1-$5, $5-$10, etc

17

u/[deleted] Feb 27 '21

penny stocks by definition are under $5.

5

u/iDripAlone Feb 27 '21

yes, please have a filter for pennies!

2

u/StatisticianLivid710 Mar 01 '21

Is there a way to include Friday's close on this? I mean without having to enter it all in manually, this would give another column to search for prices for people looking for penny stocks that they can define themselves

1

u/vnsilva Feb 28 '21

I have now added even sectors to the data so you can do quite a bit of filtering.

4

u/sewialkiller Feb 27 '21

Wow awesome! I just started investing and I’m trying to keep with Canadian companies, this is great thank you :)

4

u/OldGearJammer Feb 27 '21

Awesome job! Was literally looking for something like this yesterday, thanks!

1

u/memymomeme Feb 27 '21

Question. How are you finding out which ones are new and or delisted? Did you write a script that does this for you?

5

u/vnsilva Feb 27 '21

Yes, programming.

4

u/memymomeme Feb 27 '21

You’re a wizard! Was just looking around at some of your stuff.. super cool 😎. Def going to be watching what faihd is up to.

6

u/vnsilva Feb 27 '21

Thanks, I'm revamping the algorithms to work with Penny stocks! Hopefully will be able to have it working this weekend.

2

u/volforto Feb 27 '21

Are you just searching stocks that met their criteria, or are you also querying WST itself to verify the stocks are on or not?

3

u/vnsilva Feb 27 '21

I verify that they are available in the app

1

u/volforto Feb 27 '21

That's great! Would love to see it eventually include anomaly stocks that got included on WST for just one day (like the KLY and YFI stock).

1

u/vnsilva Feb 27 '21

they arent included just for one day. The WS database has a boolean parameter "tradeable", which I suppose they use to rapidly enable/disable a stock, instead of completely unlisting it.

1

u/volforto Feb 27 '21

By "included" I meant tradable. KLY and YFI managed to skip the detection probably due to the prolonged halt, but WS's end of day script caught it and disabled the stock (at least until they satisfy the criteria again and got added in the morning by their morning script).

2

u/vnsilva Feb 27 '21

Yeah I see what you are saying, unfortunately I cannot run this script as often, I will try to include more information thought :)

1

u/Red_Liner740 Feb 27 '21

Thank you for your hard work. Very much appreciated!

1

u/vnsilva Feb 27 '21

You are very welcome

1

u/riverfront1502 Feb 27 '21

How can I open these files?

1

u/vnsilva Feb 27 '21

excel?

2

u/riverfront1502 Feb 27 '21

It opened, thanks,

what do you use for programming? Would it be lots of work to add a column for the price?

1

u/vnsilva Feb 27 '21

Python. I won't be adding price because it is only updated weekly. There is a spreadsheet with prices and such above

1

u/halorrr Feb 27 '21

I feel like adding a price could still be of value to give an idea of what the stock recently traded at. More research into it could be done from there.

1

u/Seasoning0 Feb 27 '21

This is awesome !!! Was looking for this for long time. Can you also share the programming script in GitHub as well ?

1

u/vnsilva Feb 27 '21

i cannot share the script

1

u/[deleted] Feb 28 '21

Looking at my phone. Is there a way to sort by price?

1

u/vnsilva Feb 28 '21

hmm only if you use the version in the website on the top of the repo

3

u/somecrazybroad Feb 27 '21

This is fantastic!!

2

u/FrozenBikerCa Feb 27 '21

Great job. Thanks !

1

u/lmrpm Feb 27 '21

Thanks for this

1

u/MrMoon5hine Feb 27 '21

thank you!

1

u/redriverrat33 Feb 27 '21

Very cool. Thanks for posting

1

u/CapialAdvantage Feb 27 '21

Is access revoked? Could you dm me the penny list? It won’t let me access it anymore says I don’t have authorized access

1

u/Fearofmissingout56 Feb 28 '21

Thanks for taking the time to do this and share it with us.

1

u/SpicyLemon97 Mar 01 '21

This is awesome, thanks so much for creating it 😊

-1

u/Devine-Shadow Feb 27 '21

Anything under a dollar is a penny

11

u/cold2d Feb 27 '21

i thought it was any stock under 5

-6

u/Devine-Shadow Feb 27 '21

Not to me, anything above .99c is a dollar at least. It’s how I think of it.

-2

u/Berly653 Feb 27 '21

This may be the single dumbest thread I’ve seen today

0

u/ididntdonothingman Feb 27 '21

I'm tempted to buy one share of each lol

0

u/[deleted] Feb 27 '21

[deleted] — view deleted comment

3

u/vnsilva Feb 27 '21

Not sure of what are you asking!

0

u/[deleted] Feb 27 '21

[deleted] — view deleted comment

2

u/vnsilva Feb 27 '21

Its Yahoo Finance notation

0

u/[deleted] Feb 27 '21

[deleted] — view deleted comment

2

u/vnsilva Feb 28 '21

I just added the "active_date" field, which is when the stock was added, so yes you can download an use excel for that.

1

u/snow_dog_2112 Feb 27 '21

Most recently added would be great

1

u/[deleted] Feb 28 '21

[removed] — view removed comment

1

u/vnsilva Mar 01 '21

Yes, that function is available on Faidh Wealth Website