Yes, you can do that. File import prices from CSV. On Tue, 7 Apr 2020, 5:22 pm Ben Stanley, <ben.stan...@gmail.com> wrote:
> I can get a CSV file of daily exchange rate data. Is there a way of > importing it into the price database? > > On 7 April 2020 7:17:54 pm Christopher Lam <christopher....@gmail.com> > wrote: > >> The only report which is capable of using closest-to-date conversion is >> the Transaction Report from the Income:Dividends(USD) and >> Income:CapGains(USD) accounts, using a Report Currency of AUD. It will >> choose the USD/AUD price from the price editor list closest to each >> transaction's posting date. >> >> You'll have to ensure the price list has prices at your desired dates >> manually. >> >> On Tue, 7 Apr 2020 at 09:13, Ben Stanley <ben.stan...@gmail.com> wrote: >> >>> Hello Gnucash people, >>> >>> This question may be more suited to Gnucash developers, but lets try it >>> here first. >>> >>> I need to perform a tax calculation in accordance with instructions from >>> the Australian Taxation Office. All foreign income, deductions and >>> foreign tax paid must be converted to Australian Dollars for tax >>> purposes. >>> >>> >>> https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/ >>> >>> The conversion used must correspond to the transaction date. >>> >>> In Gnucash, it would appear that the price editor could be used to enter >>> the necessary conversion data, if it were easy to see all of the dates >>> where conversions are required. However, this is tedious. >>> >>> Far better would be to use Finance::Quote to fetch the necessary >>> conversion data for the dates it is required for. However, it seems that >>> Finance::Quote is only capable of fetching "recent" data. (The >>> documentation that I looked at seemed to be very old.) >>> >>> http://finance-quote.sourceforge.net/documentation.html >>> >>> What is needed is the ability to pass a date, or a range of dates, and >>> request Finance::Quote to fetch prices for that date or date interval. >>> This would make Finance::Quote far more useful than just fetching the >>> most recent price data. >>> >>> Is there some feature in Gnucash that I have missed that would allow me >>> to generate a report, with dividends and Capital Gains converted from >>> USD -> AUD using the currency conversion as at the transaction dates? >>> >>> Thanks, >>> Ben Stanley. >>> >>> >>> _______________________________________________ >>> 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. >>> >> > _______________________________________________ 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.