Freetrade Universe - Web

[fnery (Fabio)]

Yep I’ve been using this approach for a while on a custom google sheet and so far works good. The other updates look cool too!

[Marky]

I’ve updated with the latest stock drop

100 brand new stocks & ETFS - Banks, Planes, Trains & Automobiles

Hi Sam Any plans to start adding more of the FTSE / AIM companies soon? US ones are great, but there is a lot of UK companies people are waiting on

Removed a few duplicates and stock that has been dropped:

Arthur Gallagher - Duplicate
Welltower - Dropped
Marathon Oil - Duplicate
Charter Comms - Duplicate

We should now be in sync (1078) & i’m looking forward to the next stock drop this week This topic / thread started at 611 stocks, we are now at 1078 in under a month. Incredible growth… Looking forward to researching more of the companies available to invest in on freetrade.

@Jim1 You’re right, I’ve been looking at live data costs (same supplier Freetrade uses) and pulling the dividend dates next to each stock. I’ll need to start paying for some additional services to build on the current features. I’ve setup / added a donate a coffee button on the page as you suggested. Link is here too: https://ko-fi.com/marky Will help with hosting, scaling and better features going forward. As always feel free to drop feedback

[Marky]

Version 1.6 is here

Video:

• Added Top 10 most popular buys (scrolling ticker)
• Removed iFrame, cost document will open in new tab
• Style / Design / Code updates under the hood
• Added new stocks & ETFs drop:

Brand new: ETFs, Korean telcos, Japanese messaging app and Chinese airlines

Read all about the new additions here: Let’s dive straight into this week’s new ETFs: ETF Ticker FTSE Developed Asia Pacific ex Japan UCITS ETF VAPX FTSE Developed World UCITS ETF VEVE FTSE North America UCITS ETF VNRT Global Value Factor UCITS ETF VVAL iShares Healthcare Innovation UCITS ETF USD (Acc) (GBP) DRDR iShares Nasdaq US Biotechnology UCITS ETF USD (Acc) (GBP) BTEK USD Emerging Markets Government Bond UCITS ETF VEMT And the full list of stocks: Stock Tic…

[Marky]

Version 2.0 is here

• All (1379) US / UK stocks & ETFs are now connected to the graph (Click item row to display stock / ETFs info on graph).

• Back end changed to load all new stock drops autonomously no future need to do it manually

• Removed Top 10 and replaced with Freetrade News (Pulls latest Freetrade Twitter tweets - inc Top 10 most popular buys) no need for manual updates

• Lots of other changes / tweaks - See video for a glimpse…

Clicking on the Full Name column will load the Google Finance link to that item. Clicking on the ISIN column will bring up the cost document. Anywhere else will load that item into the graph. Anything you select should highlight too.

Click refresh on the page if you don’t see Version 2.0 at the bottom

Enjoy & have a great week

[Jim1]

Genuinely love what you are doing with this @Marky I wish Ft would release an api so we could have an integrated/automatically populated portfolio tracker…that plus your app here would be a massive step up IMO

[CashCow (aka CrashCow)]

This is a great tool and thank you for all the work you’ve put into it! I see people have mentioned using Google Sheets to add a price column - has anyone managed to do this yet?

[Marky]

@Jim1 Appreciate the feedback I think with the level of competition, the API would be a lower priority. Completely understand and back going for user adoption OKRs throughout Europe and increasing the stock / ETFs selection / Alpha development.

Although… that doesn’t mean we can’t create our own portfolio tracker (without the API). I’ve been looking into it. I built this Cloud based solution, that a user can select the stock / ETFs and watch / monitor. Pulls the data from alpha vantage. There are some free endpoints from others I could use, which would make it more usable.

Take a look:

@CashCow you should be able to add a price column .

Check this out: GOOGLEFINANCE - Google Docs Editors Help

If you do =GoogleFinance("NYSE:DIS")

Replace the MIC in the data XLON = LSE, XNAS = NASDAQ, XNYS = NYSE

