10 Messages
Digest #3106
Messages
Sat Jun 28, 2014 6:45 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
Here's one for you that should be pretty interesting.
I'm pulling fields from Gurufocus.com and unfortunately, they are
inconsistent with their labeling of lines in their 10-Y Financials page. On
one stock, they may have something like:
Cash and cash equivalents, but on a different ticker it's:
Cash and Cash Equivalents.
So I will only get an "ERROR" return in my spreadsheet for the wrong text.
Is there any way to cover both situations? Other than a lengthy IF
statement?
Thanks,
Jim
Here's one for you that should be pretty interesting.
I'm pulling fields from Gurufocus.com and unfortunately, they are
inconsistent with their labeling of lines in their 10-Y Financials page. On
one stock, they may have something like:
Cash and cash equivalents, but on a different ticker it's:
Cash and Cash Equivalents.
So I will only get an "ERROR" return in my spreadsheet for the wrong text.
Is there any way to cover both situations? Other than a lengthy IF
statement?
Thanks,
Jim
Sat Jun 28, 2014 7:11 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
How about just going with "Cash Equivalents"?
Or, can you use the [series] tag? Do they vary between the two equities?
Or, there, just "CashEquivalents" as well.
On Sat, Jun 28, 2014 at 6:45 PM, 'Jim Ranum' amt2100@... wrote:
>
> Here's one for you that should be pretty interesting.
>
> I'm pulling fields from Gurufocus.com and unfortunately, they are
> inconsistent with their labeling of lines in their 10-Y Financials page. On
> one stock, they may have something like:
>
> Cash and cash equivalents, but on a different ticker it's:
>
> Cash and Cash Equivalents.
>
>
>
> So I will only get an "ERROR" return in my spreadsheet for the wrong text.
>
> Is there any way to cover both situations? Other than a lengthy IF
> statement?
>
>
>
Or, can you use the [series] tag? Do they vary between the two equities?
Or, there, just "CashEquivalen
On Sat, Jun 28, 2014 at 6:45 PM, 'Jim Ranum' amt2100@... wrote:
>
> Here's one for you that should be pretty interesting.
>
> I'm pulling fields from Gurufocus.com and unfortunately, they are
> inconsistent with their labeling of lines in their 10-Y Financials page. On
> one stock, they may have something like:
>
> Cash and cash equivalents, but on a different ticker it's:
>
> Cash and Cash Equivalents.
>
>
>
> So I will only get an "ERROR" return in my spreadsheet for the wrong text.
>
> Is there any way to cover both situations? Other than a lengthy IF
> statement?
>
>
>
Sat Jun 28, 2014 7:24 pm (PDT) . Posted by:
"Jim Ranum" amt2100
There's another line that contains Cash Equivalents in it. (Cash, Cash Equivalents, Marketable Securities)
It's the upper or lower case that varies between different tickers. In this line that I need.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, June 28, 2014 10:11 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Inconsistent text
How about just going with "Cash Equivalents"?
Or, can you use the [series] tag? Do they vary between the two equities? Or, there, just "CashEquivalents" as well.
On Sat, Jun 28, 2014 at 6:45 PM, 'Jim Ranum' amt2100@... wrote:
Here's one for you that should be pretty interesting.
I'm pulling fields from Gurufocus.com and unfortunately, they are inconsistent with their labeling of lines in their 10-Y Financials page. On one stock, they may have something like:
Cash and cash equivalents, but on a different ticker it's:
Cash and Cash Equivalents.
So I will only get an "ERROR" return in my spreadsheet for the wrong text.
Is there any way to cover both situations? Other than a lengthy IF statement?
It's the upper or lower case that varies between different tickers. In this line that I need.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, June 28, 2014 10:11 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Inconsistent text
How about just going with "Cash Equivalents"
Or, can you use the [series] tag? Do they vary between the two equities? Or, there, just "CashEquivalen
On Sat, Jun 28, 2014 at 6:45 PM, 'Jim Ranum' amt2100@... wrote:
Here's one for you that should be pretty interesting.
I'm pulling fields from Gurufocus.com and unfortunately, they are inconsistent with their labeling of lines in their 10-Y Financials page. On one stock, they may have something like:
Cash and cash equivalents, but on a different ticker it's:
Cash and Cash Equivalents.
So I will only get an "ERROR" return in my spreadsheet for the wrong text.
Is there any way to cover both situations? Other than a lengthy IF statement?
Sat Jun 28, 2014 7:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The string search doesn't differentiate between upper and lower case. It
converts both data and search term to upper case before searching.
Can multiple search strings get you to what you need?
An example of these anomalies would help.
On Sat, Jun 28, 2014 at 7:24 PM, 'Jim Ranum' amt2100@... wrote:
>
> There's another line that contains Cash Equivalents in it. (Cash, Cash
> Equivalents, Marketable Securities)
>
>
>
> It's the upper or lower case that varies between different tickers. In
> this line that I need.
>
converts both data and search term to upper case before searching.
Can multiple search strings get you to what you need?
An example of these anomalies would help.
On Sat, Jun 28, 2014 at 7:24 PM, 'Jim Ranum' amt2100@... wrote:
>
> There's another line that contains Cash Equivalents in it. (Cash, Cash
> Equivalents, Marketable Securities)
>
>
>
> It's the upper or lower case that varies between different tickers. In
> this line that I need.
>
Sat Jun 28, 2014 7:50 pm (PDT) . Posted by:
"Jim Ranum" amt2100
This one returns an error and the only thing I can see that is different is the lower case letters.
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC,11,">Fiscal Period",">Cash and cash equivalents")
This same line with the ticker PULB works fine.
However, I did try changing the lower case letters to upper case and that still didn't work for IEHC. So I don't know why I'm getting an error for IEHC. The result in the webpage is clearly visible: 1.23
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, June 28, 2014 10:39 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Inconsistent text
The string search doesn't differentiate between upper and lower case. It converts both data and search term to upper case before searching.
Can multiple search strings get you to what you need?
An example of these anomalies would help.
On Sat, Jun 28, 2014 at 7:24 PM, 'Jim Ranum' amt2100@... wrote:
There's another line that contains Cash Equivalents in it. (Cash, Cash Equivalents, Marketable Securities)
It's the upper or lower case that varies between different tickers. In this line that I need.
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC,11,">Fiscal Period",">Cash and cash equivalents")
This same line with the ticker PULB works fine.
However, I did try changing the lower case letters to upper case and that still didn't work for IEHC. So I don't know why I'm getting an error for IEHC. The result in the webpage is clearly visible: 1.23
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, June 28, 2014 10:39 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Inconsistent text
The string search doesn't differentiate between upper and lower case. It converts both data and search term to upper case before searching.
Can multiple search strings get you to what you need?
An example of these anomalies would help.
On Sat, Jun 28, 2014 at 7:24 PM, 'Jim Ranum' amt2100@... wrote:
There's another line that contains Cash Equivalents in it. (Cash, Cash Equivalents, Marketable Securities)
It's the upper or lower case that varies between different tickers. In this line that I need.
Sat Jun 28, 2014 7:54 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Oh, I just found it. On the ticker IEHC the line label Cash and cash equivalent has an indentation of one space.
Is there a way to write the instruction to work with and without an indentation?
From: Jim Ranum [mailto:amt2100@gmail.com]
Sent: Saturday, June 28, 2014 10:51 PM
To: 'smf_addin@yahoogroups.com'
Subject: RE: [smf_addin] Inconsistent text
This one returns an error and the only thing I can see that is different is the lower case letters.
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC,11,">Fiscal Period",">Cash and cash equivalents")
This same line with the ticker PULB works fine.
However, I did try changing the lower case letters to upper case and that still didn't work for IEHC. So I don't know why I'm getting an error for IEHC. The result in the webpage is clearly visible: 1.23
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, June 28, 2014 10:39 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Inconsistent text
The string search doesn't differentiate between upper and lower case. It converts both data and search term to upper case before searching.
Can multiple search strings get you to what you need?
An example of these anomalies would help.
On Sat, Jun 28, 2014 at 7:24 PM, 'Jim Ranum' amt2100@... wrote:
There's another line that contains Cash Equivalents in it. (Cash, Cash Equivalents, Marketable Securities)
It's the upper or lower case that varies between different tickers. In this line that I need.
Is there a way to write the instruction to work with and without an indentation?
From: Jim Ranum [mailto:amt2100@gmail.com]
Sent: Saturday, June 28, 2014 10:51 PM
To: 'smf_addin@yahoogroups.com'
Subject: RE: [smf_addin] Inconsistent text
This one returns an error and the only thing I can see that is different is the lower case letters.
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC,11,">Fiscal Period",">Cash and cash equivalents")
This same line with the ticker PULB works fine.
However, I did try changing the lower case letters to upper case and that still didn't work for IEHC. So I don't know why I'm getting an error for IEHC. The result in the webpage is clearly visible: 1.23
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, June 28, 2014 10:39 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Inconsistent text
The string search doesn't differentiate between upper and lower case. It converts both data and search term to upper case before searching.
Can multiple search strings get you to what you need?
An example of these anomalies would help.
On Sat, Jun 28, 2014 at 7:24 PM, 'Jim Ranum' amt2100@... wrote:
There's another line that contains Cash Equivalents in it. (Cash, Cash Equivalents, Marketable Securities)
It's the upper or lower case that varies between different tickers. In this line that I need.
Sat Jun 28, 2014 8:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's because the HTML code on the page for that ticker is inconsistent,
with:
> Cash And Cash Equivalents<
The add-in would convert the two " " into normal spaces, but it won't
match your search string. Any of these would work:
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC",11,">Fiscal
Period","> Cash and cash equivalents")
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC
",11,"/term/cashandcashequivalents/")
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC",12,">Fiscal
Period","cashequivalents")
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC",12,">Fiscal
Period","cash equivalents")
Note that the last two have different pCells parameter values because the
strings are found in a different table cell. Also note that those last 2
also work for PULB.
But it looks like it could be an adventure. :(
On Sat, Jun 28, 2014 at 7:50 PM, 'Jim Ranum' amt2100@... wrote:
>
> This one returns an error and the only thing I can see that is different
> is the lower case letters.
>
>
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/IEHC,11,">Fiscal
> Period",">Cash and cash equivalents")
>
>
>
> This same line with the ticker PULB works fine.
>
>
>
> However, I did try changing the lower case letters to upper case and that
> still didn't work for IEHC. So I don't know why I'm getting an error for
> IEHC. The result in the webpage is clearly visible: 1.23
>
>
with:
> Cash And Cash Equivalents<
The add-in would convert the two " " into normal spaces, but it won't
match your search string. Any of these would work:
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC",11,">Fiscal
Period","> Cash and cash equivalents")
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC
",11,"/term/cashandcashequivalents/")
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC",12,">Fiscal
Period","cashequivalents")
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC",12,">Fiscal
Period","cash equivalents")
Note that the last two have different pCells parameter values because the
strings are found in a different table cell. Also note that those last 2
also work for PULB.
But it looks like it could be an adventure. :(
On Sat, Jun 28, 2014 at 7:50 PM, 'Jim Ranum' amt2100@... wrote:
>
> This one returns an error and the only thing I can see that is different
> is the lower case letters.
>
>
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/IEHC,11,">Fiscal
> Period"
>
>
>
> This same line with the ticker PULB works fine.
>
>
>
> However, I did try changing the lower case letters to upper case and that
> still didn't work for IEHC. So I don't know why I'm getting an error for
> IEHC. The result in the webpage is clearly visible: 1.23
>
>
Sat Jun 28, 2014 8:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You could put the HTML tag portion on the end instead of the beginning. For
example:
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC",11,">Fiscal
Period","Cash and cash equivalents<")
=RCHGetTableCell("http://www.gurufocus.com/financials/PULB",11,">Fiscal
Period","Cash and cash equivalents<")
On Sat, Jun 28, 2014 at 7:54 PM, 'Jim Ranum' amt2100@... wrote:
>
> Oh, I just found it. On the ticker IEHC the line label Cash and cash
> equivalent has an indentation of one space.
>
> Is there a way to write the instruction to work with and without an
> indentation?
>
example:
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC",11,">Fiscal
Period","Cash and cash equivalents<")
=RCHGetTableCell("http://www.gurufocus.com/financials/PULB",11,"
Period"
On Sat, Jun 28, 2014 at 7:54 PM, 'Jim Ranum' amt2100@... wrote:
>
> Oh, I just found it. On the ticker IEHC the line label Cash and cash
> equivalent has an indentation of one space.
>
> Is there a way to write the instruction to work with and without an
> indentation?
>
Sat Jun 28, 2014 8:56 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Oh yeah. That's got it.
You're a wizard.
Thanks Randy.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, June 28, 2014 11:35 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Inconsistent text
You could put the HTML tag portion on the end instead of the beginning. For example:
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC",11,">Fiscal Period","Cash and cash equivalents<")
=RCHGetTableCell("http://www.gurufocus.com/financials/PULB",11,">Fiscal Period","Cash and cash equivalents<")
On Sat, Jun 28, 2014 at 7:54 PM, 'Jim Ranum' amt2100@... wrote:
Oh, I just found it. On the ticker IEHC the line label Cash and cash equivalent has an indentation of one space.
Is there a way to write the instruction to work with and without an indentation?
You're a wizard.
Thanks Randy.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, June 28, 2014 11:35 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Inconsistent text
You could put the HTML tag portion on the end instead of the beginning. For example:
=RCHGetTableCell("http://www.gurufocus.com/financials/IEHC",11,">Fiscal Period","Cash and cash equivalents<")
=RCHGetTableCell("http://www.gurufocus.com/financials/PULB",11,"
On Sat, Jun 28, 2014 at 7:54 PM, 'Jim Ranum' amt2100@... wrote:
Oh, I just found it. On the ticker IEHC the line label Cash and cash equivalent has an indentation of one space.
Is there a way to write the instruction to work with and without an indentation?
Sun Jun 29, 2014 1:01 am (PDT) . Posted by:
schlange.meister
Hi Guys
I did not see any RCHGetElements for FinViz so I wanted to ask her for some advice.
I am trying to download the 3 month, 6 month and annual performance from the FinViz page. It is on the right side of the table when you search for a stock. I want to do this for about 15 stocks at a time and was wondering two things:
1. What is the code needed to reference the ticker in A3 and download the 3m, 6m and full year performance from Finviz
2. Is there a faster way to do it given 3 fields and 15 stocks? Would an array be better for the data and less load on Finviz? How would I implement something like that?
Thank you,
I did not see any RCHGetElements for FinViz so I wanted to ask her for some advice.
I am trying to download the 3 month, 6 month and annual performance from the FinViz page. It is on the right side of the table when you search for a stock. I want to do this for about 15 stocks at a time and was wondering two things:
1. What is the code needed to reference the ticker in A3 and download the 3m, 6m and full year performance from Finviz
2. Is there a faster way to do it given 3 fields and 15 stocks? Would an array be better for the data and less load on Finviz? How would I implement something like that?
Thank you,
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar