more errors / suggestions February 10, 2013 08:59PM | Registered: 11 years ago Posts: 20 |
[YahooExtQuoteCSV Section] Name=YahooExtQuoteCSV AddOn=c:\python26\python Output File="C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\quoteCSVpy.csv" Output Format=0 Header Schema=1 Schema="C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\quoteCSVSchema.csv" URL Template="C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\QuoteCSV.py" "http:// finance.yahoo.com/d/quotes.csv?s=%s+&f=sl1d1t1" Real Time=1 Historical=0 Tickers in Output=1 Request Tickers=20 Login ID= Password=Found this in the ini file which again shows how the quotes aren't working properly ( 2 of them are missing)
Last External Launch=c:\python26\python C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\QuoteCSV.py" "http:// finance.yahoo.com/d/quotes.csv?s=F+DD&f=sl1d1t1 "C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\quoteCSVpy.csv" ; Note: space added after 'http://'
Re: more errors / suggestions February 11, 2013 08:56PM | Admin Registered: 7 years ago Posts: 164 |
Quote
When running the program first-time, the Quote Sources don't show up as the ini file isn't created until the first exit, so I added this to the Help page.
Quote
None of my internal quote sources work, so I proceeded in adding YahooExtQuoteCSV as a python external quote source. My PC OS is XP SP3.
2013-01-24_01-25-55=Getting 'Finance.Yahoo.CSV' quotes for Money investments set for Online updates. 2013-01-24_01-25-55=OnLine $INDU Index Dow Jones Industrial AverageA successful update would look like
2013-01-24_01-25-57=OnLine CSCO Stock Cisco Systems 2013-01-24_01-25-58=CSCO: updating 'Wednesday, January 23, 2013' now 20.62 was 20.66.In this case the stock was updated because the price for that date (which was already there) had changed.
2013-01-24_01-26-07=XXXXX: date 'Wednesday, January 23, 2013' not found in Money (closest was Tuesday, January 22, 2013). 2013-01-24_01-26-07=Creating XXXXX 11.02 Wednesday, January 23, 2013In this case, the quote for 1/23 did not exist. The closest was the day before, so PalOMoney created a new online quote.
2013-01-24_01-25-55=$INDU returned 0 Quotes. 2013-01-24_01-25-58=CSCO returned 1 Quotes.Use this to check and possibly adjust your symbols.
Ticker, Close, Date, Time "$INDU",0.00,"N/A","N/A" "CSCO",20.62,"1/23/2013","4:00pm"This file can be fed into PalOMoney at a later date to update another file, or another program that can read the .csv.
Quote
I was getting "External Module returned error code 2" and determined that I needed to add quotes to my output and schema file paths which contain blank spaces.
Quote
Although the quotes show up in the ini file, they don't "stick" in the QuoteSource window or the program and now I get "External Module returned error code 1" and "QuoteCSVpy.csv output file does not exist 123 or is empty (0)" even though the folder has write permissions.
[ Quote Sources ] ... ( 4 internal source entries ) ... YahooExtQuoteCSV=YahooExtQuoteCSV SectionThese entries populate the Quote Source selector and the record selector in the Quote Source dialog.
; Yours URL Template="C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\QuoteCSV.py" "http:// finance.yahoo.com/d/quotes.csv?s=%s+&f=sl1d1t1" ; Example c:\python27\QuoteCSV.py "http:// finance.yahoo.com/d/quotes.csv?s=%s+&f=sl1d1t1" ; Your Last Launched Last External Launch=c:\python26\python C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\QuoteCSV.py" "[finance.yahoo.com] "C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\quoteCSVpy.csv"
Quote
Found this in the ini file which again shows how the quotes aren't working properly ( 2 of them are missing)
(followed by the Last External Launch entry above)
Quote
PalOMoney seems to assume that every investment needs to get quotes from the same source which is not true, unless that is what the future Grouping feature is for.
Quote
Activating the Hidden button doesn't appear to reveal any old or closed out securities. It turns out all my closed out securities were zero shares, so without the zero option enabled they wouldn't show up.
Quote
It would be nice if the selected Quote Source would be remembered in the pull-down.
Re: more errors / suggestions February 11, 2013 10:04PM | Admin Registered: 7 years ago Posts: 164 |
; Note: space added after 'http://' ; Before URL Template="C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\QuoteCSV.py" "http:// finance.yahoo.com/d/quotes.csv?s=%s+&f=sl1d1t1" ; Yields Last External Launch=c:\python26\python C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\QuoteCSV.py" "http:// finance.yahoo.com/d/quotes.csv?s=F+DD&f=sl1d1t1 "C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\quoteCSVpy.csv"
c:\python27\python "C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\QuoteCSV.py" "http:// finance.yahoo.com/d/quotes.csv?s=F+DD&f=sl1d1t1" "C:\Documents and Settings\Dan's\My Documents\Microsoft Money\PalOMoney\quoteCSVpy.csv"Writes the file correctly:
"F",13.11,"2/11/2013","4:00pm" "DD",47.76,"2/11/2013","4:00pm"