Managed Funds Feed of managed fund daily unit prices

I just use excel and it works great. Add the tool bar "External Data" if you didn't install the complete copy of excel you will need the Office CD.

Then just go to data > import external data > web based query. Then just browse to the site of your managed funds and bring the table in.

I then just use excel to do the calculations of values on any given day. I just have a cover sheet that shows a summary and let the web query run every few hours to keep it updated.

Hope this is clear enough.

Grimey

 

tradingroom.com.au

 

Sim
Just wondering if you found one of these data feeds by any chance?
Would be good not only for tracking your existing portfolio, but you could also apply a simplified trend trading approach to managed funds by using the data feed with some charting software.
Say for example if one of your invested funds is dropping for a set period or below a certain unit price, you could bail out of that one and jump into one that is trending upwards.
With a bit of work and research, you may be able to eliminate the down times that drop your average return. Even if you can pull an extra 2% on your average after costs through such a system, that would make a huge difference over the years.

 

I don't know if you're affiliated with NavraInvest somehow, but if so they may have Bloomberg. You can write Excel queries to pull stock data straight from a Bloomberg terminal. If you do, Bloomberg have training courses most days at lunch in the city and some are about the API.

Otherwise, the big issue is you want it to be free/cheap. What's your definition of cheap? Is $50/month ok? You may be able to get access to fund data from a web service for that kind of money. Definitely stock data and probably fund data.

 

i know the excel approach can work fairly good if you run it via free websites, how would you run it though if you wanted to access share portfolios, would you run it through your broker website (i use westpac) or just via the main asx website, in saying this i would want to have closing prices in a list, does anyone know a non private website that would have this...

i just want everything in one place and i know i can use portfolio tools but you just cant get managed fund prices up to date.

Currently on my margin loan, my prices are about 2 weeks behind todays price... gives me time if i know a a margin call is coming

thanks for putting me on the excel stuff frankgrimes.. i may pm you if i cant get this vlookup working....

cheers

 

Hey Frank - any chance of posting a sample Excel file which gets a couple of fund prices from any fund websites just to show hwo this works?

This sounds awesome. I currently get quite a lot of funds manually every day and type the prices into excel! Would save me a good 10 minutes/day!

 

I see you have also expanded the horizons from somersoft! hehe....

 

Hi DaveA whats the problem with the VLOOKUP?
Cheers
Pudsa

 

no its ok ive solved the vlookup issue i was having...im going to spend a bit of time on the sheet 2morrow and if anyone is interested i can send them a copy once it is complete.

but does anyone know how to do a automatic 'paste special' so it pastes a value from a formula. I want to keep a track of the daily prices and ubs only provide with the current and previous day prices (same with share prices). I was hoping i could set up something to an if function that when the dates of 2 cells are equal, it pastes the value into a 3rd cell, i know i can do it via a formula, however when one date changes the values then just get deleted becuase it was a formula

if i can solve this i will be a very happy man so any suggestions would be great...

 

ok, ive got someone to write a code for me, that when on websites that only shows one day price it will save those into another sheet with the matching date...

next step is to find the best website to pull share prices off, i only want to get the closing share price from the previous day (not the real time (delayed) price so im off to do some searching...

 

ok guys after a bit of time ive come up with this...

this is mine includes 2 loans (so different interest rates).... it has 4 funds and 1 share... its fairly easy to do but you just need alot of time and a good idea of how formulas work

if anyone can think of anything how to make it simplier then more than welcome to here some feedback

Download from Here

 

Dave,

This is indeed great stuff.
It's amazing!

If it can work with any funds/shares then it would be the ultimate tracking tool.

 

it can work with any fund however its a bit difficult to find the page you can download off... some are easy, but in particular the ing funds (which my girlfriend has, and i did the same thing) are very difficult until you find the correct page to put ur data from... basically the best test is, if you can book mark the page, its a very easy task, if you bookmark a page and it when selected sends you to a different page you then need to look for another page to select your data from... theres sort of no way to manipulate this way... this is the only difficult part about the spreadsheet, everything else is fairly straight forward but just time consuming...

its a very good tracking tool, however in down times like today its not wise to know... my LVR on the spreadsheet is about 1% higher than my margin loan page due to delay of information on their behalf... getting 2 close to a margin call for my liking...