Welcome, Guest

Currency used in filter outputs
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Currency used in filter outputs

Currency used in filter outputs 6 years, 6 months ago #188

  • jwmichelc
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
Hi,

when running filters on Canadian exchanges, the output seems to be in $US instead of in $CA. Is this correct? If so, how can I get the filter output results in the original currency (in $CA in this case instead of in $US)?

Thank you
Michel

Re: Currency used in filter outputs 6 years, 6 months ago #191

  • admin
  • OFFLINE
  • Administrator
  • Posts: 283
  • Karma: 17
You can divide by:

Currency Exchange Rate to USD(I)

to get back to original currency in a free form column or condition.

Thanks,
Lenny Grover
Founder/CEO
FinToolbox/Screener.co

Re: Currency used in filter outputs 5 years, 8 months ago #261

  • mulloway
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Hi Lenny I am a bit slow so can you explain or point me to a fuller explanation.
I am in Australia and want to see all Aussie stuff in Aussie $.
I used this to see the price in a free form column.
Price-closing or last bid * Exchange Rate From Financial Reporting Currency to USD
Is there some setting where I use the original Aussie numbers?
Can I use the installed screens with an aussie $ default?

Thanks

Luke
Luke

Re: Currency used in filter outputs 5 years, 8 months ago #265

  • admin
  • OFFLINE
  • Administrator
  • Posts: 283
  • Karma: 17
Luke,

You would use a Free Form Condition or Free Form Column that uses the composite condition:

( Price-closing or last bid / Currency Exchange Rate to USD(I) )

rather than just:

Price-closing or last bid

The top would be the price in Aussie $ while the bottom would be the price converted to US dollars.

Market cap can be similarly adjusted (by dividing by currency exchange rate to USD(I)).

Other screening conditions, (i.e. Revenue) can be adjusted by using the:

Exchange Rate From Financial Reporting Currency to USD

variable instead of the currency exchange rate variable.

There may be some minor issues with companies that report in one non-USD currency and price in a second non-USD currency. But, you should be able to work through them with the included Exchange Rate variables.

All of this is handled for you automatically in the company profiles, where financial statements in original reporting currency are presented.

Thanks,
Lenny Grover
Founder/CEO
FinToolbox/Screener.co
  • Page:
  • 1
Time to create page: 0.12 seconds