Re: Reports balance sheet - with explicit dual currency for "$"

2018-02-26 Thread Wm

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 "$"

2018-02-25 Thread Wm via gnucash-user

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 "$"

2018-02-24 Thread Adrien Monteleone
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 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.  
> 
> 
> 
> 
> 
> 
> --
> 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 "$"

2018-02-24 Thread Vin Ordinaire

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.