slew77 / hle-ofx-quotes

Automatically exported from code.google.com/p/hle-ofx-quotes
0 stars 1 forks source link

Unable to download (Canadian only?) mutual fund prices from yahoo finance - tickers are available #55

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Add ticker symbols for known mutual funds found on yahoo finance
2. Ticker 1: F0CAN05P64.TO
3. Ticker 2: SCOTIACANADI.TO

What is the expected output? What do you see instead?
Expecting mutual fund prices to be downloaded

What version of the product are you using? On what operating system?
hleOfxQuotes-Build_20111221_78-app

Please provide any additional information below.

Original issue reported on code.google.com by jasonsau...@gmail.com on 23 Feb 2012 at 3:52

GoogleCodeExporter commented 8 years ago
Log file shows this:

2012-02-22 22:34:25,094 [pool-4-thread-2] WARN  
com.le.tools.moneyutils.stockprice.StockPrice - stockSymbol: F0CAN05P64.TO - 
java.text.ParseException: Unparseable date: "N/A"

Given that mutual funds prices usually update the following day, is it possible 
to pull the date from the previous close and have this exported to the OFX with 
the correct date/timestamp?

Original comment by jasonsau...@gmail.com on 23 Feb 2012 at 4:00

GoogleCodeExporter commented 8 years ago
Also, to answer the obvious I did setup mapper.csv and verified it was working, 
both report Mutual Fund as true under the Mapper tab

Original comment by jasonsau...@gmail.com on 23 Feb 2012 at 4:17

GoogleCodeExporter commented 8 years ago
Yahoo actually does not have data for these symbol in CSV format. The actual 
CSV data provided by Yahoo is

F0CAN05P64.TO   0   N/A N/A N/A N/A N/A N/A N/A

Will do some additional investigation to see what other scheme we can use.

Original comment by hle...@gmail.com on 24 Feb 2012 at 3:46

GoogleCodeExporter commented 8 years ago
Please use this hot-fix version: 

  http://sunriise.sourceforge.net/out/hleofxquotes/Build_20120205_78/hleOfxQuotes-Build_20120205_78-app.jar

Then use the "Yahoo Options" quoteSource/tab. Though that quoteSource was 
geared toward options but should work also for symbols that does not have *.csv 
data.

Original comment by hle...@gmail.com on 24 Feb 2012 at 3:58

GoogleCodeExporter commented 8 years ago
This worked! Your app is awesome. thank you!!! 

Original comment by jasonsau...@gmail.com on 24 Feb 2012 at 6:32

GoogleCodeExporter commented 8 years ago

Original comment by hle...@gmail.com on 24 Feb 2012 at 11:23