FW: Installing GNUCash FinanceQuote onto Windows XP
Rushworth, Nicholas D
nick.rushworth at bp.com
Wed Nov 28 14:56:17 EST 2007
Further test results
Z:\>gnc-fq-check.pl
("1.12" "tsp" "vwd" "financecanada" "yahoo_nz" "australia" "usa"
"troweprice" "f
rance" "amfiindia" "nasdaq" "usfedbonds" "bmonesbittburns" "aex_options"
"yahoo_
asia" "troweprice_direct" "tiaacref" "canada" "yahoo" "seb_funds"
"yahoo_brasil"
"fidelity" "greece" "dwsfunds" "yahoo_australia" "unionfunds" "finland"
"lereve
nu" "asia" "indiamutual" "hex" "brasil" "asegr" "deka" "nyse"
"canadamutual" "fi
delity_direct" "asx" "tdwaterhouse" "fool" "trustnet"
"ftportfolios_direct" "uk_
unit_trusts" "dutch" "ftportfolios" "tdefunds" "nzx" "za" "aex_futures"
"fundlib
rary" "aex" "yahoo_europe" "nz" "vanguard" "bourso" "europe" "platinum"
"maninv"
)
*** I take this to mean the FinanceQuote module is installed
correctly ***
Z:\>echo yahoo "AAPL"
yahoo "AAPL"
Z:\>echo yahoo "AAPL" | gnc-fq-helper.pl
The process tried to write to a nonexistent pipe.
*** Not sure why this isn't piping across into helper ****
z:\>gnc-fq-dump.pl
Usage: c:\program files\gnucash\bin\gnc-fq-dump.pl <quote-source> [-v]
<stock> [
<stock> ...]
Available sources are:
tsp vwd financecanada yahoo_nz australia usa troweprice france
amfiindia na
sdaq usfedbonds bmonesbittburns aex_options yahoo_asia troweprice_direct
tiaacre
f canada yahoo seb_funds yahoo_brasil fidelity greece dwsfunds
yahoo_australia u
nionfunds finland lerevenu asia indiamutual hex brasil asegr deka nyse
canadamut
ual fidelity_direct asx tdwaterhouse fool trustnet ftportfolios_direct
uk_unit_t
rusts dutch ftportfolios tdefunds nzx za aex_futures fundlibrary aex
yahoo_europ
e nz vanguard bourso europe platinum maninv
*** I take this to mean the basic code is parsing OK in the DOS CMD
window ***
z:\>gnc-fq-dump.pl currency USD EUR
1 USD = <unknown> EUR
z:\>gnc-fq-dump.pl yahoo CSCO
No results found for stock CSCO.
z:\>gnc-fq-dump.pl NASDAQ AMZN
No results found for stock AMZN.
z:\>gnc-fq-dump.pl -v europe BGY.L
Finance::Quote fields Gnucash uses:
symbol: BGY.L (deduced) <=== required
date: ** missing ** <=== required
currency: ** missing ** <=== required
last: <=\
nav: <=== one of these
price: <=/
timezone: <=== optional
** This stock quote cannot be used by gnucash!!
All fields returned by Finance::Quote for stock BGY.L
stock field value
----- ----- -----
BGY.L errormsg: HTTP session failed
BGY.L last: **missing**
BGY.L nav: **missing**
BGY.L price: **missing**
BGY.L success: 0
Nick
-----Original Message-----
From: Rushworth, Nicholas D
Sent: 28 November 2007 18:08
To: 'Derek Atkins'
Cc: gnucash-user at gnucash.org
Subject: RE: Installing GNUCash FinanceQuote onto Windows XP
I have installed Perl into the directory C:\program files\perl I have
installed GNUCash into the directory C:\program files\gnucash
My path is set to C:\program files\Perl\bin;c:\program
files\perl;c:\program files\gnucash;c:\program files\gnucash\bin
I tried typing gnc-fq-dump in a dos window with no luck so I made a
copy of the file with a ".pl" extension and now when I type
gnc-fq-dump.pl I get a good looking output showing a long list of
available sources
I tried the same trick with gnc-fq-helper.pl and I get no response
Nick
-----Original Message-----
From: Derek Atkins [mailto:warlord at MIT.EDU]
Sent: 28 November 2007 14:39
To: Rushworth, Nicholas D
Cc: gnucash-user at gnucash.org
Subject: Re: Installing GNUCash FinanceQuote onto Windows XP
hi,
Please remember to CC the list on all replies using your mailer's
Reply-To-List or Reply-To-All functions.
"Rushworth, Nicholas D" <nick.rushworth at bp.com> writes:
> Derek,
>
> Thanks for getting back so quickly. I've run from "Start" and it's
> ungreyed so that's that problem fixed. Thanks
>
> Can I be cheeky and give you my next problem ?
>
> I'm following the tutorial for stocks and I've added an account for
> Amazon and a price editor entry for AMZN. So far so good. Now I click
on
> tools / price editor / get quotes and it doesn't work.
>
> I see a new window open up for DOS with the path c:\program
> files\perl\bin it's blank and no lines of code appear. Nothing
> happens for a few seconds then the DOS command/perl window closes and
a
> pop-up error window opens with the message "There was an unknown
> error while retrieving the price quotes."
>
>
> I've looked in FAQ, Google and bugzilla with no luck.
>
> Any ideas ?
Is PERL in your path?
If you open a shell, does the gnc-fq-dump program work?
What about gnc-fq-helper?
Check the archives for command syntax.
-derek
>
> Nick Rushworth
> Strategic Information Manager
> BP Angola
> e&pdct
> M: +44 7919 210940
> E: Nick.Rushworth at bp.com
> W: http://epdct.bpweb.bp.com
>
> BP Exploration Operating Company Limited, a company registered in
> England and Wales with the company number 305943 and whose registered
> office is Chertsey Road, Sunbury on Thames, Middlesex TW16 7BP.
>
> -----Original Message-----
> From: Derek Atkins [mailto:warlord at MIT.EDU]
> Sent: 28 November 2007 00:12
> To: Rushworth, Nicholas D
> Cc: gnucash-user at gnucash.org
> Subject: Re: Installing GNUCash FinanceQuote onto Windows XP
>
> Hi,
>
> Quoting "Rushworth, Nicholas D" <nick.rushworth at bp.com>:
>
>> Hi,
>>
>> I've installed GNUCash onto my Windows XP machine but I'm having
>> trouble getting automatic on-line pricing working.
>>
>> I've checked your help sheets
>> http://svn.gnucash.org/docs/help/acct-create.html#Online-price-setup
>> but I'm struggling to understand to do.
>>
>> I've found the file gnc-fq-update but since it has no file extension
>> it doesn't run I installed perl and tried renaming the file to
>> gnc-fq-update.pl that runs but generates an error message looking
>> for
>
>> SSL path
>
> The gnc-fq-update script is only for Unix. On Windows you just
> use the entry in your Start Menu.
>
>> Now I'm stuck !
>>
>> Nick Rushworth
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
> Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> Member, MIT Student Information Processing Board (SIPB)
> URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
> warlord at MIT.EDU PGP key available
>
>
>
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
More information about the gnucash-user
mailing list