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-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org>> <gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org>> wrote: Message: 3 Date: Fri, 10 Aug 2018 11:16:43 -0500 (CDT) From: Shokster <ashok.si...@gmail.com<mailto:ashok.si...@gmail.com>> To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] Error in Finance:Quote Message-ID: <1533917803525-0.p...@n4.nabble.com<mailto:1533917803525-0.p...@n4.nabble.com>> 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@gnucash.org 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.
