Got a credit card? use our Credit Card & Finance Calculators
Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site
Portfolio Tools
-
- Lemon Quarter
- Posts: 4835
- Joined: November 14th, 2016, 7:33 pm
- Has thanked: 182 times
- Been thanked: 1397 times
Portfolio Tools
I want an easy way of keeping track of my Vanguard ETFs and open ended funds. My Vanguard account appears to give the latest prices after market close. iWeb does not.
Trustnet appears to give the latest prices for open ended funds, but out of date prices for ETFs. The website is also very slow.
I tried to open an account with Morningstar, but it would not accept any password that I typed.
I successfully created portfolio with the FT. It appears to give up to date prices after market close. It gives valuations for each portfolio as a whole, but not individual holdings. Is there a way of fixing this problem? I suppose I could have each holding as a separate portfolio, and copy the valuations into my spreadsheet. That would be better than a list of bookmarks to the funds.
Trustnet appears to give the latest prices for open ended funds, but out of date prices for ETFs. The website is also very slow.
I tried to open an account with Morningstar, but it would not accept any password that I typed.
I successfully created portfolio with the FT. It appears to give up to date prices after market close. It gives valuations for each portfolio as a whole, but not individual holdings. Is there a way of fixing this problem? I suppose I could have each holding as a separate portfolio, and copy the valuations into my spreadsheet. That would be better than a list of bookmarks to the funds.
-
- Lemon Half
- Posts: 8507
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1569 times
- Been thanked: 3463 times
Re: Portfolio Tools
For the ETF's , could you use HYPTUSS? ( Excel or the free OpenOffice).? It might help with the ETF side of your portfolio.
-
- Lemon Half
- Posts: 9109
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10061 times
Re: Portfolio Tools
GeoffF100 wrote:
I successfully created portfolio with the FT. It appears to give up to date prices after market close.
It gives valuations for each portfolio as a whole, but not individual holdings.
Is there a way of fixing this problem?
If you've already got the individual FT details for your holdings, then as monabri has said, HYPTUSS might deliver what you're after -
https://i.imgur.com/BszZDNq.png
The process shown on the above screen-shot isn't part of the core HYPTUSS functionality, but we've added it as a stand-alone 'FT Funds' sheet as your requirement does tend to crop up from time to time.
You can download the latest version of HYPTUSS on the following link if you want to give it a go -
http://lemonfoolfinancialsoftware.weebly.com/hyp-top-up.html
If that basic functionality does the job for you in terms of grabbing individual prices, then you could add an extra sheet to then pull those updated prices over, and then add some bells and whistles to a more detailed 'Funds Portfolio' sheet....
Cheers,
Itsallaguess
-
- Lemon Quarter
- Posts: 4137
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3293 times
- Been thanked: 2871 times
Re: Portfolio Tools
GeoffF100 wrote:I want an easy way of keeping track of my Vanguard ETFs and open ended funds. My Vanguard account appears to give the latest prices after market close. iWeb does not.
HYPTUSS is certainly a possibility, though shares/ETFs are on a different sheet to open-ended funds. Not a big problem, data can be consolidated on a new sheet.
An alternative is the LibreOffice extension I mentioned here: viewtopic.php?f=27&t=31579&p=448738#p448738
It gets prices for shares and ETFs from Yahoo, and shares, ETFs and funds from the FT
Here's a simple example: https://postimg.cc/JtJNKyQn
If you don't have LibreOffice and don't want to install another piece of software, you can use the portable version: https://portableapps.com/apps/office/li ... e_portable
--kiloran
-
- Lemon Quarter
- Posts: 4835
- Joined: November 14th, 2016, 7:33 pm
- Has thanked: 182 times
- Been thanked: 1397 times
Re: Portfolio Tools
Thank you both for your help. I have two Vanguard open ended funds and two Vanguard ETFs. Two of these funds appear on two different platforms, so I have six holdings in all. I typically value my portfolio every 3-6 months. My easiest option is to set up a separate FT portfolio for each holding. I can then cut and paste the holding valuations into my spreadsheet.
If someone can let me know how to set up a valid Morninstar password, that might be a better option.
If someone can let me know how to set up a valid Morninstar password, that might be a better option.
-
- Lemon Quarter
- Posts: 4137
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3293 times
- Been thanked: 2871 times
Re: Portfolio Tools
GeoffF100 wrote:If someone can let me know how to set up a valid Morninstar password, that might be a better option.
I tried to create a Morningstar account and also failed the password test, using Chrome, Edge and Firefox. I tried all manner of passwords which all complied with their stated password rules, but it complained about the password each time.
I also tried signing in with an account I created some years ago, and that worked OK.
--kiloran
-
- Lemon Quarter
- Posts: 4137
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3293 times
- Been thanked: 2871 times
Re: Portfolio Tools
kiloran wrote:GeoffF100 wrote:If someone can let me know how to set up a valid Morninstar password, that might be a better option.
I tried to create a Morningstar account and also failed the password test, using Chrome, Edge and Firefox. I tried all manner of passwords which all complied with their stated password rules, but it complained about the password each time.
I also tried signing in with an account I created some years ago, and that worked OK.
--kiloran
I reported the problem to Morningstar. Bizarrely, I could only report the sign-up problem by signing in, so it's a good job I registered an account some years ago. They responded within a few hours asking for more details, so hopefully they can resolve the problem quite quickly
--kiloran
-
- Lemon Quarter
- Posts: 4835
- Joined: November 14th, 2016, 7:33 pm
- Has thanked: 182 times
- Been thanked: 1397 times
Re: Portfolio Tools
I am glad to hear that it is not only me. I got a message in red telling me the required password format, but only part of the text fitted into the window. I could not scroll within the window or resize it.
I have set my fund holdings up as portfolios with the FT tool, which will do for now.
I have set my fund holdings up as portfolios with the FT tool, which will do for now.
-
- Lemon Quarter
- Posts: 4137
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3293 times
- Been thanked: 2871 times
Re: Portfolio Tools
GeoffF100 wrote:I am glad to hear that it is not only me. I got a message in red telling me the required password format, but only part of the text fitted into the window. I could not scroll within the window or resize it.
I have set my fund holdings up as portfolios with the FT tool, which will do for now.
I got an email from Morningstar to say that they have reported the problem to their IT team and passed on the details I provided, but I have heard nothing for the past 2 days.
I just tried creating a new account and it worked fine, no password problems, so it looks like they have fixed it. The password I tried was 18axzpq62W which appears to meet all of their rules. I've since changed it and that was also OK.
Give it a try
--kiloran
-
- Lemon Quarter
- Posts: 4835
- Joined: November 14th, 2016, 7:33 pm
- Has thanked: 182 times
- Been thanked: 1397 times
Re: Portfolio Tools
Thank you very much. I have now been able to create an account. The user interface is little challenging, but I think it will do the job.
-
- Lemon Quarter
- Posts: 4835
- Joined: November 14th, 2016, 7:33 pm
- Has thanked: 182 times
- Been thanked: 1397 times
Re: Portfolio Tools
The valuations given by the FT portfolio tool have not always been consistent with their historical closing prices. The Morningstar valuations have always been consistent with the FT historical closing prices. The Morningstar tool wins easily. It seems to reliably give the closing prices and the latest valuations for open ended funds at the weekend. This weekend is an end of month, so I should be able to compare my portfolio with the Vanguard data for a global tracker. iWeb did not give the latest price for Vanguard Developed World ex UK this morning. iWeb always values new style index linked gilts incorrectly. I get the correct "dirty" prices (with indexation) from here:
https://reports.tradeweb.com/account/login/
https://reports.tradeweb.com/account/login/
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 16 guests