Re: Reports balance sheet - with explicit dual currency for "$"
On 24/02/2018 18:05, Vin Ordinaire wrote: 2nd reply Dollars are great - pick one of many flavours USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others. Aside: For thinking flox with idle time you can decide for yourself who invented the dollar or the symbol as they have separate histories, similar for the pound (more varied than $ in representation) as a unit or symbol. My advice is use the 3 letter codes and stop being protective of the dumb symbols. Hint: no country owns $ as a symbol. Got it? The problem is reporting a balance sheet multiple currency assets. I located in the Windows version Options>Commodities>Show Foreign Currencies that does indeed show the "other" value in whatever currency I post the asset in. Presuming you know a balance sheet is at a point in time and that you know you have absolute control over the exchange rates your price db has in it, I'm not seeing the problem. If you don't like the exchange rate change it ! This may not reflect the real world, of course :) Most people here are likely to suggest your view of exchange rates approximates real world exchanges. It is possible for unconventional trades to exist but you probably shouldn't tell everyone about them unless you can suggest a model. However, when pairing USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others, the "$" is highly ambiguous and confusing. I pair AUD, USD and HKG and have assets in all three currencies. I'm with AdrienM in that I don't understand your use of currency pairing, BTW. See above about $ as a symbol being redundant. -- Wm ___ 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: Reports balance sheet - with explicit dual currency for "$"
On 24/02/2018 18:05, Vin Ordinaire wrote: Dollars are great - pick one of many flavours USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others. The problem is reporting a balance sheet multiple currency assets. I located in the Windows version Options>Commodities>Show Foreign Currencies that does indeed show the "other" value in whatever currency I post the asset in. However, when pairing USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others, the "$" is highly ambiguous and confusing. I pair AUD, USD and HKG and have assets in all three currencies. Is there a way (or in the future) for Reports to have a check box "Explicitly show iso-4217 currency designation" to show side by side in the reports like this under assets: Widgit $HKG 8000 $USD 12000 Bluto $AUD 1000 $USD 770 Overall a great alternative to Quicken and its bloatware and its behind the scenes business deals with banks to restrict access to data for users (and why most US banks do not widely use OFX and have plenty of data as opposed to say 90 days) - I suppose license fees, subscription and captivity play a huge role in this. Ideas and apologies in advance if this is a newbie RTFM type question, though I see Frédéric Perrin and Derek Atkins and others having a dialogue. If I understand your query correctly you can edit the symbols via Tools / Security editor (make sure you have "Show national currencies" ticked / Currencies you can change them to anything you want. I think most people use the 3 letter symbols rather relying on the $ -- Wm time passes while mods ponder ___ 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: Reports balance sheet - with explicit dual currency for "$"
Not sure why you aren’t seeing it properly with that setting. I have some dollars from both Canada and the Bahamas and both accounts show the foreign and US currency amounts. Canada shows up as C$, and Bahamas as B$ and U.S. as just “$”. All of the foreign currencies are in the left column and US$ in the right column so I don’t see what the confusion would be. Perhaps I’m not understanding what you mean by ‘pair’ with respect to currencies. Regards, Adrien > On Feb 24, 2018, at 12:05 PM, Vin Ordinairewrote: > > > Dollars are great - pick one of many flavours > USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others. > > The problem is reporting a balance sheet multiple currency assets. I > located in the Windows version Options>Commodities>Show Foreign Currencies > that does indeed show the "other" value in whatever currency I post the > asset in. > > However, when pairing USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others, > the "$" is highly ambiguous and confusing. I pair AUD, USD and HKG and have > assets in all three currencies. Is there a way (or in the future) for > Reports to have a check box "Explicitly show iso-4217 currency designation" > to show side by side in the reports like this under assets: > > Widgit $HKG 8000 $USD 12000 > Bluto $AUD 1000 $USD 770 > > Overall a great alternative to Quicken and its bloatware and its behind the > scenes business deals with banks to restrict access to data for users (and > why most US banks do not widely use OFX and have plenty of data as opposed > to say 90 days) - I suppose license fees, subscription and captivity play a > huge role in this. > > Ideas and apologies in advance if this is a newbie RTFM type question, > though I see Frédéric Perrin and Derek Atkins and others having a dialogue. > > > > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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.
Reports balance sheet - with explicit dual currency for "$"
Dollars are great - pick one of many flavours USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others. The problem is reporting a balance sheet multiple currency assets. I located in the Windows version Options>Commodities>Show Foreign Currencies that does indeed show the "other" value in whatever currency I post the asset in. However, when pairing USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others, the "$" is highly ambiguous and confusing. I pair AUD, USD and HKG and have assets in all three currencies. Is there a way (or in the future) for Reports to have a check box "Explicitly show iso-4217 currency designation" to show side by side in the reports like this under assets: Widgit $HKG 8000 $USD 12000 Bluto $AUD 1000 $USD 770 Overall a great alternative to Quicken and its bloatware and its behind the scenes business deals with banks to restrict access to data for users (and why most US banks do not widely use OFX and have plenty of data as opposed to say 90 days) - I suppose license fees, subscription and captivity play a huge role in this. Ideas and apologies in advance if this is a newbie RTFM type question, though I see Frédéric Perrin and Derek Atkins and others having a dialogue. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.