Re: Currency Designator/Reporting Issues
> "J" == Jasel17212 writes: J> As mentioned in my original post, running the report with -X USD produces J> the expected output. It sounds like I've stumbled upon a bug related to the J> -V option. Yes, could very well be. Really the -V should be removed, I think, but it's been relatively harmless until now. J> BTW, I've been meaning to ask, are you still personally using PTA? If so, J> are you still using Ledger, or are you using Hledger? I use Ledger every week, lately to track crypto transactions. I also use it for time reporting when applicable, and for tracking investments, progress on loans, and a "yearly income report" where I basically enter in the data from my tax return every year. John -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/m2h7cme92k.fsf%40newartisans.com.
Re: Currency Designator/Reporting Issues
John, As mentioned in my original post, running the report with -X USD produces the expected output. It sounds like I've stumbled upon a bug related to the -V option. BTW, I've been meaning to ask, are you still personally using PTA? If so, are you still using Ledger, or are you using Hledger? Thanks! JL On Monday, November 8, 2021 at 1:02:54 AM UTC-6 jwie...@gmail.com wrote: > > "o" == o1bigtenor writes: > > o> Any ideas on what’s happening here? > > I'm not sure what's going on, but -V tries to be smart and maybe it's > failing > in your case. What happens if you use "-X USD" instead? > > John > -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/088e1ae3-28ae-40d6-b1e3-e25261948f67n%40googlegroups.com.
Re: Currency Designator/Reporting Issues
> "o" == o1bigtenor writes: o> Any ideas on what’s happening here? I'm not sure what's going on, but -V tries to be smart and maybe it's failing in your case. What happens if you use "-X USD" instead? John -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/m28rxzcepc.fsf%40newartisans.com.
Re: Currency Designator/Reporting Issues
Ajoeibin - I want to make the change for consistency. Running a report that shows commodities and currencies using the same format just looks better to my eye. John / Martin - either of you have any ideas as to what might be causing this issue? Thanks! JL On Sunday, November 7, 2021 at 6:26:22 AM UTC-6 Ajoeibin wrote: > On Sat, Nov 6, 2021 at 6:15 PM Jasel17212 > wrote: > >> When I started using ledger a few years ago, I defaulted to using the >> dollar symbol ($) in my journal files. This, of course, works just fine. >> If I want a balance sheet report, I run the following command: >> >> ledger -f 1.ldg --price-db price_db.txt -V --strict –explicit ^Ass ^Lia >> --depth 2 >> >> This produces the following output: >> >> $xxx.xx Assets >> $xxx.xxy >> $xxx.xxy >> $xxx.xxy >> $xxx.xxy >> $xxx.xxy >> $xxx.xxy >> $xxx.xxy >> $xxx.xxy >> $xxx.xxy >> $xxx.xxy >> $xxx.xxy >> $-xxx.xx Liabilities >> $-xxx.xxy >> $-xxx.xxy >> $-xxx.xxy >> >> > $xxx,xxx.xx >> > >> I decided to switch to using USD instead of the dollar symbol. To do this >> I removed all of the dollar symbols from my journal files and price >> database and added USD. Following is the format I used: >> >> xxx.xx USD >> >> Now when I run the exact same balance sheet report, I see commodities >> that I didn’t see before I made my changes. >> >> -5.37578 KO >> > xxx.xx USD >> -2,139.718 VTHRX Assets >> xxx.xx USDy >> xxx.xx USDy >> > xxx.xx USDCrypto >> > xxx.xx USDy >> xxx.xx USDy >> -5.37578 KO >> xxx.xx USD >> -2,139.718 VTHRXy >> xxx.xx USDy >> xxx.xx USDy >> xxx.xx USDy >> xxx.xx USDy >> xxx.xx USDy >> -xxx.xx USD Liabilities >> -xxx.xx USDy >> -xxx.xx USDy >> -xxx.xx USDy >> >> -5.37578 KO >> > xxx,xxx.xx USD >> -2,139.718 VTHRX >> >> What’s interesting here is that the non-USD commodities appear to be >> commodities that I’ve previously sold. In other words, I no longer hold >> VTHRX, and while I do hold some KO, it’s a fraction of a share (see below). >> > >> If I run the same command WITHOUT the -V option, I get a report that >> accurately reflects my current holdings: >> >> ledger -f 1.ldg --price-db price_db.txt --strict –explicit ^Ass ^Lia >> --depth 2 >> >> x. ABC >> 0.04860 KO >> > xxx.xx USD Assets >> xxx.xx USDy >> xxx.xx USDy >> > x. ABCy >> > xxx.xx USDy >> xxx.xx USDy >> 0.04860 KO >> xxx.xx USDy >> xxx.xx USDy >> xxx.xx USDy >> xxx.xx USDy >> xxx.xx USDy >> xxx.xx USDy >> -xxx.xx USD Liabilities >> -xxx.xx USDy >> -xxx.xx USDy >> -xxx.xx USDy >> >> > x. ABC >> 0.04860 KO >> xxx,xxx.xx USD >> > >> Running the original command with -X USD produces the output I expected >> to get in the first place. In other words, the same output I received >> before changing $ to USD, but with the new commodity designator. >> >> ledger -f 1.ldg --price-db price_db.txt -V --strict –explicit ^Ass ^Lia >> --depth 2 -X USD >> >> xxx,xxx.xx USD Assets >> > xxx.xx USD y >> xxx.xx USD y >> xxx.xx USD y >> xxx.xx USD y >> xxx.xx USD y >> xxx.xx USD y >> xxx.xx USD y >> xxx.xx USD y >> xxx.xx USD y >> xxx.xx USD y >> xxx.xx USD y >> -xxx.xx USD Liabilities >> -xxx.xx USD y >> -xxx.xx USD y >> -xxx.xx USD y >> >> > xxx,xxx.xx USD >> > >> Any ideas on what’s happening here? >> >> > Totally can't speak to what's happening in 'ledger' - - - but - - - I'm > wondering why > you would want the change? > > For business - - - - one is expected to run the journal in one's main > currency. > Other currencies are all handled in the main currency. > I think that if there is enough usage of any other currency one could use > a > sub-journal for any such but imo that would be a fairly high volume of > activity > and also involve the use of other currency accounts.
Re: Currency Designator/Reporting Issues
On Sat, Nov 6, 2021 at 6:15 PM Jasel17212 wrote: > When I started using ledger a few years ago, I defaulted to using the > dollar symbol ($) in my journal files. This, of course, works just fine. > If I want a balance sheet report, I run the following command: > > ledger -f 1.ldg --price-db price_db.txt -V --strict –explicit ^Ass ^Lia > --depth 2 > > This produces the following output: > > $xxx.xx Assets > $xxx.xxy > $xxx.xxy > $xxx.xxy > $xxx.xxy > $xxx.xxy > $xxx.xxy > $xxx.xxy > $xxx.xxy > $xxx.xxy > $xxx.xxy > $xxx.xxy > $-xxx.xx Liabilities > $-xxx.xxy > $-xxx.xxy > $-xxx.xxy > > $xxx,xxx.xx > > I decided to switch to using USD instead of the dollar symbol. To do this > I removed all of the dollar symbols from my journal files and price > database and added USD. Following is the format I used: > > xxx.xx USD > > Now when I run the exact same balance sheet report, I see commodities that > I didn’t see before I made my changes. > > -5.37578 KO > xxx.xx USD > -2,139.718 VTHRX Assets > xxx.xx USDy > xxx.xx USDy > xxx.xx USDCrypto > xxx.xx USDy > xxx.xx USDy > -5.37578 KO > xxx.xx USD > -2,139.718 VTHRXy > xxx.xx USDy > xxx.xx USDy > xxx.xx USDy > xxx.xx USDy > xxx.xx USDy > -xxx.xx USD Liabilities > -xxx.xx USDy > -xxx.xx USDy > -xxx.xx USDy > > -5.37578 KO > xxx,xxx.xx USD > -2,139.718 VTHRX > > What’s interesting here is that the non-USD commodities appear to be > commodities that I’ve previously sold. In other words, I no longer hold > VTHRX, and while I do hold some KO, it’s a fraction of a share (see below). > > If I run the same command WITHOUT the -V option, I get a report that > accurately reflects my current holdings: > > ledger -f 1.ldg --price-db price_db.txt --strict –explicit ^Ass ^Lia > --depth 2 > > x. ABC > 0.04860 KO > xxx.xx USD Assets > xxx.xx USDy > xxx.xx USDy > x. ABCy > xxx.xx USDy > xxx.xx USDy > 0.04860 KO > xxx.xx USDy > xxx.xx USDy > xxx.xx USDy > xxx.xx USDy > xxx.xx USDy > xxx.xx USDy > -xxx.xx USD Liabilities > -xxx.xx USDy > -xxx.xx USDy > -xxx.xx USDy > > x. ABC > 0.04860 KO > xxx,xxx.xx USD > > Running the original command with -X USD produces the output I expected to > get in the first place. In other words, the same output I received before > changing $ to USD, but with the new commodity designator. > > ledger -f 1.ldg --price-db price_db.txt -V --strict –explicit ^Ass ^Lia > --depth 2 -X USD > > xxx,xxx.xx USD Assets > xxx.xx USD y > xxx.xx USD y > xxx.xx USD y > xxx.xx USD y > xxx.xx USD y > xxx.xx USD y > xxx.xx USD y > xxx.xx USD y > xxx.xx USD y > xxx.xx USD y > xxx.xx USD y > -xxx.xx USD Liabilities > -xxx.xx USD y > -xxx.xx USD y > -xxx.xx USD y > > xxx,xxx.xx USD > > Any ideas on what’s happening here? > > Totally can't speak to what's happening in 'ledger' - - - but - - - I'm wondering why you would want the change? For business - - - - one is expected to run the journal in one's main currency. Other currencies are all handled in the main currency. I think that if there is enough usage of any other currency one could use a sub-journal for any such but imo that would be a fairly high volume of activity and also involve the use of other currency accounts. Regards -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/CAPpdf5-KXgu3ET89knqDkVufrt4G2QXm3%2BL%3DoH3Kk%3Da%2BG6zPDQ%40mail.gmail.com.
Currency Designator/Reporting Issues
When I started using ledger a few years ago, I defaulted to using the dollar symbol ($) in my journal files. This, of course, works just fine. If I want a balance sheet report, I run the following command: ledger -f 1.ldg --price-db price_db.txt -V --strict –explicit ^Ass ^Lia --depth 2 This produces the following output: $xxx.xx Assets $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $-xxx.xx Liabilities $-xxx.xxy $-xxx.xxy $-xxx.xxy $xx,xxx.xx I decided to switch to using USD instead of the dollar symbol. To do this I removed all of the dollar symbols from my journal files and price database and added USD. Following is the format I used: xxx.xx USD Now when I run the exact same balance sheet report, I see commodities that I didn’t see before I made my changes. -5.37578 KO xx,xxx.xx USD -2,139.718 VTHRX Assets xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy -5.37578 KO xxx.xx USD -2,139.718 VTHRXy xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy -xxx.xx USD Liabilities -xxx.xx USDy -xxx.xx USDy -xxx.xx USDy -5.37578 KO xx,xxx.xx USD -2,139.718 VTHRX What’s interesting here is that the non-USD commodities appear to be commodities that I’ve previously sold. In other words, I no longer hold VTHRX, and while I do hold some KO, it’s a fraction of a share. If I run the same command WITHOUT the -V option, I get a report that accurately reflects my current holdings: ledger -f 1.ldg --price-db price_db.txt --strict –explicit ^Ass ^Lia --depth 2 0.00263224 ABC 0.04860 KO xx,xxx.xx USD Assets xxx.xx USDy xxx.xx USDy 0.00263224 ABCy xxx.xx USDy xxx.xx USDy 0.04860 KO xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy -xxx.xx USD Liabilities -xxx.xx USDy -xxx.xx USDy -xxx.xx USDy 0.00263224 ABC 0.04860 KO xx,xxx.xx USD Running the original command with -X USD produces the output I expected to get in the first place. In other words, the same output I received before changing $ to USD, but with the new commodity designator. ledger -f 1.ldg --price-db price_db.txt -V --strict –explicit ^Ass ^Lia --depth 2 -X USD xx,xxx.xx USD Assets xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y -xxx.xx USD Liabilities -xxx.xx USD y -xxx.xx USD y -xxx.xx USD y xx,xxx.xx USD Any ideas on what’s happening here? -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/4fc61265-0922-4dca-aa51-4d5399c791c3n%40googlegroups.com.
Currency Designator/Reporting Issues
When I started using ledger a few years ago, I defaulted to using the dollar symbol ($) in my journal files. This, of course, works just fine. If I want a balance sheet report, I run the following command: ledger -f 1.ldg --price-db price_db.txt -V --strict –explicit ^Ass ^Lia --depth 2 This produces the following output: $xxx.xx Assets $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $xxx.xxy $-xxx.xx Liabilities $-xxx.xxy $-xxx.xxy $-xxx.xxy $xxx,xxx.xx I decided to switch to using USD instead of the dollar symbol. To do this I removed all of the dollar symbols from my journal files and price database and added USD. Following is the format I used: xxx.xx USD Now when I run the exact same balance sheet report, I see commodities that I didn’t see before I made my changes. -5.37578 KO xxx.xx USD -2,139.718 VTHRX Assets xxx.xx USDy xxx.xx USDy xxx.xx USDCrypto xxx.xx USDy xxx.xx USDy -5.37578 KO xxx.xx USD -2,139.718 VTHRXy xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy -xxx.xx USD Liabilities -xxx.xx USDy -xxx.xx USDy -xxx.xx USDy -5.37578 KO xxx,xxx.xx USD -2,139.718 VTHRX What’s interesting here is that the non-USD commodities appear to be commodities that I’ve previously sold. In other words, I no longer hold VTHRX, and while I do hold some KO, it’s a fraction of a share (see below). If I run the same command WITHOUT the -V option, I get a report that accurately reflects my current holdings: ledger -f 1.ldg --price-db price_db.txt --strict –explicit ^Ass ^Lia --depth 2 x. ABC 0.04860 KO xxx.xx USD Assets xxx.xx USDy xxx.xx USDy x. ABCy xxx.xx USDy xxx.xx USDy 0.04860 KO xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy xxx.xx USDy -xxx.xx USD Liabilities -xxx.xx USDy -xxx.xx USDy -xxx.xx USDy x. ABC 0.04860 KO xxx,xxx.xx USD Running the original command with -X USD produces the output I expected to get in the first place. In other words, the same output I received before changing $ to USD, but with the new commodity designator. ledger -f 1.ldg --price-db price_db.txt -V --strict –explicit ^Ass ^Lia --depth 2 -X USD xxx,xxx.xx USD Assets xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y xxx.xx USD y -xxx.xx USD Liabilities -xxx.xx USD y -xxx.xx USD y -xxx.xx USD y xxx,xxx.xx USD Any ideas on what’s happening here? Thanks JL -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/e29802c4-60ca-40d6-bbd0-5fd6eec8fb41n%40googlegroups.com.