Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)
That was it. Rounding down to 9 decimal places works. Thank you! -Original Message- From: John Ralls Sent: Wednesday, May 08, 2024 10:13 PM To: Kalpesh Patel Cc: GnuCash User Subject: Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02) Kalpesh, I think your price has too many digits. Try rounding it to 10E-9. Regards, John Ralls > On May 8, 2024, at 09:05, Kalpesh Patel wrote: > > Hi GNC User community - > > > > I am developing a second F::Q module of my own. The first one works > fine but second one seems to NOT want to work no matter what. I am in > middle of debugging it and it has stomped me why not so hoping someone > might be able to help me zero in where I am falling sort on the flow > for it. I am working with F::Q v1.61_02 and GNC v4.14 > (4.14+(2023-03-25) build) running on Windows 11. (Note: I don't > believe any interface change has taken place in GNC v5.x that would cause this but correct me here if I am wrong.). > > > > Invoking GNC with debug shows that return value is #f, which means > something went wrong (run_executor is the "label" for my module and > other modules work fine from the debug output): > > > > 11:19:24 DEBUG handling-request: (currency INR USD) > > * 11:19:24 DEBUG results: ((INR (symbol . INR) (gnc:time-no-zone . > 2024-05-08 11:19:11) (last . 3/250) (currency . USD))) > > * 11:20:38 DEBUG ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY > > * 11:20:39 DEBUG handling-request: (tsp C S L2030 I) > > * 11:20:43 DEBUG results: ((C (symbol . C) (gnc:time-no-zone . > 2024-05-07 12:00:00) (last . 812423/1) (currency . USD)) (S > (symbol . S) (gnc:time-no-zone . 2024-05-07 12:00:00) (last . 4009/50) > (currency . USD)) > (L2030 (symbol . L2030) (gnc:time-no-zone . 2024-05-07 12:00:00) (last . > 237163/5000) (currency . USD)) (I (symbol . I) (gnc:time-no-zone . > 2024-05-07 12:00:00) (last . 42507/1000) (currency . USD))) > > * 11:20:43 DEBUG handling-request: (run_executor BK) > > * 11:20:43 DEBUG results: (#f) > > * 11:20:43 DEBUG handling-request: (yahoojson ^NYA) > > * 11:20:44 DEBUG results: ((^NYA (symbol . ^NYA) > (gnc:time-no-zone . 2024-05-08 12:00:00) (last . 2247813/125) > (currency . USD))) > > > > Following is debug run from command line of gnc-fq-dump (which > provides all necessary fields for quote to be valid as it does not > show '** This stock quote cannot be used by GnuCash!' message): > > > > C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" > -v run_executor BK > > {snip} > > ### [Wed May 8 11:34:40 2024] %info : { > > ###'BKISIN' => '-', > > ###'BKcurrency' => 'USD', > > ###'BKdate' => '05/08/2024', > > ###'BKisodate' => '2024-05-08', > > ###'BKmethod' => 'run_executor', > > ###'BKprice' => '57.64500045776367', > > ###'BKsuccess' => '1', > > ###'BKsymbol' => 'BK', > > ###'BKtimezone' => 'EDT' > > ### } > > Finance::Quote fields Gnucash uses: > > symbol: BK <=== required > >date: 05/08/2024 <=== recommended > > currency: USD <=== required > >last: <=\ > > nav: <=== one of these > > price: 57.64500045776367<=/ > > timezone: EDT <=== optional > > > > All fields returned by Finance::Quote for stock BK > > > > stock field value > > - - - > > BK ISIN: - > > BK currency: USD > > BK date: 05/08/2024 > > BKisodate: 2024-05-08 > > BK method: run_executor > > BK price: 57.64500045776367 > > BKsuccess: 1 > > BK symbol: BK > > BK timezone: EDT > > > > > > C:\Users\kalpesh> > > > > When running same command via YahooJSON following is the output which > works fine (I see that it does have more informa
Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)
Kalpesh, I think your price has too many digits. Try rounding it to 10E-9. Regards, John Ralls > On May 8, 2024, at 09:05, Kalpesh Patel wrote: > > Hi GNC User community - > > > > I am developing a second F::Q module of my own. The first one works fine but > second one seems to NOT want to work no matter what. I am in middle of > debugging it and it has stomped me why not so hoping someone might be able > to help me zero in where I am falling sort on the flow for it. I am working > with F::Q v1.61_02 and GNC v4.14 (4.14+(2023-03-25) build) running on > Windows 11. (Note: I don't believe any interface change has taken place in > GNC v5.x that would cause this but correct me here if I am wrong.). > > > > Invoking GNC with debug shows that return value is #f, which means something > went wrong (run_executor is the "label" for my module and other modules work > fine from the debug output): > > > > 11:19:24 DEBUG handling-request: (currency INR USD) > > * 11:19:24 DEBUG results: ((INR (symbol . INR) (gnc:time-no-zone . > 2024-05-08 11:19:11) (last . 3/250) (currency . USD))) > > * 11:20:38 DEBUG ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY > > * 11:20:39 DEBUG handling-request: (tsp C S L2030 I) > > * 11:20:43 DEBUG results: ((C (symbol . C) (gnc:time-no-zone . > 2024-05-07 12:00:00) (last . 812423/1) (currency . USD)) (S (symbol . S) > (gnc:time-no-zone . 2024-05-07 12:00:00) (last . 4009/50) (currency . USD)) > (L2030 (symbol . L2030) (gnc:time-no-zone . 2024-05-07 12:00:00) (last . > 237163/5000) (currency . USD)) (I (symbol . I) (gnc:time-no-zone . > 2024-05-07 12:00:00) (last . 42507/1000) (currency . USD))) > > * 11:20:43 DEBUG handling-request: (run_executor BK) > > * 11:20:43 DEBUG results: (#f) > > * 11:20:43 DEBUG handling-request: (yahoojson ^NYA) > > * 11:20:44 DEBUG results: ((^NYA (symbol . ^NYA) (gnc:time-no-zone > . 2024-05-08 12:00:00) (last . 2247813/125) (currency . USD))) > > > > Following is debug run from command line of gnc-fq-dump (which provides all > necessary fields for quote to be valid as it does not show '** This stock > quote cannot be used by GnuCash!' message): > > > > C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v > run_executor BK > > {snip} > > ### [Wed May 8 11:34:40 2024] %info : { > > ###'BKISIN' => '-', > > ###'BKcurrency' => 'USD', > > ###'BKdate' => '05/08/2024', > > ###'BKisodate' => '2024-05-08', > > ###'BKmethod' => 'run_executor', > > ###'BKprice' => '57.64500045776367', > > ###'BKsuccess' => '1', > > ###'BKsymbol' => 'BK', > > ###'BKtimezone' => 'EDT' > > ### } > > Finance::Quote fields Gnucash uses: > > symbol: BK <=== required > >date: 05/08/2024 <=== recommended > > currency: USD <=== required > >last: <=\ > > nav: <=== one of these > > price: 57.64500045776367<=/ > > timezone: EDT <=== optional > > > > All fields returned by Finance::Quote for stock BK > > > > stock field value > > - - - > > BK ISIN: - > > BK currency: USD > > BK date: 05/08/2024 > > BKisodate: 2024-05-08 > > BK method: run_executor > > BK price: 57.64500045776367 > > BKsuccess: 1 > > BK symbol: BK > > BK timezone: EDT > > > > > > C:\Users\kalpesh> > > > > When running same command via YahooJSON following is the output which works > fine (I see that it does have more information returned back): > > > > C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v > yahoojson BK > > {snip} > > Finance::Quote fields Gnucash uses: > > symbol: BK <=== required > >date: 05/08/2024 <=== recommended > > currency: USD <=== required > >last: 57.605 <=\ > > nav: <=== one of these > > price: <=/ > > timezone: <=== optional > > > > All fields returned by Finance::Quote for stock BK > > > > stock field value > > - - - > > BK close: 57.4 > > BK currency: USD > > BK date: 05/08/2024 > > BK div_yield: 2.8397212 > > BKeps: 3.99 > > BK exchange: NYSE > > BK high: 57.75 > > BKisodate: 2024-05-08 > > BK last: 57.605 > > BKlow
[GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)
Hi GNC User community - I am developing a second F::Q module of my own. The first one works fine but second one seems to NOT want to work no matter what. I am in middle of debugging it and it has stomped me why not so hoping someone might be able to help me zero in where I am falling sort on the flow for it. I am working with F::Q v1.61_02 and GNC v4.14 (4.14+(2023-03-25) build) running on Windows 11. (Note: I don't believe any interface change has taken place in GNC v5.x that would cause this but correct me here if I am wrong.). Invoking GNC with debug shows that return value is #f, which means something went wrong (run_executor is the "label" for my module and other modules work fine from the debug output): 11:19:24 DEBUG handling-request: (currency INR USD) * 11:19:24 DEBUG results: ((INR (symbol . INR) (gnc:time-no-zone . 2024-05-08 11:19:11) (last . 3/250) (currency . USD))) * 11:20:38 DEBUG ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY * 11:20:39 DEBUG handling-request: (tsp C S L2030 I) * 11:20:43 DEBUG results: ((C (symbol . C) (gnc:time-no-zone . 2024-05-07 12:00:00) (last . 812423/1) (currency . USD)) (S (symbol . S) (gnc:time-no-zone . 2024-05-07 12:00:00) (last . 4009/50) (currency . USD)) (L2030 (symbol . L2030) (gnc:time-no-zone . 2024-05-07 12:00:00) (last . 237163/5000) (currency . USD)) (I (symbol . I) (gnc:time-no-zone . 2024-05-07 12:00:00) (last . 42507/1000) (currency . USD))) * 11:20:43 DEBUG handling-request: (run_executor BK) * 11:20:43 DEBUG results: (#f) * 11:20:43 DEBUG handling-request: (yahoojson ^NYA) * 11:20:44 DEBUG results: ((^NYA (symbol . ^NYA) (gnc:time-no-zone . 2024-05-08 12:00:00) (last . 2247813/125) (currency . USD))) Following is debug run from command line of gnc-fq-dump (which provides all necessary fields for quote to be valid as it does not show '** This stock quote cannot be used by GnuCash!' message): C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v run_executor BK {snip} ### [Wed May 8 11:34:40 2024] %info : { ###'BKISIN' => '-', ###'BKcurrency' => 'USD', ###'BKdate' => '05/08/2024', ###'BKisodate' => '2024-05-08', ###'BKmethod' => 'run_executor', ###'BKprice' => '57.64500045776367', ###'BKsuccess' => '1', ###'BKsymbol' => 'BK', ###'BKtimezone' => 'EDT' ### } Finance::Quote fields Gnucash uses: symbol: BK <=== required date: 05/08/2024 <=== recommended currency: USD <=== required last: <=\ nav: <=== one of these price: 57.64500045776367<=/ timezone: EDT <=== optional All fields returned by Finance::Quote for stock BK stock field value - - - BK ISIN: - BK currency: USD BK date: 05/08/2024 BKisodate: 2024-05-08 BK method: run_executor BK price: 57.64500045776367 BKsuccess: 1 BK symbol: BK BK timezone: EDT C:\Users\kalpesh> When running same command via YahooJSON following is the output which works fine (I see that it does have more information returned back): C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v yahoojson BK {snip} Finance::Quote fields Gnucash uses: symbol: BK <=== required date: 05/08/2024 <=== recommended currency: USD <=== required last: 57.605 <=\ nav: <=== one of these price: <=/ timezone: <=== optional All fields returned by Finance::Quote for stock BK stock field value - - - BK close: 57.4 BK currency: USD BK date: 05/08/2024 BK div_yield: 2.8397212 BKeps: 3.99 BK exchange: NYSE BK high: 57.75 BKisodate: 2024-05-08 BK last: 57.605 BKlow: 57.12 BK method: yahoo_json BK name: BK (The Bank of New York Mellon Cor) BK open: 57.23 BK pe: 14.437344 BKsuccess: 1 BK symbol: BK BK type: EQUITY BK volume: 730814 BK year_range:39.65 - 58.28 C:\Users\kalpesh> Given that, why would GNC not accept the pricing? Does it have to be in a particular order what is returned back, or