I have been using the excel version HYPTUS for a number of years to monitor my portfolio of Equities and ITs. I also have a number of funds and have often wondered if it is possible to adapt HYPTUS or any of the other tools in the financial software section to scrape prices of UTs & OEICs etc. I have looked at the macro code in a number of the spreadsheets but cannot work out which financial website to point at and how to assemble the necessary URL.
I am comfy with writing excel macros but the codes in the HYPTUS are much more complex than I am used to.
Has anyone done this on HYPTUS or can they suggest another spreadsheet where this is possible 'out of the box'
An example of an investment I would like to get prices for is:
/fund/Threadneedle_UK_Equity_Income_ZNA_Acc_NAV Threadneedle Inv Uk Eqty Inc Z Net Acc B888FR3
Thanks for any tips
Got a credit card? use our Credit Card & Finance Calculators
Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site
Price Scrape of Funds
-
- Lemon Pip
- Posts: 58
- Joined: November 8th, 2016, 8:36 am
- Has thanked: 278 times
- Been thanked: 22 times
-
- Lemon Quarter
- Posts: 4131
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3284 times
- Been thanked: 2869 times
Re: Price Scrape of Funds
If you just want prices, and your funds are listed in Yahoo, just add them in like any other share.
It looks like this is the one you mentioned
https://uk.finance.yahoo.com/quote/GB00 ... in-srch-v1
So add GB00B888FR33 to the Digital Look Data Sheet and away you go
The simple Yahoo Price Scrape at http://lemonfoolfinancialsoftware.weebl ... crape.html may also help
--kiloran
It looks like this is the one you mentioned
https://uk.finance.yahoo.com/quote/GB00 ... in-srch-v1
So add GB00B888FR33 to the Digital Look Data Sheet and away you go
The simple Yahoo Price Scrape at http://lemonfoolfinancialsoftware.weebl ... crape.html may also help
--kiloran
-
- Lemon Pip
- Posts: 58
- Joined: November 8th, 2016, 8:36 am
- Has thanked: 278 times
- Been thanked: 22 times
Re: Price Scrape of Funds
Thanks Kiloran,
Have identified ISIN codes and tapped them into the simple price scrape spreadsheet. Now getting 7 out of 10, so a big improvement over what I had been doing.
Of the other three, 2 are not in the yahoo library and the 3rd has a".IR" rather than ".L" suffix that the macro is expecting.
Have identified ISIN codes and tapped them into the simple price scrape spreadsheet. Now getting 7 out of 10, so a big improvement over what I had been doing.
Of the other three, 2 are not in the yahoo library and the 3rd has a".IR" rather than ".L" suffix that the macro is expecting.
-
- Lemon Pip
- Posts: 58
- Joined: November 8th, 2016, 8:36 am
- Has thanked: 278 times
- Been thanked: 22 times
Re: Price Scrape of Funds
Thanks for the pointers KIloran. I guess the problem with funds is that they often have multiple versions [different classes of units] and maybe Yahoo does not have all of them. With a little experimenting I have rather crudely adapted the price scrape macro to scrape funds with both .L and .IR suffixes
-
- Lemon Slice
- Posts: 529
- Joined: November 5th, 2016, 1:25 am
- Has thanked: 214 times
- Been thanked: 212 times
Re: Price Scrape of Funds
HillManMill wrote:Thanks for the pointers KIloran. I guess the problem with funds is that they often have multiple versions [different classes of units] and maybe Yahoo does not have all of them. With a little experimenting I have rather crudely adapted the price scrape macro to scrape funds with both .L and .IR suffixes
This may be of help.
I use google sheets with
=IMPORTHTML(B4, "table", 1) (with B4 being the URL)
to pull up data that not's easily accessible, or direct from a provider's own pages.
Takes a bit of setting up, but it works for me. Possibly a similar function in excel?
torata
-
- 2 Lemon pips
- Posts: 178
- Joined: July 16th, 2020, 1:34 pm
- Has thanked: 186 times
- Been thanked: 51 times
Re: Price Scrape of Funds
I appreciate this is an old topic, but has anyone succeeded in getting ITs / Shares and OEICs to be scraped from the same table in HYPTUSS?
I've added the name, SEDOL and sector into the "Company Data Sheet" sheet. It appears in my list and list of shares I can add, but getting prices and yields fails.
I've added the name, SEDOL and sector into the "Company Data Sheet" sheet. It appears in my list and list of shares I can add, but getting prices and yields fails.
-
- Lemon Half
- Posts: 9107
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10033 times
Re: Price Scrape of Funds
stacker512 wrote:
I appreciate this is an old topic, but has anyone succeeded in getting ITs / Shares and OEICs to be scraped from the same table in HYPTUSS?
I've added the name, SEDOL and sector into the "Company Data Sheet" sheet. It appears in my list and list of shares I can add, but getting prices and yields fails.
Page 19 (Step 2) of the HYPTUSS User Guide, included in all ZIP download files (https://tinyurl.com/y9atwtb7), should provide instructions for adding new shares or IT's to the 'Company Data Sheet', to enable normal income-portfolio functionality via the main sheet.
Fund price-scrapes were a bolt-on feature that we added much later, and we've not incorporated that process into the main portfolio functionality, as the main HYPTUSS processes are primarily aimed to provide a suite of portfolio tools for income-investment purposes, but you can gain OEIC and fund prices separately, via the 'FT Funds' sheet in the HYPTUSS tool, and the following linked post should give a good overview of that simple process -
https://www.lemonfool.co.uk/viewtopic.php?t=25025#p336483
Hope that helps, but if you've got any specific issues with the fund side of things if you give it a go, then please just let me know.
Cheers,
Itsallaguess
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 6 guests