Re: [GNC] cryptocurrency with many decimals
Hello John, when I try to create XLM inside the "Currencies" name space, I get a message of error: "You may not create a new national currency". So I must cancel the creation of the currency. In any case, If we manage to create XLM under currencies, I would solve the expense's account but I would continue with problems in my assets account. My assets account is a stock account to track gain/losses, So for example: Asset:XLM (stock account) Description; Quantity; Price; Buy; Sell; Balance New coins; 356.2904939; 0,052929 (only displayed 0,0529); 18,858099552 (only displayed 18,86); ; 356.2904939 Fee to transfer; -0,1; 0,052929 (to avoid gain/loses, only displayed 0,0529); ; 0,00529 (it is rounded to 0 !!); 356.2904839 So, I lost XLM but I didn't lost value (capital gains). So, El sáb., 14 sept. 2019 a las 5:01, John Ralls () escribió: > > Yes, you'll have to move XLM to the CURRENCY namespace. GnuCash *should* > allow that since the symbol starts with X. > > Regards, > John Ralls > > > > On Sep 13, 2019, at 1:57 PM, Christian Pinedo Zamalloa > > wrote: > > > > Yes, perhaps using XLM as the security/currency of Expenses:XLM is the > > best approach. I tried it. However I can't set XLM as currency of the > > Expenses:XLM account. I defined the XLM under "CCC" (cryptocurrency) > > namespace and it seems that in a Expense account I can only select a > > national currency under "Currencies" namespace. > > > > Do yo know, what I should have to do? to define XLM under "Currencies" > > namespace, or a configuration change..... > > > > Thanks! > > > > El vie., 13 sept. 2019 a las 20:02, John Ralls () > > escribió: > >> > >> > >> > >>> On Sep 13, 2019, at 10:40 AM, Christian Pinedo Zamalloa > >>> wrote: > >>> > >>> Hello, > >>> > >>> I am taking part in the airdrop of Stellar Lumens (XLM) in the keybase > >>> application so I received some free XLM cryptocoins that I would like > >>> to account with gnucash. > >>> > >>> The problem I have is the number of decimals. Cryptocurrency uses up > >>> to 7 decimals (11,1234567) and the price of the currency is often > >>> available with 6 decimals, for example, yesterday's XLM/EUR price was > >>> 0.052929 > >>> (https://www.investing.com/crypto/stellar/xlm-eur-historical-data?cid=1129224) > >>> > >>> I configured an stock account in gnucash to track XLM coins: I set the > >>> numbers I received with 7 decimals, I enter the price (this is round > >>> to 4 decimals) and finally I get the value rounded to only 2 decimals > >>> (this is the main problem). > >>> > >>> The problem I have is that I need to enter very low fees of 0,2 > >>> XML @ 0,052929 = 0,01059 € (from Asset:XML to Expense:XML). So > >>> these commissions are rounded to 0 € of value by gnucash and my > >>> balance fails because I reduce the number of XML coins for 0 euros. > >>> > >>> What could I do to face it? Thanks! > >> > >> You need to change the commodity in your Expense:XML account to XML. > >> Fractions of Euros (and any other real-world currency) smaller than 1/100 > >> simply don't exist. > >> > >> Regards, > >> John Ralls > >> > > > > > > -- > > Christian Pinedo Zamalloa (zako) > > PGP keyID: 0xdb577d4ee6ffbd55 > > PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 > -- Christian Pinedo Zamalloa (zako) PGP keyID: 0xdb577d4ee6ffbd55 PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 ___ 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.
Re: [GNC] cryptocurrency with many decimals
Yes, perhaps using XLM as the security/currency of Expenses:XLM is the best approach. I tried it. However I can't set XLM as currency of the Expenses:XLM account. I defined the XLM under "CCC" (cryptocurrency) namespace and it seems that in a Expense account I can only select a national currency under "Currencies" namespace. Do yo know, what I should have to do? to define XLM under "Currencies" namespace, or a configuration change. Thanks! El vie., 13 sept. 2019 a las 20:02, John Ralls () escribió: > > > > > On Sep 13, 2019, at 10:40 AM, Christian Pinedo Zamalloa > > wrote: > > > > Hello, > > > > I am taking part in the airdrop of Stellar Lumens (XLM) in the keybase > > application so I received some free XLM cryptocoins that I would like > > to account with gnucash. > > > > The problem I have is the number of decimals. Cryptocurrency uses up > > to 7 decimals (11,1234567) and the price of the currency is often > > available with 6 decimals, for example, yesterday's XLM/EUR price was > > 0.052929 > > (https://www.investing.com/crypto/stellar/xlm-eur-historical-data?cid=1129224) > > > > I configured an stock account in gnucash to track XLM coins: I set the > > numbers I received with 7 decimals, I enter the price (this is round > > to 4 decimals) and finally I get the value rounded to only 2 decimals > > (this is the main problem). > > > > The problem I have is that I need to enter very low fees of 0,2 > > XML @ 0,052929 = 0,01059 € (from Asset:XML to Expense:XML). So > > these commissions are rounded to 0 € of value by gnucash and my > > balance fails because I reduce the number of XML coins for 0 euros. > > > > What could I do to face it? Thanks! > > You need to change the commodity in your Expense:XML account to XML. > Fractions of Euros (and any other real-world currency) smaller than 1/100 > simply don't exist. > > Regards, > John Ralls > -- Christian Pinedo Zamalloa (zako) PGP keyID: 0xdb577d4ee6ffbd55 PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 ___ 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.
Re: [GNC] cryptocurrency with many decimals
If I understand well, i would have the same behaviour. If i use nXLM, I reduce the number of decimals of the quantity (which now it is not a problem, i can set 7 decimals for xml currency) but i increase the decimals of the price (perhaps a problem) and i get the same value in euros which is the actual problem. Am i wrong? -- Christian Pinedo Zamalloa (zako) Sent from my mobile device, please excuse brevity or typos El vie., 13 sept. 2019 19:48, Michael Hendry escribió: > > On 13 Sep 2019, at 18:40, Christian Pinedo Zamalloa < > chr.pin...@gmail.com> wrote: > > > > Hello, > > > > I am taking part in the airdrop of Stellar Lumens (XLM) in the keybase > > application so I received some free XLM cryptocoins that I would like > > to account with gnucash. > > > > The problem I have is the number of decimals. Cryptocurrency uses up > > to 7 decimals (11,1234567) and the price of the currency is often > > available with 6 decimals, for example, yesterday's XLM/EUR price was > > 0.052929 ( > https://www.investing.com/crypto/stellar/xlm-eur-historical-data?cid=1129224 > ) > > > > I configured an stock account in gnucash to track XLM coins: I set the > > numbers I received with 7 decimals, I enter the price (this is round > > to 4 decimals) and finally I get the value rounded to only 2 decimals > > (this is the main problem). > > > > The problem I have is that I need to enter very low fees of 0,2 > > XML @ 0,052929 = 0,01059 € (from Asset:XML to Expense:XML). So > > these commissions are rounded to 0 € of value by gnucash and my > > balance fails because I reduce the number of XML coins for 0 euros. > > > > What could I do to face it? Thanks! > > > If you were to record your transactions in nanoXLM (i.e. multiply the > GnuCash entries in XLM by 10^9), would that work? > > Michael ___ 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.
[GNC] cryptocurrency with many decimals
Hello, I am taking part in the airdrop of Stellar Lumens (XLM) in the keybase application so I received some free XLM cryptocoins that I would like to account with gnucash. The problem I have is the number of decimals. Cryptocurrency uses up to 7 decimals (11,1234567) and the price of the currency is often available with 6 decimals, for example, yesterday's XLM/EUR price was 0.052929 (https://www.investing.com/crypto/stellar/xlm-eur-historical-data?cid=1129224) I configured an stock account in gnucash to track XLM coins: I set the numbers I received with 7 decimals, I enter the price (this is round to 4 decimals) and finally I get the value rounded to only 2 decimals (this is the main problem). The problem I have is that I need to enter very low fees of 0,2 XML @ 0,052929 = 0,01059 € (from Asset:XML to Expense:XML). So these commissions are rounded to 0 € of value by gnucash and my balance fails because I reduce the number of XML coins for 0 euros. What could I do to face it? Thanks! -- Christian Pinedo Zamalloa (zako) PGP keyID: 0xdb577d4ee6ffbd55 PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 ___ 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.
[GNC] some oddities when exporting transactions to CSV
Hello, I would like to export trasactions of several accounts because I think it would be easier to perform an analysis of transactions with Libreoffice/Excel instead of developing a custom/new report. For example, I am considering to export transactions of a mutual fund account to check the capital gain/loss of every purchuase of participations according to the FIFO law. However, I found several oddities when I try to export the transactions with GnuCash 3.5: 1. "Type/Price" column of a transaction is provided as "210 + 10/39" and so when I open the CSV file with Libreoffice, it is considered a text field not a numberic field. 2. This is not so annoying as the previous point but it is a bit strange. When I export split transactions (not selecting "simple" export checkbox in the export transaction menu), the fields of the transaction are only filled for the first split and not filled for the rest of splits of the same transaction. This is a bit strange because in a spreedsheet it is better to repeat this transaction fields for every split (row) so that we can filter the splits of one transaction more easily. Regards! -- Christian Pinedo Zamalloa (zako) PGP keyID: 0xdb577d4ee6ffbd55 PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 ___ 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.
Re: [GNC] how to track Futures and Options
Thanks Alton for your detailed indications!! -- Christian El sáb., 15 dic. 2018 19:07, Alton Brantley escribió: > I carry options as a stock. Just multiply the contracts by 100 to show > shares under options. > Regarding commissions, I have a subaccount under the brokerage account > labeled “Open Commissions”. > When I execute an opening transaction, then the commission is debited to > “Open Commissions”. I think of this as a prepaid expense. > When I execute a closing transaction, the commission is debited to “Open > Commissions” also. And here’s the trick. > When I use the lots function to match the two parts of the transaction, I > get a realized gain that is then adjusted by > crediting the two “Open Commissions”. > (I actually do one additional step, which is to change the above “Open > Commissions” to “Closed Commissions-CYxx” where xx is the year of the > realized gain/loss. By doing this, I have an automatic check that I have > accounted for commissions correctly, as the balance of Closed Commissions > should always be 0.) > > So my accounts look like this: > Brokerage: AAPL 01/15/2021 230.00 C > > Transactions: > Opening (Sell Call to Open) > 09/19/2018 SCO AAPL 01/15/2021 230.00 C > -1200. > Brokerage:Cash > 38,379.55 > Brokerage:Open Commissions > 8.45 > Brokerage:AAPL 01/15/2021 230.00 C -1200. 31.99 > 38,388.00 > > Closing (Buy Call to Close) > 11/09/2018 BCC AAPL 01/15/2021 230.00 C > 0. > Brokerage:AAPL 01/15/2021 230.00 C 1200. 25.58 > 30,696.00 > Brokerage: Open Commissions > 12.90 > Brokerage:Cash >30,78.90 > > After matching up lots > 11/09/2018 Realized Gain AAPL 01/15/2021 230.00 C > Brokerage:AAPL 01/15/2021 230.00 C > 7,692.00 > Brokerage:ShtTermCapGain >7,670.65 > Brokerage:Open Commissions >8.45 > Brokerage:Open Commissions > 12.90 > > I then go back to each of the above transactions and change the > “Brokerage:Open Commissions” to “Brokerage:Closed Commissions-CY18” > This way, the “Open Commissions” account holds only unclosed transactions, > and all “Closed Commissions-CYxx” are 0. > > (For best results, copy this message into a text file and view with a > fixed size font so columns match up.) > > > > > > ___ 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.
[GNC] how to track Future and Options
Hi, I would like your experience to track Futures and Options with gnucash. - Any special account to use? It is not a mutual fund, stock... - Advice? In the case of Futures which I am more interested in we could have an "active" or "bank" account: - day 0: ingress of the guarantee, i.e., 1000 € - day 1: earnings or loss 1st day, i.e., -100 € - day 2: earnings or loss 2nd day, i.e., +123 € - ... - final day: earnings or loss last day, i.e., +50 € I am sure if the advanced portfolio report would include this account... Thanks, -- Christian ___ 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.
Re: [GNC] order of transactions for mutual funds
Yes David, I am sure my bank manager is going to provide me a detailed report, but it is fun to have all details under control :-D In fact, it is not so complicated, I only miss the possibility to move the order of transactions of one account manually. Perhaps one solution (that I think it is quite habitual) is to have an optional column "effective date" that could have a different date value if required. El mié., 14 nov. 2018 a las 21:57, David Carlson (< david.carlson@gmail.com>) escribió: > Wow! > > That would be very messy to track in GnuCash and even a challenge in a > simple spreadsheet. > > Do you have some other software designed to address this scenario? Can > the fund manager give you a detailed report ? > > David C > > On Wed, Nov 14, 2018, 1:28 PM Christian Pinedo Zamalloa < > chr.pin...@gmail.com wrote: > >> Hello, >> >> in our case, the capital/gain losses are delayed in fund transfers and >> only considered when the share is sold. I would try to put a clearer >> example: >> >> Fund A account >> 1, 2010-1-1, buy 10 shares @ 10 €, gross/net buy 100 € >> 2, 2015-1-1, transfer 10 shares @ 9 € to fund B, gross sell 90€ with 10€ >> capital losses, net sell 10 shares @ 10 € = 100€ to obtain 0€ capital >> gain/losess (capital/gain losses delayed because of a fund transfer) >> >> Fund B account >> 1, 2013-1-1, buy 10 shares @ 20 €, gross/net by 200 € >> 2, 2015-1-1, transfer 3 shares @ 30 € from fund A, gross buy 90€ with 10€ >> capital losses forwarded from fund A, net buy 100€ (3 shares @ 33,33 €) >> >> >> Using net values per share instead of gross values I can track capital >> gain/losses delayed because of transfers automatically with gnucash. >> >> Now If a want to sell Fund B shares: >> >> Fund B account >> .. >> 3, 2018-11-14, sell 3 shares @ 25 € with 3 x 8,33 € capital losses >> >> In this case, according to FIFO laws of my country I am selling the >> transfered shares (2. transaction of Fund B). Becuase to order in time the >> sells of shares I have to take into account where I bought initially shares >> (2010-1-1) not when I transfer shares between funds (2015-1-1). So, this is >> why it should be great to we able to order transactions of Fund B account >> in the following way: >> >> Fund B account >> 2, 2015-1-1, transfer 3 shares @ 30 € from fund A, gross buy 90€ with 10€ >> capital losses forwarded from fund A, net buy 100€ (3 shares @ 33,33 €) >> 1, 2013-1-1, buy 10 shares @ 20 €, gross/net by 200 € >> 3, 2018-11-14, sell 3 shares @ 25 € with 3 x 8,33 € capital losses >> >> I hope it is now easier to understand my initial question. >> >> Thanks! >> >> >> >> El mié., 14 nov. 2018 a las 19:40, David Carlson (< >> david.carlson@gmail.com>) escribió: >> >>> If funds were used to buy a different security first then that security >>> was >>> sold for a withdrawal and intermediate gains matter unlike in U.S. >>> custodial accounts, it could get very messy. >>> >>> David C >>> >>> On Wed, Nov 14, 2018 at 9:43 AM D wrote: >>> >>> > If OP is looking to track gains using FIFO, wouldn't the lots >>> > functionality work for them? I believe that it uses FIFO exclusively... >>> > >>> > David T. >>> > >>> > On November 14, 2018, at 8:23 PM, David Carlson < >>> > david.carlson@gmail.com> wrote: >>> > >>> > I think that Christian is asking a slightly different question. I >>> > interpret it that in one parent custodial mutual fund account he >>> purchased >>> > Fund A on dates 1, 2 and later then sold some or all of Fund A and >>> bought >>> > Fund B in the same custodial account on date 3. >>> > >>> > Now I am not sure if he needs to account for capital gain at that >>> point or >>> > later on date 4 when he actually withdraws the funds from the parent >>> > custodial account. >>> > >>> > David C >>> > >>> > On Wed, Nov 14, 2018 at 8:05 AM Derek Atkins wrote: >>> > >>> > > Hi, >>> > > >>> > > On Wed, November 14, 2018 8:42 am, Christian Pinedo Zamalloa wrote: >>> > > > Hello, >>> > > > >>> > > > I would like to know if it is possible to order manually the >>> > transactions >>> > > > of a mutual fund account. >&g
Re: [GNC] order of transactions for mutual funds
Hello, in our case, the capital/gain losses are delayed in fund transfers and only considered when the share is sold. I would try to put a clearer example: Fund A account 1, 2010-1-1, buy 10 shares @ 10 €, gross/net buy 100 € 2, 2015-1-1, transfer 10 shares @ 9 € to fund B, gross sell 90€ with 10€ capital losses, net sell 10 shares @ 10 € = 100€ to obtain 0€ capital gain/losess (capital/gain losses delayed because of a fund transfer) Fund B account 1, 2013-1-1, buy 10 shares @ 20 €, gross/net by 200 € 2, 2015-1-1, transfer 3 shares @ 30 € from fund A, gross buy 90€ with 10€ capital losses forwarded from fund A, net buy 100€ (3 shares @ 33,33 €) Using net values per share instead of gross values I can track capital gain/losses delayed because of transfers automatically with gnucash. Now If a want to sell Fund B shares: Fund B account .. 3, 2018-11-14, sell 3 shares @ 25 € with 3 x 8,33 € capital losses In this case, according to FIFO laws of my country I am selling the transfered shares (2. transaction of Fund B). Becuase to order in time the sells of shares I have to take into account where I bought initially shares (2010-1-1) not when I transfer shares between funds (2015-1-1). So, this is why it should be great to we able to order transactions of Fund B account in the following way: Fund B account 2, 2015-1-1, transfer 3 shares @ 30 € from fund A, gross buy 90€ with 10€ capital losses forwarded from fund A, net buy 100€ (3 shares @ 33,33 €) 1, 2013-1-1, buy 10 shares @ 20 €, gross/net by 200 € 3, 2018-11-14, sell 3 shares @ 25 € with 3 x 8,33 € capital losses I hope it is now easier to understand my initial question. Thanks! El mié., 14 nov. 2018 a las 19:40, David Carlson (< david.carlson@gmail.com>) escribió: > If funds were used to buy a different security first then that security was > sold for a withdrawal and intermediate gains matter unlike in U.S. > custodial accounts, it could get very messy. > > David C > > On Wed, Nov 14, 2018 at 9:43 AM D wrote: > > > If OP is looking to track gains using FIFO, wouldn't the lots > > functionality work for them? I believe that it uses FIFO exclusively... > > > > David T. > > > > On November 14, 2018, at 8:23 PM, David Carlson < > > david.carlson@gmail.com> wrote: > > > > I think that Christian is asking a slightly different question. I > > interpret it that in one parent custodial mutual fund account he > purchased > > Fund A on dates 1, 2 and later then sold some or all of Fund A and bought > > Fund B in the same custodial account on date 3. > > > > Now I am not sure if he needs to account for capital gain at that point > or > > later on date 4 when he actually withdraws the funds from the parent > > custodial account. > > > > David C > > > > On Wed, Nov 14, 2018 at 8:05 AM Derek Atkins wrote: > > > > > Hi, > > > > > > On Wed, November 14, 2018 8:42 am, Christian Pinedo Zamalloa wrote: > > > > Hello, > > > > > > > > I would like to know if it is possible to order manually the > > transactions > > > > of a mutual fund account. > > > > > > > > When I transfer suscriptions from one mutual fund to another one, the > > > > order > > > > of the transfer transaction depends on the date when the transfer was > > > > done. > > > > > > > > However, it would be quite useful to reorder this transfer > transaction > > > > because according to FIFO laws for mutual funds in my country, > > transfers > > > > of > > > > mutual funds mut be ordered according to the initial purchase not to > > the > > > > date of the transfer between funds. So: > > > > > > > > - Suscription of Fund A, date: 1, effective_date: 1 > > > > - More Subscriptions, date: 2, effective_date: 2 > > > > - Transfer of Fund A to Fund B, date: 3, effective_date: 1 > > > > > > GnuCash does have multiple dates, which include the post-date, > > entry-date, > > > reconcile-date.. but only one visible date: the post-date. > > > > > > You have two options: > > > > > > 1) You could set the post-date to date 3 and put date 1 in the transfer > > > description, or > > > 2) You can set the post-date to date 1 (and put date 3 in the > > description). > > > > > > I can think of no other way to do what you want. > > > > > > Personally, (noting that IANAA), I would go with option 1. > > > > > > > Thanks! > > > > > > > > -- > > > > Christian Pinedo >
Re: [GNC] order of transactions for mutual funds
As you suggest, I am following the method 1 because I didn't know another solution. I didn't realise of the second approach but I consider the first option is more easy to implement. When I sell shares, I must select manually transactions to track capital gain/losses because the order of the transactions is not the FIFO order I must follow. Thanks! El mié., 14 nov. 2018 a las 15:02, Derek Atkins () escribió: > Hi, > > On Wed, November 14, 2018 8:42 am, Christian Pinedo Zamalloa wrote: > > Hello, > > > > I would like to know if it is possible to order manually the transactions > > of a mutual fund account. > > > > When I transfer suscriptions from one mutual fund to another one, the > > order > > of the transfer transaction depends on the date when the transfer was > > done. > > > > However, it would be quite useful to reorder this transfer transaction > > because according to FIFO laws for mutual funds in my country, transfers > > of > > mutual funds mut be ordered according to the initial purchase not to the > > date of the transfer between funds. So: > > > > - Suscription of Fund A, date: 1, effective_date: 1 > > - More Subscriptions, date: 2, effective_date: 2 > > - Transfer of Fund A to Fund B, date: 3, effective_date: 1 > > GnuCash does have multiple dates, which include the post-date, entry-date, > reconcile-date.. but only one visible date: the post-date. > > You have two options: > > 1) You could set the post-date to date 3 and put date 1 in the transfer > description, or > 2) You can set the post-date to date 1 (and put date 3 in the description). > > I can think of no other way to do what you want. > > Personally, (noting that IANAA), I would go with option 1. > > > Thanks! > > > > -- > > Christian Pinedo > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > > -- Christian Pinedo Zamalloa (zako) PGP keyID: 0xdb577d4ee6ffbd55 PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 ___ 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.
[GNC] order of transactions for mutual funds
Hello, I would like to know if it is possible to order manually the transactions of a mutual fund account. When I transfer suscriptions from one mutual fund to another one, the order of the transfer transaction depends on the date when the transfer was done. However, it would be quite useful to reorder this transfer transaction because according to FIFO laws for mutual funds in my country, transfers of mutual funds mut be ordered according to the initial purchase not to the date of the transfer between funds. So: - Suscription of Fund A, date: 1, effective_date: 1 - More Subscriptions, date: 2, effective_date: 2 - Transfer of Fund A to Fund B, date: 3, effective_date: 1 Thanks! -- Christian Pinedo ___ 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.
Re: [GNC] problem setting the price of a share
If instead of a mailing list it was a social network, I just would like your reply! Thanks again for your input and references, -- Christian Pinedo Zamalloa (zako) Sent from my mobile device, please excuse brevity or typos El mié., 19 sept. 2018 1:22, David Carlson escribió: > There have been several discussions over the years around various aspects > of the topics of numeric accuracy, displaying accurate values vs easily > readable values, whether GnuCash records do or do not match brokers' > reports or newspaper stock price listings, and even whether the GnuCash > price database is properly configured and whether data is correctly > extracted from it for various reports. If you want to research the topic > further there are several threads in this user maillist going back a decade > or more. > > I just searched the bug database and found several open bug reports which > directly involve these points. > *Bug 787813* <https://bugs.gnucash.org/show_bug.cgi?id=787813> > *Bug 793556* <https://bugs.gnucash.org/show_bug.cgi?id=793556> > *Bug 638175* <https://bugs.gnucash.org/show_bug.cgi?id=638175> > *Bug 410060* <https://bugs.gnucash.org/show_bug.cgi?id=410060> > > GnuCash was changed in release 2.6.8, dated late 2015 to usually store > prices in decimal format when they were entered in decimal format, but > there was a regression in the 2.7.x development series leading up to the > 3.x releases reverting to the fractional display currently seen. Bug > 793556 has already been filed regarding the fractional format as related to > CSV imports and exports, but it does not extend to use of those values in > spreadsheets. The fractional format is the raw display of the number > format used internally for certain calculations requiring high accuracy, > and a few users actually prefer to see prices displayed in that format, so > it is not likely to be completely hidden. > > John Ralls points out in his reply that release 3.3 will fix your first > concern as well as it can in this real world. > > David C > > On Tue, Sep 18, 2018 at 4:22 PM Christian Pinedo Zamalloa < > chr.pin...@gmail.com> wrote: > >> Hi David, >> >> At the end I was able to get properly the price by skipping it and >> letting to GnuCash to calculate it as you suggested. However, I think that >> this might be a kind of bug, because if I insert the price in decimal >> format, it shouldn't be modified and the total amount should be calculated >> accordingly. >> >> Regarding the fractional format of prices, one more issue. Apart from >> being more difficult to read, when transactions are exported to CSV, the >> fractional format is maintained (i.e. "123 + 3/45") and if the CSV is >> opened with calc/excel we need to modify all the prices to be considered >> numbers not strings (i.e. insert "=123 + 3/45"). >> >> Thanks for your suggestions!! >> >> >> >> El sáb., 15 sept. 2018 a las 16:26, David Carlson (< >> david.carlson@gmail.com>) escribió: >> >>> As I stated in my reply, enter the number of shares and total amount, >>> Skip the price, let GnuCash take care of that. >>> >>> David C >>> >>> On Sat, Sep 15, 2018 at 9:21 AM Christian Pinedo Zamalloa < >>> chr.pin...@gmail.com> wrote: >>> >>>> Hi David, >>>> >>>> I also agree with you that the fractional format is more difficult to >>>> read than decimal and I also hope to return to decimal format or at least >>>> to be able to choose between decimal or fractional format. >>>> >>>> Regarding my problem with price, I insert the number of shares, the >>>> prices (in decimal format) and press enter. The decimal formal is converted >>>> to fractional format, but fractional number is not the same that I inserted >>>> before. :-( >>>> >>>> Any idea? >>>> >>>> -- >>>> Christian Pinedo Zamalloa (zako) >>>> Sent from my mobile device, please excuse brevity or typos >>>> >>>> El sáb., 15 sept. 2018 14:49, David Carlson < >>>> david.carlson@gmail.com> escribió: >>>> >>>>> Christian Pinedo Zamalloa >>>>> >>>>> You have discovered that it is impossible to have all three values >>>>> shares, price and total exactly as reported by your broker because he >>>>> usually has to round off one of the numbers. The solution is to let >>>>> GnuCash set the price after you enter the number of shares and the total >
Re: [GNC] problem setting the price of a share
Hi David, At the end I was able to get properly the price by skipping it and letting to GnuCash to calculate it as you suggested. However, I think that this might be a kind of bug, because if I insert the price in decimal format, it shouldn't be modified and the total amount should be calculated accordingly. Regarding the fractional format of prices, one more issue. Apart from being more difficult to read, when transactions are exported to CSV, the fractional format is maintained (i.e. "123 + 3/45") and if the CSV is opened with calc/excel we need to modify all the prices to be considered numbers not strings (i.e. insert "=123 + 3/45"). Thanks for your suggestions!! El sáb., 15 sept. 2018 a las 16:26, David Carlson (< david.carlson@gmail.com>) escribió: > As I stated in my reply, enter the number of shares and total amount, > Skip the price, let GnuCash take care of that. > > David C > > On Sat, Sep 15, 2018 at 9:21 AM Christian Pinedo Zamalloa < > chr.pin...@gmail.com> wrote: > >> Hi David, >> >> I also agree with you that the fractional format is more difficult to >> read than decimal and I also hope to return to decimal format or at least >> to be able to choose between decimal or fractional format. >> >> Regarding my problem with price, I insert the number of shares, the >> prices (in decimal format) and press enter. The decimal formal is converted >> to fractional format, but fractional number is not the same that I inserted >> before. :-( >> >> Any idea? >> >> -- >> Christian Pinedo Zamalloa (zako) >> Sent from my mobile device, please excuse brevity or typos >> >> El sáb., 15 sept. 2018 14:49, David Carlson >> escribió: >> >>> Christian Pinedo Zamalloa >>> >>> You have discovered that it is impossible to have all three values >>> shares, price and total exactly as reported by your broker because he >>> usually has to round off one of the numbers. The solution is to let >>> GnuCash set the price after you enter the number of shares and the total >>> amount. Actually, GnuCash is closer to being correct than your broker is. >>> >>> You have also discovered that in release 3.3 GnuCash shows the number of >>> shares in fractional format, which has the technical advantage of being >>> very accurate, if very hard to read. I believe that in the future GnuCash >>> may be changed back to show the number of shares in decimal format to be >>> easier to read, if less accurate. >>> >>> David C >>> >>> >>> >>> On Sat, Sep 15, 2018 at 4:16 AM Christian Pinedo Zamalloa < >>> chr.pin...@gmail.com> wrote: >>> >>>> Hello, >>>> >>>> I have problems to set the correct price of a share that I am selling. >>>> >>>> I try to put the value "128,181208053691" which is automatically >>>> converted >>>> by GnuCash when i push enter key to "128 + 64/377" whose real value is >>>> "128,169761". Furthermore, I checked if I insert value "1", it is >>>> automatically converted by GnuCash to value "1+3/377" (1,007958). >>>> >>>> I don't know how to solve this mesh. Am I doing something wrong? >>>> >>>> -- >>>> zako >>>> ___ >>>> 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. >>>> >>> -- Christian Pinedo Zamalloa (zako) PGP keyID: 0xdb577d4ee6ffbd55 PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 ___ 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.
Re: [GNC] problem setting the price of a share
Hi David, I also agree with you that the fractional format is more difficult to read than decimal and I also hope to return to decimal format or at least to be able to choose between decimal or fractional format. Regarding my problem with price, I insert the number of shares, the prices (in decimal format) and press enter. The decimal formal is converted to fractional format, but fractional number is not the same that I inserted before. :-( Any idea? -- Christian Pinedo Zamalloa (zako) Sent from my mobile device, please excuse brevity or typos El sáb., 15 sept. 2018 14:49, David Carlson escribió: > Christian Pinedo Zamalloa > > You have discovered that it is impossible to have all three values shares, > price and total exactly as reported by your broker because he usually has > to round off one of the numbers. The solution is to let GnuCash set the > price after you enter the number of shares and the total amount. Actually, > GnuCash is closer to being correct than your broker is. > > You have also discovered that in release 3.3 GnuCash shows the number of > shares in fractional format, which has the technical advantage of being > very accurate, if very hard to read. I believe that in the future GnuCash > may be changed back to show the number of shares in decimal format to be > easier to read, if less accurate. > > David C > > > > On Sat, Sep 15, 2018 at 4:16 AM Christian Pinedo Zamalloa < > chr.pin...@gmail.com> wrote: > >> Hello, >> >> I have problems to set the correct price of a share that I am selling. >> >> I try to put the value "128,181208053691" which is automatically converted >> by GnuCash when i push enter key to "128 + 64/377" whose real value is >> "128,169761". Furthermore, I checked if I insert value "1", it is >> automatically converted by GnuCash to value "1+3/377" (1,007958). >> >> I don't know how to solve this mesh. Am I doing something wrong? >> >> -- >> zako >> ___ >> 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.
[GNC] problem setting the price of a share
Hello, I have problems to set the correct price of a share that I am selling. I try to put the value "128,181208053691" which is automatically converted by GnuCash when i push enter key to "128 + 64/377" whose real value is "128,169761". Furthermore, I checked if I insert value "1", it is automatically converted by GnuCash to value "1+3/377" (1,007958). I don't know how to solve this mesh. Am I doing something wrong? -- zako ___ 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.
