I was looking through the Freetrade roadmap and saw that Freetrade web might be more than >6 Months away. I find searching through the 611 items in the FT universe difficult (maybe because I am a newbie investor) looking through the excel document and then having to search / research each company can be time consuming. Thinking what can I do to speed up the process. Rather than complain ! I started to build a searchable website for just Freetrade Universe (intended for just myself). I’ve structured it to easily accommodate the next batch of 250 stocks, i’ll be able to copy and paste into the database (max 60 seconds to do). Going forward, I’ll look to update each item with a relevant link to each company. Drop some columns (not sure we need full name). Maybe look at pulling the live stock prices (that amount of API calls isn’t free).
I think other users ‘may’ benefit from it so I’m sharing it on the community forum. Feel free to provide any feedback. I’ve added some responsive features into the design so should work well on mobile. Remember this is version 1.0 it won’t be shiny and somethings won’t work (but i’ll fix them…)
Yes, definitely. Would be another filter / parameter. We can check that with the drop of the next 250 stocks. Add an extra flag to highlight new. Great idea with the dividend column (I would like to know too). Rather than all of us checking individually, if there is one place that says yes / no. I think i’ll add last updated time / date too.
Definitely interested to see how this project develops. Would be nice to perhaps click on the stock and deep dive further. Depends what APIs are available for that…and limits for a freebie.
@Marky Is the project on GitHub? Happy to throw in a bit of work (depending on language) to help make this better
Commercial aspect to it is the automated collection and data extraction from regulatory documents mandated by the MiFID and PRIIPs regimes. That mostly equates to KIDs/KIIDs/EMTs. That’s very much aimed at asset managers and/or brokers looking to ensure they serve the latest and correct documents pre-sale to their client (you’d be surprised how many (ie. LOTS) are not) or want to QA their distributors to isolate where their data is not getting through to the end clients. Nothing really to see on the website as it’s super secret
That’s the dull side.
The fun side is the free/hacked-together/locked-down project the finkiAPI that simply helps newbie investors get access to key data surrounding their share holdings. Dividend data (ex, yields etc.), charges, prices etc…etc… and dump them straight into G Sheets or Excel. No parsing (unless you want to), no need to understand what the hell JSON is (unless you want to).
@DrJonBear not on GitHub, I can throw it up there, let me check with freetrade first. I don’t want it to conflict with any of their plans Built with a mix of HTML / CSS / JavaScript / Imported libraries. What’s your preferred stack?
Testing out a toggle on row option (You’ll be able to see that on 3i Stock - highlighted blue). Gives you a link to the costs & charges of having that stock. Also price link via google finance (not sure if that is any good…). Will try a few options and figure which is a good option and apply to all 611.
Added in live prices for 3M / AbbVie (refreshing every 5 seconds). Probably not scalable doing it this way, but seeing something dynamic is
—————
I’ll look at getting some data and plotting some live graphs (stock prices). Maybe look at creating dynamic individual pages for each stock. Do some research on how to extract dividend dates. I’d also like to see a link to a company annual report.
I don’t see that being a problem if you can pull the data needed. Share price x outstanding shares then sort. I’ll have a look and see if that data is available.
I’m lovin the https://datatables.net/ jQuery sortable table… I have now stolen (ahem, sorry, I mean ‘borrowed’) that for my dividend data tables from now on…
Someone has been looking under the hood Great to hear! I love learning from others. You should also check out alternatives like FooTable - A jQuery Responsive Table Lighter and more customisable.
I also started looking at creating my own API (Amazon API Gateway | API Management | Amazon Web Services). Also searching what is currently available on the market (Alpha Vantage / Yahoo Finance / Alpaca Trading). Some interesting choices / business models.
@finki looks awesome I would add google analytics / alternative in if you haven’t already. Make adjustments based on the type of devices / browsers used to access your website.
Although the additions look like 253. 250 US and three others Shin Nippon plc / Charter Comms / MelodyVR
If there was 611 before and 253 new today = 864. However, the updated list is only showing 857. Meaning (I think), 7 from the 611 have been dropped. I will fish through that tomorrow to confirm.
@jbowen if you type in * it will show you all the new stock. Although i’ve set it to default to show up first
! I started to build a searchable website for just Freetrade Universe (intended for just myself). I’ve structured it to easily accommodate the next batch of 250 stocks, i’ll be able to copy and paste into the database (max 60 seconds to do). Going forward, I’ll look to update each item with a relevant link to each company. Drop some columns (not sure we need full name). Maybe look at pulling the live stock prices (that amount of API calls isn’t free).
is the free/hacked-together/locked-down project the 
Great to hear! I love learning from others. You should also check out alternatives like 
I would add google analytics / alternative in if you haven’t already. Make adjustments based on the type of devices / browsers used to access your website.
