Re: [GNC] Importing stock prices from a CSV file

2023-09-30 Thread Ove Grunnér
Hi, if it helps, this is what an import file can look like when importing stock prices. the name space for stocks is the same name space you see in the security editor Menu -> Tools:Security Editor. So if you call the namespace for a stock e.g. NASDAQ when you create the stock, then that will be

[GNC] Best way to import from Interactive Brokers

2023-03-28 Thread Ove Grunnér
Hello all, I have just started using "Interactive Brokers" to trade with, and I am trying to figure out the best way to import transactions to GnuCash, Buy/Sell Shares and deposits/withdrawals, and also net worth at point in time to check/compare net worth reported by GnuCash. I looked at the exp

[GNC] Annualized Rate of Return in Advanced Portfolio

2022-02-07 Thread Ove Grunnér
Hello all, I have been trying to find a report that can show the annualized return on Capital. The Advanced Portfolio Report is good, but it shows the "Rate of Return" as "Total Return" divided by "Money In" Similar to "Rate of Gain" = "Total Gain" divided by "Money In" but what I am looking to s

Re: [GNC] CSV Import Reconciled field

2021-11-17 Thread Ove Grunnér
I was considering raising a bug but I found that as David suspected it already existed. bug 796890 <https://bugs.gnucash.org/show_bug.cgi?id=796890> Kind regards Ove. On Wed, 17 Nov 2021 at 14:23, Ove Grunnér wrote: > Hi David, I did some more testing on Flatpack > Version: 4.

Re: [GNC] CSV Import Reconciled field

2021-11-17 Thread Ove Grunnér
e Rate_Price 2021-11-12 A26155857301 text more text CURRENCY::SEK Link Memo Text Stock Alpha Account 0 n 1 Payment Memo Text Investment Account -780 n 1 Dividend Memo Text Dividend for Alpha Stock 780 n 1 kind regards Ove. On Wed, 17 Nov 2021 at 12:51, Ove Grunnér wrote: >

Re: [GNC] CSV Import Reconciled field

2021-11-17 Thread Ove Grunnér
609.680.2326 Mobile >> >> gmccol...@live.comemail >> -- >> *From:* gnucash-user >> on behalf of David Carlson >> *Sent:* Tuesday, November 16, 2021 10:00 AM >> *To:* Ove Grunnér >> *Cc:* gnucash-u

Re: [GNC] CSV Import Reconciled field

2021-11-16 Thread Ove Grunnér
are not following > technically correct accounting procedures, and your procedure works for you > (at least it did earlier), but you may run into problems if you try to > balance bank account payments against credit card bills later. Thus, I > suggest trying to modify your procedure

[GNC] CSV Import Reconciled field

2021-11-16 Thread Ove Grunnér
Hello, all I am in the process of changing from QIF import to CSV import of data and have encountered a difference in the functionality that I am trying to understand better in order to make it compatible with my own process, or change my own process to suit the functionality. My Account Struct

Re: [GNC] Reconcile Opening Balance

2021-05-03 Thread Ove Grunnér
Here is how I deal with this. When I Download a statement from a bank I convert it to a standard format to make importing to gnucash easier, as all banks have different formats. When I do this conversion I also add a new transaction for each day when the statement has an end of day balance. Descr

Re: [GNC] Printing

2020-12-30 Thread Ove Grunnér
You can also export/print to pdf and then print the pdf document to your printer. On Tue, 29 Dec 2020, 22:45 David Cousens, wrote: > Gerald, > > Printing is normally handled by the OS and not by GnuCash itself. > > What OS are you using and what is the GnuCash version? > What are you trying to p

Re: [GNC] GnuCash 4.1 on Ubuntu 20.04 LTS

2020-11-28 Thread Ove Grunnér
I would try to uninstall and reinstall gnucash. That should fix any dependencies On Sat, 28 Nov 2020, 19:13 Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > I recall having this problem when trying to build on 20.04. I never > solved it and gave up. (I use Mac as my daily driver) >

Re: [GNC] Is there an 'easy' way to have a transaction with 'sub-transactions' as it were?

2020-09-13 Thread Ove Grunnér
Yes, if I understand you correctly, use a split transaction, one debit from the bank account and two expense transaction in one split transaction. You can also import split transactions from e.g. csv, you may need to manipulate the data to be in the right format but very posible and saves a lot of

Re: [GNC] Import transactions with expenses in a different currency

2020-09-09 Thread Ove Grunnér
I had similar problems and I solved it by turning on "trading accounts" . This way there are no exchange rates involved in individual transactions, but instead each transaction is balanced to a currency trading account. To correct any existing transactions I then had to click on it and accept gnuca

Re: [GNC] Stock Split assistant

