Hi Ben, Isn't Libre Office able to highlight a column and change the date format from dd/mmm/ccyy to dd/mm/ccyy for instance ??
Cheers David H. On Wed, 8 Apr 2020 at 00:54, Ben Stanley <ben.stan...@gmail.com> wrote: > Hello Gnucash Users, > > I have now downloaded the foreign exchange rates from the Reserve Bank > of Australia: > https://rba.gov.au/statistics/historical-data.html#exchange-rates > > Note that the exchange rate data is published in an Excel .xls file. I > used LibreOffice to save it as a .csv for import into GnuCash. > > In this file, the dates are formatted as DD-Mon-YYYY. For example: > 18-May-2019 > > GnuCash cannot understand dates formatted this way. (I tested against > git 3.9-19 on branch maint.) > > I made some modifications to gnucash/libgnucash/engine/gnc-datetime.cpp > that allow GnuCash to import the RBA data with word date months. The > changes are very rough, and do not include any internationalisation. I > would appreciate constructive feedback. Flames -> /dev/null. > > I note here that I have not tested this patch with dates of format > DD-MM-YYYY. > > Perhaps I should sign up to the gnucash-devel mailing list... > > Ben. > > On 7/4/20 7:28 pm, Christopher Lam wrote: > > Yes, you can do that. File import prices from CSV. > > > > On Tue, 7 Apr 2020, 5:22 pm Ben Stanley, <ben.stan...@gmail.com > > <mailto: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 <mailto: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 > >> <mailto: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 <mailto: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. > _______________________________________________ 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.
