Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Unable to locate data for mutual fund
Greetings
I am attemtping to add a mutual fund to my portfolio slicer but I'm not having much luck. I'm hoping that either someone has been able to add it or someone may have some suggestions.
The fund itself is PIMCO Monthly Income-A (PMO005) available through Pimco Canada. (https://www.pimco.ca/en-ca/investments/mutual-funds/monthly-income-fund-canada/cada-cad-unhedged)
Google Finance has historical data up to December 28, but not beyond [PIMCO Monthly Income A(MUTF_CA:PMO005)]. When I add MUTF_CA:PMO005 to the Google Finance section in the psconfig script, I get the following back in the log:
Symbol: MUTF_CA:PMO005. Next date: 2015-12-31. Quote file: C:\Users\Dave\Documents\PortfolioSlicer\Quotes\_MUTF_CA_PMO005_.txt
Requesting url: http://www.google.com/finance/historical?q=MUTF_CA:PMO005&startdate=Dec+31,+2015&output=csv
MUTF_CA:PMO005 - Not Found (web err)
If I move the MUTF_CA:PMO005 down under the Google Web section, the script hangs, and when I look at the log for the psconfig scritp, I get the following:
Symbol: MUTF_CA:PMO005. Next date: 2015-12-31. Quote file: C:\Users\Dave\Documents\PortfolioSlicer\Quotes\_MUTF_CA_PMO005_.txt
Requesting url: https://www.google.com/finance/historical?q=MUTF_CA:PMO005&num=200&start=0&startdate=Dec+31,+2015
MUTF_CA:PMO005 - Not Found (web err)
In Yahoo Finance the ticker seems to be PIMCO Monthly Income A (F00000LVW4.TO), however the last data is the same as Google Finance for December 28 but nothing beyond that.
If I try Alpha Vantage, a blank quote file is created but it's empty for F00000LVW4.TO and an error message for F00000LVW4 (no .TO).
Symbol: F00000LVW4.TO. Next date: 2015-12-31. Quote file: C:\Users\Dave\Documents\PortfolioSlicer\Quotes\_F00000LVW4.TO_.txt
Requesting url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=F00000LVW4.TO&apikey=F7ZW7PVJ59D7NALC&datatype=csv&outputsize=full
Done: F00000LVW4.TO. No new quotes found.
Symbol: F00000LVW4. Next date: 2015-12-31. Quote file: C:\Users\Dave\Documents\PortfolioSlicer\Quotes\_F00000LVW4_.txt
Requesting url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=F00000LVW4&apikey=F7ZW7PVJ59D7NALC&datatype=csv&outputsize=full
***Error from website: {
"Error Message": "Invalid API call. Please retry or visit the documentation (https://www.alphavantage.co/documentation/) for TIME_SERIES_DAILY."
}
If I go into Morningstar Fiance, and enter the ticker F00000LVW4, data for it is there for the new year (up to yesterdays close).
If I go into Ycharts, it too has historical data up to yesterdays close (https://ycharts.com/mutual_funds/M:PMO005.TO/price).
So there is current data out there, but none that work with the psconfig script.
Any suggestions would be appreciated.
I am attemtping to add a mutual fund to my portfolio slicer but I'm not having much luck. I'm hoping that either someone has been able to add it or someone may have some suggestions.
The fund itself is PIMCO Monthly Income-A (PMO005) available through Pimco Canada. (https://www.pimco.ca/en-ca/investments/mutual-funds/monthly-income-fund-canada/cada-cad-unhedged)
Google Finance has historical data up to December 28, but not beyond [PIMCO Monthly Income A(MUTF_CA:PMO005)]. When I add MUTF_CA:PMO005 to the Google Finance section in the psconfig script, I get the following back in the log:
Symbol: MUTF_CA:PMO005. Next date: 2015-12-31. Quote file: C:\Users\Dave\Documents\PortfolioSlicer\Quotes\_MUTF_CA_PMO005_.txt
Requesting url: http://www.google.com/finance/historical?q=MUTF_CA:PMO005&startdate=Dec+31,+2015&output=csv
MUTF_CA:PMO005 - Not Found (web err)
If I move the MUTF_CA:PMO005 down under the Google Web section, the script hangs, and when I look at the log for the psconfig scritp, I get the following:
Symbol: MUTF_CA:PMO005. Next date: 2015-12-31. Quote file: C:\Users\Dave\Documents\PortfolioSlicer\Quotes\_MUTF_CA_PMO005_.txt
Requesting url: https://www.google.com/finance/historical?q=MUTF_CA:PMO005&num=200&start=0&startdate=Dec+31,+2015
MUTF_CA:PMO005 - Not Found (web err)
In Yahoo Finance the ticker seems to be PIMCO Monthly Income A (F00000LVW4.TO), however the last data is the same as Google Finance for December 28 but nothing beyond that.
If I try Alpha Vantage, a blank quote file is created but it's empty for F00000LVW4.TO and an error message for F00000LVW4 (no .TO).
Symbol: F00000LVW4.TO. Next date: 2015-12-31. Quote file: C:\Users\Dave\Documents\PortfolioSlicer\Quotes\_F00000LVW4.TO_.txt
Requesting url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=F00000LVW4.TO&apikey=F7ZW7PVJ59D7NALC&datatype=csv&outputsize=full
Done: F00000LVW4.TO. No new quotes found.
Symbol: F00000LVW4. Next date: 2015-12-31. Quote file: C:\Users\Dave\Documents\PortfolioSlicer\Quotes\_F00000LVW4_.txt
Requesting url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=F00000LVW4&apikey=F7ZW7PVJ59D7NALC&datatype=csv&outputsize=full
***Error from website: {
"Error Message": "Invalid API call. Please retry or visit the documentation (https://www.alphavantage.co/documentation/) for TIME_SERIES_DAILY."
}
If I go into Morningstar Fiance, and enter the ticker F00000LVW4, data for it is there for the new year (up to yesterdays close).
If I go into Ycharts, it too has historical data up to yesterdays close (https://ycharts.com/mutual_funds/M:PMO005.TO/price).
So there is current data out there, but none that work with the psconfig script.
Any suggestions would be appreciated.
Comments
2. Your mutuall fund PMO005 should be under google web and it should work with updated scripts.
Would it be possible to include a version number of the scripts being used. I thought I was using the latest but obviously not. If there was a version number at the top of say the psconfig script it would be easy to compare with something online so we could check to see if we're using the latest.
Thanks again!