2020-08-23 Thread Ove Grunnér
I wonder if that is related to "Fractions Traded" on the particular Share. if you open "Security Editor" and check, do you have "1/100" as "Fractions Traded"? On Sat, 22 Aug 2020 at 16:09, Keith Bellairs wrote: > I have found that the "Shares" field in the Stock Split Details window > parses the

Re: [GNC] Tracking cash flows with balanced transactions

2020-08-22 Thread Ove Grunnér
p screenshots and a sample CSV file. > > First time around you will need to specify the account mappings, but > gnucash remembers them: Tools / Import Map Editor / Non-Bayesian / CSV > Account Map. > > Don't forget to save your import settings after you map the import > c

Re: [GNC] Tracking cash flows with balanced transactions

2020-08-21 Thread Ove Grunnér
I would like to be able to do this as well, however I create QIF files from my investment account and then import it. I convert exports from DEGIRO programmatically into QIF to avoid having to enter transactions manually. The problem being that when I import the transaction as an investment, then G

Re: [GNC] multi-currency imports

2020-08-10 Thread Ove Grunnér
Hello, I use QIF to import all my imports, including stocks and multi currency and it just works, not sure why. I use the latest GnuCash version that comes with CentOS. I use trading accounts and when I have a currency exchange I only populate the two entries and the two trading account transactio

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

2020-04-14 Thread Ove Grunnér
te: > >> Ove, >> >> I believe !Clear:AutoSwitch is only used in QIF imports. My OFX imports >> have tags similar to >> >> and . >> >> >> >> >> On Tue, Apr 14, 2020 at 12:12 PM Ove Grunnér wrote: >> >>> it works for

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

2020-04-14 Thread Ove Grunnér
it works for me as well, but I know I need to put a specific line in the beginning of the file to let gnuCash know it is multi account open up your file and check if the firs line is: !Clear:AutoSwitch Try to add the line if it is missing. I use the below java code to write my import f

Re: [GNC] Get online quote for Canada Fund

2019-08-13 Thread Ove Grunnér
gt; > > On Sun, Aug 11, 2019 at 1:46 PM Kaman Wu wrote: > >> thanks a lot. I will try it. >> >> On Sun, Aug 11, 2019 at 1:40 PM Ove Grunnér wrote: >> >>> I was looking at the code in cpan, and it looks like the module is using >>> this base url >&g

Re: [GNC] Get online quote for Canada Fund

2019-08-11 Thread Ove Grunnér
imezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > > All fields returned by Finance::Quote for stock 1743 > > stock field value > - - - > 1743 errormsg: Error determining fund code for 1743. &

Re: [GNC] Get online quote for Canada Fund

2019-08-11 Thread Ove Grunnér
Hi Kaman, according to https://metacpan.org/pod/Finance::Quote::Cdnfundlibrary "This module uses an id that represents the mutual fund on an id used by www.fundlibrary.com. There is no easy way of fetching the id except to jump onto the fundlibrary website, look up the fund and view the url for cl

Re: [GNC] Account Hirarchy with different currencies cause online quotes to fail in some cases

2019-08-09 Thread Ove Grunnér
Thanks, I will do that. :-) Ove On Fri 9 Aug 2019 22:28 Frank H. Ellenberger wrote: > Hi Ove, > > Am Fr., 9. Aug. 2019 um 19:50 Uhr schrieb Ove Grunnér >: > : > > My problem seem to be that I am not able to automatically fetch all 3 > exchange rates (EUR/USD, EUR/SEK,

Re: [GNC] Account Hirarchy with different currencies cause online quotes to fail in some cases

2019-08-09 Thread Ove Grunnér
The only way to see it once you've finished > the assistant is to look in the file. The Default Currency preference is > used mostly for creating new accounts. > > Regards, > John Ralls > > > On Aug 9, 2019, at 10:49 AM, Ove Grunnér wrote: > > > > Hi Fr

Re: [GNC] Account Hirarchy with different currencies cause online quotes to fail in some cases

2019-08-09 Thread Ove Grunnér
e. On Wed, 7 Aug 2019 at 19:39, Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Am Mi., 7. Aug. 2019 um 19:34 Uhr schrieb Ove Grunnér >: > > > > No Problem, John, thanks for helping, > > > > Anyone else got this working somehow? > > &g

Re: [GNC] Account Hirarchy with different currencies cause online quotes to fail in some cases

2019-08-07 Thread Ove Grunnér
No Problem, John, thanks for helping, Anyone else got this working somehow? br Ove. On Tue, 6 Aug 2019 at 21:55, John Ralls wrote: > > > > On Aug 6, 2019, at 11:06 AM, Ove wrote: > > > > Thanks very much for that John. > > > > I did as you suggested, and it fixed the original problem but ex