[GNC] Error in Finance:Quote

Shokster ashok.sinha at gmail.com
Sat Aug 11 16:30:19 EDT 2018


Thanks Deva, that is a good idea. I'll give it a try. 
 

 

Deva - wrote
> Shokster,
> 
> I have been unable to get F:Q to work with Indian stocks and mutual funds
> either, but that limitation is now overcome with GC 3.* series introducing
> the ability to upload prices from a CSV file. I have been using this
> feature in 3.2 and it works well. In fact, if your CSV format is
> finalised, then you can even save your import settings, so next time, you
> will have less options to tweak.
> 
> All that the CSV price importer needs is as follows -
> 
> Date,Price/NAV,Commodity,Currency
> 
> Commodity is the mutual fund code or whatever is the security code you
> setup in the security editor. Currency, in our case, is INR.
> 
> Only observation is that all uploaded prices have the “type” set to
> “last”. Mutual funds don’t have “last”, so I go in and update them to
> “NAV” instead. If you are not too finicky, you can leave them as is - it’s
> only for informational purposes.
> 
> Cheers.
> 
> On 11-Aug-2018, at 8:18 PM, <

> gnucash-user-request@

> <mailto:

> gnucash-user-request@

> >> <

> gnucash-user-request@

> <mailto:

> gnucash-user-request@

> >> wrote:
> 
> Message: 3
> Date: Fri, 10 Aug 2018 11:16:43 -0500 (CDT)
> From: Shokster <

> ashok.sinha@

> <mailto:

> ashok.sinha@

> >>
> To: 

> gnucash-user@

> <mailto:

> gnucash-user@

> >
> Subject: Re: [GNC] Error in Finance:Quote
> Message-ID: <

> 1533917803525-0.post at .nabble

> <mailto:

> 1533917803525-0.post at .nabble

> >>
> Content-Type: text/plain; charset=us-ascii
> 
> Hi all, sorry if this is not the right place (if so, please advise) for
> this
> post.
> 
> I'm having a hard time trying to get GnuCash to 'Get Quotes'. It throws an
> error saying 'Unable to retrieve quotes for these items: Currency:INR
> Continue using only the good quotes? Yes/No'.
> 
> I've got just the 1 security for now. It's a mutual fund code 101143 at
> https://www.amfiindia.com/spages/NAVAll.txt
> 
> Seems like it's setup ok on Security editor.
> <http://gnucash.1415818.n4.nabble.com/file/t308877/security_editor.jpg>
> 
> So, I've had a crash course into running perl modules, and ran (from a
> run.bat file):
> 
> perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-dump" indiamutual 125112
> pause
> 
> This works as:
> <http://gnucash.1415818.n4.nabble.com/file/t308877/console.jpg>
> 
> But I can't figure out why the 'Get Quote' via GnuCash won't work! :(
> 
> From reading around, there seems to be a major shift (to Alpha Vantage)
> that
> shouldn't be relevant to this case?
> 
> Currently, I work with Excel, and will port my accounts to GnuCash if the
> price editor can import mutual fund NAV's.
> 
> 
> 
> _______________________________________________
> gnucash-user mailing list

> gnucash-user@

> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


More information about the gnucash-user mailing list