[smf_addin] Digest Number 4501

EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #4501

1a

Re: Issue with AdvFN Financial Statements ? by antoine61

2

Cdn Financial Statement Data by weedstudyman@gmail.com

Messages

1a

Re: Issue with AdvFN Financial Statements ?

Thu Mar 14, 2019 8:16 am (PDT) . Posted by:

antoine61

Thanks Randy.

This is what I get for these requests:


Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\SMF Add-In; Windows (32-bit) NT :.00; 15.0; www; Local; 2)
Error
Error

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2

Cdn Financial Statement Data

Thu Mar 14, 2019 8:31 am (PDT) . Posted by:

weedstudyman@gmail.com

Anyone have a contact at ADVFN?
I'm finding errors in pulling Canadian listed TSX and TSXV financial statement data for the last two quarters for all tickers using the smfGetADVFNElement formula.
All financial statement line items such as "Total Equity", "Revenue" etc are being shown converted to USD, from their original CAD reports. I have verified this off of the company original filings on Sedar (Cdn version of Edgar).
The strange thing is this only applies to the last two quarters. For all quarters before then, the line items still show in original CAD denomination.
Also strange, the shares outstanding are also being "converted" by the exchange rate, which is silly and wrong. Thanks all

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use