Hi Daniel,  I again see Equinox with no statements.  Again I wonder if this may be because the vote was completed to join Leagold to Equinox.  If so, when do you think the statements will be added?  Thank you.

There are no statements for Equinox Gold today.  They just merged with Leagold so I don't know if that is the reason.

Awesome.

I just figured out a way to get around the "Net Income" problem - add a letter to the line and VLOOKUP will drop down to pick up the right line.    (i.e. add "A" to Net Income - A Net Income - will cause it to drop to the Net Income line).  Other line where it is a problem are Revenues and the same thing works, so as long as they don't repeat it is okay..

Hello Daniel,

    I am in error about the thousands - they're in millions - but my concern is that in one they will show it written out and in another with a decimal point. In looking through recent reports and the statements on your site, I'm wondering if maybe you have already corrected this.  For example, I have Micron and Nutrien statements downloaded from  your site with the numbers written out (for example Micron CF statement shows TTM Net Income of 10,077,000,000)  but the newest full year of Micron CF shows 6313.0 with the note about it being in millions.  I didn't look through a lot of other reports, but most of them were downloaded with the numbers written out and now I'm seeing that they have been abbreviated with a decimal point.  My point is that they need to be consistent. If it is not consistent it is necessary to go through my model line by line to make sure that all the connections are either written out or with the decimal point.

     If you send me an email address I will send you a sample of what I downloaded if you wish; I don't see how I can attach an Excel spreadsheet here.

     Also, It is best if everything is on the same line in every report so it is easy to reference by line number, but it's not a huge problem if it is not as long as VLOOKUP can pick up the category .  What I am seeing (for example in Fairfax India's CF statement) is that it says "Net Income" as a heading and then on the next line it drops down and says Net Income again and it does that with other categories as well.  When you have something like this where Net Income is a heading on a line with no numbers and then below it the same words with the numbers, VLOOKUP will pick up the first one and produce a blank. So this format makes it not possible to use either way of automatic linking - line number or VLOOKUP - and you have to do it manually.  There must be ways to get around this, but I'm not a programmer and I don't know what they are.  Maybe instead of making a heading you could bold things like Net Income and Cash from Operations or underline them and it would look nice but not interfere with its use.

   Thank you for your reply about the other issues.  Glad to hear you're working on those text-to-numbers.

Barb Gladfelter

Daniel,

   Okay, I see that.  Fair enough on this.  Thank you.

Barbara

I noticed this mostly in the income statement.  Both B2G and Seeking Alpha data are in USD.  Some examples would be in the 2018 income statement: 

                                      Seeking Alpha                        B2G

Cost of Revenues/sales 553,976,000                         860,405,000

Gross Profit                    671,085,000                        364,656,000

Operating Income           215,449,000                        219,514,000

Net Income                       28,938,000                          45,121,000   

As you can see some of these are way off. These are just examples.  I spent several hours straightening this out.   I don't know if a computer is pulling this data from the forms, but if so your programmer needs to take a look at this.

Barbara           

I copy the Income Statement, Balance Sheet & CF Statement into my personal model using highlight, copy, then paste into the model.  When I do that, it is pasted in text format and there is usually a little button on the left side of the cell that allows the text format to be converted to number format.  Sometimes that little number format button is not there and I have difficulty with getting it.  If it is not in number format the formulas in the model don't work.  Yesterday I closed the program, rebooted the computer and then the little button did appear and I could change it.

I have no idea why you would put the statements up with text format for the numbers.  It just creates unnecessary work,  If you feel you have to publish them in text format requiring conversion to numbers, perhaps you can tell me a way to convert the numbers to number format not using the button if it doesn't show up.  I have tried applying various number formats in Excel and they don't work.  I would also like to know what VBA code I might use to convert the text numbers to number format numbers and perhaps I can make a macro to do that.  Thank you very much.   If you need a visual of this I don't see how I can attach a clip of what is going on, so if you give me an email to send you a clip of this I will send you that.