=GoogleFinance("COLUMN WITH MIC: COLUMN WITH TICKER SYMBOL")

Let me know if you have trouble, i’ll create one and share if you need.

[Jim1]

Thanks for the suggestion. I do have a personal tracker that I created a while ago and keep updated manually with my buys, and with prices via Google Finance. Its ok but has plenty of room for improvement! I’ve looked at some options online too such as the portfolio trackers in simply wall street and wallmine and holofolio, all have some good points, but all of the ones I have reviewed also have issues, such as certain stocks wont work, or missing functionality unfortunately.

[Marky]

You’re right, manually can be tedious if your portfolio changes often. Do you remember which stocks didn’t work? I am looking at how to show the stock price and % change next to each stock / ETF. The stock price data on the app is coming from different sources: IEX / LSE and others. Makes me think that one supplier won’t have it all.

[Jim1]

Yep that’s the issue entirely - single supplier for all stocks. Off memory a couple of ETFs VUSA & SEMB, I cant remember which stocks were an issue apart from 4imprint for some reason.

[finki]

No single source. Partly the reason for FinKi. Dividends especially - ETF dividend data is massively lacking on a lot of commercial APIs. US data and LSE equity data is pretty easy to come by, but for some reason UK ETFs is a bit of a hole.

[CashCow (aka CrashCow)]

@Marky

@CashCow you should be able to add a price column .

Check this out: https://support.google.com/docs/answer/3093281?hl=en-GB

If you do =GoogleFinance("NYSE:DIS")

Replace the MIC in the data XLON = LSE, XNAS = NASDAQ, XNYS = NYSE

=GoogleFinance("COLUMN WITH MIC: COLUMN WITH TICKER SYMBOL")

Let me know if you have trouble, i’ll create one and share if you need.

Well I’m never going to be on a government watch list for hacking. I copied the Freetrade sheet to my Drive but then couldn’t add any columns to it… so I manually copied and pasted everything to a new sheet and added the pricing column. It took me a few goes but eventually I had ‘a number’ in every cell for my price column.

Unfortunately though, some just weren’t displaying correctly. I know some would be in £ and some would be in $USD (and that I’d need another column to convert them), but some share prices were just plain wrong. For example ITM was showing as 0.03 when in reality it’s over £3

I’ll give it another go today!

[Marky]

“Well I’m never going to be on a government watch list for hacking”

@CashCow, I hacked you a quick one (ITM showing at 315):

Link: CashCow Version

[Marky]

Where does your data sources come from? Do you combine LSE / IEX / Others

[finki]

IEX + Others. Mostly Others.

[CashCow (aka CrashCow)]

Wow, thank you so much. Also… moo.

[Marky]

No problem, although doing it via google sheets you’ll need to update as new stocks / ETFs drop. The current google sheets (Stocks to invest in - 6,000+ US, UK and European stocks to buy) is showing 1379 entries.

The web version has already been updated with 2 new entries (1381). My video with the old tally (1379) is already outdated

nCino (newly IPO) got added to Freetrade today… It’s already on the web version (I think it was on, before the notification came through ), one click bring up the data and start researching in seconds (nCino hasn’t been updated on the google sheets version yet).

Definitely need to do some more research into nCino ‘The worldwide leader in cloud banking’ I’ll need to double check that…

nCino (NCNO) - Share Chat

I think the lowest entry point today was $71ish? I like this company and the 50x oversubscribed IPO suggests the institutions do to. I have bought today and plan to hold

[CashCow (aka CrashCow)]

I’m not complaining (!) I just wanted to let you know in case it affects any other work you’re doing… but… when I sort them by price, they seem to be mixed - some in pence, some in pounds. For example Fallen Angels is really £5.19 and ITM is £3.13.

It’s no big deal for me but I wanted to let you know in case it has an impact on any other project

Thank you again and moo

[Marky]

I’ve googled a few solutions just now, weirdly it’s other freetrade members experiencing the same problem (google finance pennies to gbp - Google Docs Editors Community), but I think, I’ve got something better. Let me work on it during lunch.