3 Messages
Digest #3075
1b
Re: GuruFocus Financials Extraction for Companies with Less than 10 by "Randy Harmelink" rharmelink
Messages
Sun May 25, 2014 10:36 am (PDT) . Posted by:
ridgebacksexcel
Randy,
I was wondering if there is a good way to extract data on the financials for companies with less than 10 years Data?
The formula you gave out earlier works fine as it counts from 1 to 16 on the spaces which cover years 1-10, TTM totals, and then the most recent 5 quarters.
If the data does not have 16 spaces, I have to manually adjust the formula for now. Is there an automatic way to do it?
I set a cell to adjust the formula not the formula itself but it is still a manual adjustment.
The problem is it is hard to spot a company that needs adjustment without going into the financial page for each one and looking.
Here is what I currently use:
=IF(UPPER($B$2)="NONE","--",RCHGetTableCell("http://www.gurufocus.com/financials/"&$B$2,D$3,"except for per share",">"&$B6&";<",,,,,,"--"))
B2 is the Ticker
D3 is the space count (I need to automatically adjust if possible) for the column. In this case the most recent quarter which is a count of 16.
B6 is the line title I am looking for.
I have a cell (B3) which is normally 0 which I adjust manually to subtract how many years a company's data is short. If it only has 8 years of data instead of 10, I put a 2 in cell B3. It then subtracts from D3 and gives me a 14 which correctly looks for the most recent quarter with only 8 years data.
Any thoughts?
I was wondering if there is a good way to extract data on the financials for companies with less than 10 years Data?
The formula you gave out earlier works fine as it counts from 1 to 16 on the spaces which cover years 1-10, TTM totals, and then the most recent 5 quarters.
If the data does not have 16 spaces, I have to manually adjust the formula for now. Is there an automatic way to do it?
I set a cell to adjust the formula not the formula itself but it is still a manual adjustment.
The problem is it is hard to spot a company that needs adjustment without going into the financial page for each one and looking.
Here is what I currently use:
=IF(UPPER($B$2)="NONE","--",RCHGetTableCell("http://www.gurufocus.com/financials/"&$B$2,
B2 is the Ticker
D3 is the space count (I need to automatically adjust if possible) for the column. In this case the most recent quarter which is a count of 16.
B6 is the line title I am looking for.
I have a cell (B3) which is normally 0 which I adjust manually to subtract how many years a company'
Any thoughts?
Sun May 25, 2014 11:03 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That question was addressed before. Try a search of the message archives to
see if you can find it. I think it did deal with determining where the TTM
was and making everything relative to where it was located.
On Sun, May 25, 2014 at 10:36 AM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I was wondering if there is a good way to extract data on the financials
> for companies with less than 10 years Data?
>
> The formula you gave out earlier works fine as it counts from 1 to 16 on
> the spaces which cover years 1-10, TTM totals, and then the most recent 5
> quarters.
>
> If the data does not have 16 spaces, I have to manually adjust the formula
> for now. Is there an automatic way to do it?
>
> I set a cell to adjust the formula not the formula itself but it is still
> a manual adjustment.
>
> The problem is it is hard to spot a company that needs adjustment without
> going into the financial page for each one and looking.
>
> Here is what I currently use:
>
> =IF(UPPER($B$2)="NONE","--",RCHGetTableCell("
> http://www.gurufocus.com/financials/"&$B$2,D$3,"except for per
> share",">"&$B6&";<",,,,,,"--"))
>
> B2 is the Ticker
>
> D3 is the space count (I need to automatically adjust if possible) for the
> column. In this case the most recent quarter which is a count of 16.
>
> B6 is the line title I am looking for.
>
> I have a cell (B3) which is normally 0 which I adjust manually to subtract
> how many years a company's data is short. If it only has 8 years of data
> instead of 10, I put a 2 in cell B3. It then subtracts from D3 and gives me
> a 14 which correctly looks for the most recent quarter with only 8 years
> data.
>
> Any thoughts?
>
see if you can find it. I think it did deal with determining where the TTM
was and making everything relative to where it was located.
On Sun, May 25, 2014 at 10:36 AM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I was wondering if there is a good way to extract data on the financials
> for companies with less than 10 years Data?
>
> The formula you gave out earlier works fine as it counts from 1 to 16 on
> the spaces which cover years 1-10, TTM totals, and then the most recent 5
> quarters.
>
> If the data does not have 16 spaces, I have to manually adjust the formula
> for now. Is there an automatic way to do it?
>
> I set a cell to adjust the formula not the formula itself but it is still
> a manual adjustment.
>
> The problem is it is hard to spot a company that needs adjustment without
> going into the financial page for each one and looking.
>
> Here is what I currently use:
>
> =IF(UPPER($B$2)="NONE","--",RCHGetTableCell("
> http://www.gurufocus.com/financials/"&$B$2,
> share",
>
> B2 is the Ticker
>
> D3 is the space count (I need to automatically adjust if possible) for the
> column. In this case the most recent quarter which is a count of 16.
>
> B6 is the line title I am looking for.
>
> I have a cell (B3) which is normally 0 which I adjust manually to subtract
> how many years a company'
> instead of 10, I put a 2 in cell B3. It then subtracts from D3 and gives me
> a 14 which correctly looks for the most recent quarter with only 8 years
> data.
>
> Any thoughts?
>
Sun May 25, 2014 11:59 am (PDT) . Posted by:
ridgebacksexcel
Ok I will try and locate the thread. The solution makes sense however.
Tidak ada komentar:
Posting Komentar