4 Messages
Digest #3901
Messages
Fri Jan 27, 2017 5:44 am (PST) . Posted by:
jhfrazer@ymail.com
Randy,
Welcome back. I hope you are on the mend.
Be well,
John
Welcome back. I hope you are on the mend.
Be well,
John
Fri Jan 27, 2017 10:22 am (PST) . Posted by:
indinvestor111
Hi Randy,
Hope you're feeling better! Was wondering if somebody could suggest a work around when the add-in mis-interprets the Yahoo finance nomenclature. The issue arises when the site lists a number under 1 million. YHOO uses the "k" for thousands, "M" for millions, and "B" for billions.
Unfortunately, the add-in doesn't delineate between the "K" and "M". For instance, element #966 for the ticker HSGX returns 907,000 when the site indicates 907k. Compare this to COGT, which returns 49,900, when the site lists 49.9M.
So the add-in is returning a higher number for HSGX when in reality, it should be roughly 1/50 the size. Any ideas for a work-around? Thanks
Hope you're feeling better! Was wondering if somebody could suggest a work around when the add-in mis-interprets the Yahoo finance nomenclature. The issue arises when the site lists a number under 1 million. YHOO uses the "k" for thousands, "M" for millions, and "B" for billions.
Unfortunately, the add-in doesn't delineate between the "K" and "M"
So the add-in is returning a higher number for HSGX when in reality, it should be roughly 1/50 the size. Any ideas for a work-around? Thanks
Fri Jan 27, 2017 1:23 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The only work-around I can suggest is to know the numbers you're dealing
with. The add-in does the conversion based on the typical (but not
specific) context of the suffix usage. Most of which is the B/M from
financial statements. Many of the current conversion choices were based on
an "as needed" basis.
The current conversion process from text to number:
If s1 = "-" Then s1 = "0"
> If s1 = "--" Then s1 = "0"
> If s1 = "---" Then s1 = "0"
> If s1 = Chr(150) Then s1 = "0"
> If Left(s1, 1) = "$" Then s1 = Mid(s1, 2)
> If Left(s1, 1) = "(" And Right(s1, 1) = ")" Then s1 = "-" &
> Mid(s1, 2, Len(s1) - 2)
> s2 = s1
>
> Select Case True
> Case UCase(Right(s2, 1)) = "B": s2 = Left(s2, Len(s2) - 1):
> nMult = 1000000
> Case UCase(Right(s2, 1)) = "K": s2 = Left(s2, Len(s2) - 1):
> nMult = 1000
> Case UCase(Right(s2, 1)) = "M": s2 = Left(s2, Len(s2) - 1):
> nMult = 1000
> Case Right(s2, 1) = "%": s2 = Left(s2, Len(s2) - 1): nMult =
> 0.01
> Case Right(s2, 4) = " Bil": s2 = Left(s2, Len(s2) - 4): nMult
> = 1000000000
> Case Right(s2, 4) = " Mil": s2 = Left(s2, Len(s2) - 4): nMult
> = 1000000
> Case Right(s2, 4) = " bil": s2 = Left(s2, Len(s2) - 4): nMult
> = 1000000000
> Case Right(s2, 4) = " mil": s2 = Left(s2, Len(s2) - 4): nMult
> = 1000000
> Case Right(s2, 5) = " Bill": s2 = Left(s2, Len(s2) - 5): nMult
> = 1000000000
> Case Right(s2, 5) = " Mill": s2 = Left(s2, Len(s2) - 5): nMult
> = 1000000
> Case Right(s2, 8) = " Billion": s2 = Left(s2, Len(s2) - 8):
> nMult = 1000000000
> Case Right(s2, 8) = " Million": s2 = Left(s2, Len(s2) - 8):
> nMult = 1000000
> Case Else: nMult = 1
> End Select
>
>
Suggestions for improvement?
On Fri, Jan 27, 2017 at 11:21 AM, elandry@bmlcapital.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Hi Randy,
>
>
> Hope you're feeling better! Was wondering if somebody could suggest a work
> around when the add-in mis-interprets the Yahoo finance nomenclature. The
> issue arises when the site lists a number under 1 million. YHOO uses the
> "k" for thousands, "M" for millions, and "B" for billions.
>
>
> Unfortunately, the add-in doesn't delineate between the "K" and "M". For
> instance, element #966 for the ticker HSGX returns 907,000 when the site
> indicates 907k. Compare this to COGT, which returns 49,900, when the site
> lists 49.9M.
>
>
> So the add-in is returning a higher number for HSGX when in reality, it
> should be roughly 1/50 the size. Any ideas for a work-around? Thanks
>
>
with. The add-in does the conversion based on the typical (but not
specific) context of the suffix usage. Most of which is the B/M from
financial statements. Many of the current conversion choices were based on
an "as needed" basis.
The current conversion process from text to number:
If s1 = "-" Then s1 = "0"
> If s1 = "--" Then s1 = "0"
> If s1 = "---" Then s1 = "0"
> If s1 = Chr(150) Then s1 = "0"
> If Left(s1, 1) = "$" Then s1 = Mid(s1, 2)
> If Left(s1, 1) = "(" And Right(s1, 1) = ")" Then s1 = "-" &
> Mid(s1, 2, Len(s1) - 2)
> s2 = s1
>
> Select Case True
> Case UCase(Right(s2, 1)) = "B": s2 = Left(s2, Len(s2) - 1):
> nMult = 1000000
> Case UCase(Right(s2, 1)) = "K": s2 = Left(s2, Len(s2) - 1):
> nMult = 1000
> Case UCase(Right(s2, 1)) = "M": s2 = Left(s2, Len(s2) - 1):
> nMult = 1000
> Case Right(s2, 1) = "%": s2 = Left(s2, Len(s2) - 1): nMult =
> 0.01
> Case Right(s2, 4) = " Bil": s2 = Left(s2, Len(s2) - 4): nMult
> = 1000000000
> Case Right(s2, 4) = " Mil": s2 = Left(s2, Len(s2) - 4): nMult
> = 1000000
> Case Right(s2, 4) = " bil": s2 = Left(s2, Len(s2) - 4): nMult
> = 1000000000
> Case Right(s2, 4) = " mil": s2 = Left(s2, Len(s2) - 4): nMult
> = 1000000
> Case Right(s2, 5) = " Bill": s2 = Left(s2, Len(s2) - 5): nMult
> = 1000000000
> Case Right(s2, 5) = " Mill": s2 = Left(s2, Len(s2) - 5): nMult
> = 1000000
> Case Right(s2, 8) = " Billion": s2 = Left(s2, Len(s2) - 8):
> nMult = 1000000000
> Case Right(s2, 8) = " Million": s2 = Left(s2, Len(s2) - 8):
> nMult = 1000000
> Case Else: nMult = 1
> End Select
>
>
Suggestions for improvement?
On Fri, Jan 27, 2017 at 11:21 AM, elandry@bmlcapital.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Hi Randy,
>
>
> Hope you're feeling better! Was wondering if somebody could suggest a work
> around when the add-in mis-interprets the Yahoo finance nomenclature. The
> issue arises when the site lists a number under 1 million. YHOO uses the
> "k" for thousands, "M" for millions, and "B" for billions.
>
>
> Unfortunately, the add-in doesn't delineate between the "K" and "M"
> instance, element #966 for the ticker HSGX returns 907,000 when the site
> indicates 907k. Compare this to COGT, which returns 49,900, when the site
> lists 49.9M.
>
>
> So the add-in is returning a higher number for HSGX when in reality, it
> should be roughly 1/50 the size. Any ideas for a work-around? Thanks
>
>
Fri Jan 27, 2017 7:01 pm (PST) . Posted by:
sjagers
Hi Randy.... I see that you're posting again. Welcome Back! I hope you're feeling better and doing okay?
FYI... If you're interested to know.... Zack's changed their website again.
The word, or label, "Industry" used by GetElements 850 function was removed from their "Quote Overview" page. The overview page lists the Sector and Industry classification, but the "Industry" label is gone. However, that label ("Industry") is still included on their "Comparison to Industry" page.
Quote Overview: https://www.zacks.com/stock/quote/KR https://www.zacks.com/stock/quote/KR
Comparison to Industry: https://www.zacks.com/stock/research/KR/industry-comparison https://www.zacks.com/stock/research/KR/industry-comparison
Again, just FYI, if you're interested.
Welcome Back!
FYI... If you're interested to know.... Zack's changed their website again.
The word, or label, "Industry" used by GetElements 850 function was removed from their "Quote Overview" page. The overview page lists the Sector and Industry classification, but the "Industry" label is gone. However, that label ("Industry") is still included on their "Comparison to Industry" page.
Quote Overview: https://www.zacks.com/stock/quote/KR https://www.zacks.com/stock/quote/KR
Comparison to Industry: https://www.zacks.com/stock/research/KR/industry-comparison https://www.zacks.com/stock/research/KR/industry-comparison
Again, just FYI, if you're interested.
Welcome Back!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar