Selasa, 10 Februari 2015

[smf_addin] Digest Number 3319

8 Messages

Digest #3319
1a
Re: Gurufocus Non US Listed Stocks by "Soemoe Win" soemoe.theinwin
2a
SMF and Excel 64 bit by rogerdiazbernal
2b
Re: SMF and Excel 64 bit by "Randy Harmelink" rharmelink
2c
Re: SMF and Excel 64 bit by "Brad Reel" reeldeal9090
2d
Re: SMF and Excel 64 bit by "Jim Ranum" amt2100
4b
Re: Extract Closing Price From Bloomberg by "Randy Harmelink" rharmelink

Messages

Mon Feb 9, 2015 12:06 pm (PST) . Posted by:

"Soemoe Win" soemoe.theinwin

works great - thanks!

On Monday, February 9, 2015 7:45 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  Try:

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/ownership/AAPL","h1",-1,"InstitutionalOwnership"))

On Mon, Feb 9, 2015 at 9:48 AM, soemoe.theinwin@... wrote:

Do you know how to pull in the figure or insitutional ownership into excel? eg here: http://www.gurufocus.com/ownership/AAPL# on the ownership tab its '63%'

#yiv0651725250 #yiv0651725250 -- #yiv0651725250ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0651725250 #yiv0651725250ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0651725250 #yiv0651725250ygrp-mkp #yiv0651725250hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0651725250 #yiv0651725250ygrp-mkp #yiv0651725250ads {margin-bottom:10px;}#yiv0651725250 #yiv0651725250ygrp-mkp .yiv0651725250ad {padding:0 0;}#yiv0651725250 #yiv0651725250ygrp-mkp .yiv0651725250ad p {margin:0;}#yiv0651725250 #yiv0651725250ygrp-mkp .yiv0651725250ad a {color:#0000ff;text-decoration:none;}#yiv0651725250 #yiv0651725250ygrp-sponsor #yiv0651725250ygrp-lc {font-family:Arial;}#yiv0651725250 #yiv0651725250ygrp-sponsor #yiv0651725250ygrp-lc #yiv0651725250hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0651725250 #yiv0651725250ygrp-sponsor #yiv0651725250ygrp-lc .yiv0651725250ad {margin-bottom:10px;padding:0 0;}#yiv0651725250 #yiv0651725250actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0651725250 #yiv0651725250activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0651725250 #yiv0651725250activity span {font-weight:700;}#yiv0651725250 #yiv0651725250activity span:first-child {text-transform:uppercase;}#yiv0651725250 #yiv0651725250activity span a {color:#5085b6;text-decoration:none;}#yiv0651725250 #yiv0651725250activity span span {color:#ff7900;}#yiv0651725250 #yiv0651725250activity span .yiv0651725250underline {text-decoration:underline;}#yiv0651725250 .yiv0651725250attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0651725250 .yiv0651725250attach div a {text-decoration:none;}#yiv0651725250 .yiv0651725250attach img {border:none;padding-right:5px;}#yiv0651725250 .yiv0651725250attach label {display:block;margin-bottom:5px;}#yiv0651725250 .yiv0651725250attach label a {text-decoration:none;}#yiv0651725250 blockquote {margin:0 0 0 4px;}#yiv0651725250 .yiv0651725250bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0651725250 .yiv0651725250bold a {text-decoration:none;}#yiv0651725250 dd.yiv0651725250last p a {font-family:Verdana;font-weight:700;}#yiv0651725250 dd.yiv0651725250last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0651725250 dd.yiv0651725250last p span.yiv0651725250yshortcuts {margin-right:0;}#yiv0651725250 div.yiv0651725250attach-table div div a {text-decoration:none;}#yiv0651725250 div.yiv0651725250attach-table {width:400px;}#yiv0651725250 div.yiv0651725250file-title a, #yiv0651725250 div.yiv0651725250file-title a:active, #yiv0651725250 div.yiv0651725250file-title a:hover, #yiv0651725250 div.yiv0651725250file-title a:visited {text-decoration:none;}#yiv0651725250 div.yiv0651725250photo-title a, #yiv0651725250 div.yiv0651725250photo-title a:active, #yiv0651725250 div.yiv0651725250photo-title a:hover, #yiv0651725250 div.yiv0651725250photo-title a:visited {text-decoration:none;}#yiv0651725250 div#yiv0651725250ygrp-mlmsg #yiv0651725250ygrp-msg p a span.yiv0651725250yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0651725250 .yiv0651725250green {color:#628c2a;}#yiv0651725250 .yiv0651725250MsoNormal {margin:0 0 0 0;}#yiv0651725250 o {font-size:0;}#yiv0651725250 #yiv0651725250photos div {float:left;width:72px;}#yiv0651725250 #yiv0651725250photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0651725250 #yiv0651725250photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0651725250 #yiv0651725250reco-category {font-size:77%;}#yiv0651725250 #yiv0651725250reco-desc {font-size:77%;}#yiv0651725250 .yiv0651725250replbq {margin:4px;}#yiv0651725250 #yiv0651725250ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0651725250 #yiv0651725250ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0651725250 #yiv0651725250ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0651725250 #yiv0651725250ygrp-mlmsg select, #yiv0651725250 input, #yiv0651725250 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0651725250 #yiv0651725250ygrp-mlmsg pre, #yiv0651725250 code {font:115% monospace;}#yiv0651725250 #yiv0651725250ygrp-mlmsg * {line-height:1.22em;}#yiv0651725250 #yiv0651725250ygrp-mlmsg #yiv0651725250logo {padding-bottom:10px;}#yiv0651725250 #yiv0651725250ygrp-msg p a {font-family:Verdana;}#yiv0651725250 #yiv0651725250ygrp-msg p#yiv0651725250attach-count span {color:#1E66AE;font-weight:700;}#yiv0651725250 #yiv0651725250ygrp-reco #yiv0651725250reco-head {color:#ff7900;font-weight:700;}#yiv0651725250 #yiv0651725250ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0651725250 #yiv0651725250ygrp-sponsor #yiv0651725250ov li a {font-size:130%;text-decoration:none;}#yiv0651725250 #yiv0651725250ygrp-sponsor #yiv0651725250ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0651725250 #yiv0651725250ygrp-sponsor #yiv0651725250ov ul {margin:0;padding:0 0 0 8px;}#yiv0651725250 #yiv0651725250ygrp-text {font-family:Georgia;}#yiv0651725250 #yiv0651725250ygrp-text p {margin:0 0 1em 0;}#yiv0651725250 #yiv0651725250ygrp-text tt {font-size:120%;}#yiv0651725250 #yiv0651725250ygrp-vital ul li:last-child {border-right:none !important;}#yiv0651725250

Mon Feb 9, 2015 1:45 pm (PST) . Posted by:

rogerdiazbernal

Randy:
SMF not working with 64 bit Excel?

Roger

Mon Feb 9, 2015 2:04 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but that's nearly a decade ahead of where I am EXCEL-wise. I have
zero experience there.

On Mon, Feb 9, 2015 at 2:45 PM, rogerdiazb@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> SMF not working with 64 bit Excel?
>
>

Mon Feb 9, 2015 2:16 pm (PST) . Posted by:

"Brad Reel" reeldeal9090

I'll check tonight when I am at home, but I am pretty sure I am using the
Excel 2013 64bit version without issue. I'll reply again if I am mistaken
and it is actually 32bit.

On Mon, Feb 9, 2015 at 4:04 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Sorry, but that's nearly a decade ahead of where I am EXCEL-wise. I have
> zero experience there.
>
> On Mon, Feb 9, 2015 at 2:45 PM, rogerdiazb@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> SMF not working with 64 bit Excel?
>>
>>
>
>

Mon Feb 9, 2015 3:36 pm (PST) . Posted by:

"Jim Ranum" amt2100

Been working fine for me for a couple years.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, February 09, 2015 4:45 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] SMF and Excel 64 bit

Randy:
SMF not working with 64 bit Excel?

Roger

Mon Feb 9, 2015 2:35 pm (PST) . Posted by:

jimmymc00

works great, thank you. Jim


=RCHGetYahooQuotes("MMM","p")

-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Mon, Feb 9, 2015 1:59 pm
Subject: Re: [smf_addin] RCHGetYahooHistory not getting prior close

You can use RCHGetYahooQuotes() to retrieve the previous day's closing price. For example:

=RCHGetYahooQuotes("MMM","p")

You should use that function for all current quotes type information. There are no elements defined for daily quotes type data, because RCHGetYahooQuotes() would be so much more efficient. It can get a number of data items on up to 200 ticker symbols with a single Internet access.

On Mon, Feb 9, 2015 at 10:15 AM, jmcatee133@... wrote:

Maybe you guys can help me. I'm a new user and haven't figured out how to pull "last closing price" from Yahoo. Other data is coming in fine but I don't see an element no. to use for this. I may need to do something with

RCHGetYahooHistory()

Mon Feb 9, 2015 6:20 pm (PST) . Posted by:

jimw1705


How can I use the RCHGetTableCell to extract the closing price from Bloomberg for this URL? I've read the documentation for the function and tried changing the index to 0 but it doesn't seem to get the pointer back to the beginning.


Is there documentation on the table output from Bloomberg and how to capture what Bloomberg is returning at this URL? The returned table must not include the header line with the price?


http://www.bloomberg.com/quote/fnhtmx:us http://www.bloomberg.com/quote/fnhtmx:us




This is the function call I tried, where FNHTMX:US is in cell A1.


=RCHGetTableCell("http://www.bloomberg.com/quote/"&A1,"1")


Any ideas?


Thanks. This is a great tool.


Jim

Mon Feb 9, 2015 6:34 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Without a search string, you'll just get the first table cell on the page.
To pick up the NAV table cell, you'd need:

=RCHGetTableCell("http://www.bloomberg.com/quote/"&A1,1,">NAV")

Unfortunately, that has other data in it:

(on 2015-02-09)10.03

So, you need to extract the price out:

=smfConvertData(smfStrExtr(RCHGetTableCell("http://www.bloomberg.com/quote/
"&A1,1,">NAV"),")","~"))

Or, if you want to pull it out of the top part of the web page, that one is
not in a table cell, so you need to use another function, and extract it
out of the resulting string as well:

=smfConvertData(smfStrExtr(smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"span",1,"tickersymbol"),">","<"))

It can also be extracted out of the JavaScript used to initialize the
streaming quotes:

=smfConvertData(smfStrExtr(smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"script",-1,"cache.set_object"),"last_price"":""",""""))

On Mon, Feb 9, 2015 at 6:43 PM, jimw@... wrote:

> How can I use the RCHGetTableCell to extract the closing price from
> Bloomberg for this URL? I've read the documentation for the function and
> tried changing the index to 0 but it doesn't seem to get the pointer back
> to the beginning.
>
>
> Is there documentation on the table output from Bloomberg and how to
> capture what Bloomberg is returning at this URL? The returned table must
> not include the header line with the price?
>
>
> http://www.bloomberg.com/quote/fnhtmx:us
>
>
> This is the function call I tried, where FNHTMX:US is in cell A1.
>
>
> =RCHGetTableCell("http://www.bloomberg.com/quote/"&A1,"1")
>
>
> Any ideas?
>
>
> Thanks. This is a great tool.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar