[smf_addin] Digest Number 3096

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #3096

1a

Re: Short interest from Nasdaq by fredwwright

1b

Re: Short interest from Nasdaq by "Randy Harmelink" rharmelink

2a

put "share outstanding" data on WSJ by sri.yanto

2b

Re: put "share outstanding" data on WSJ by "Randy Harmelink" rharmelink

2c

Re: put "share outstanding" data on WSJ by sri.yanto

Messages

1a

Re: Short interest from Nasdaq

Wed Jun 18, 2014 2:32 pm (PDT) . Posted by:

fredwwright

Randy,

Thanks for the great example of pulling the nasdaq short interest history table. Is there any way to automatically transpose what it brings back into a row rather than a column - I want to create a cell with a sparkline graph of the total shares short over the past year?


Fred

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

1b

Re: Short interest from Nasdaq

Wed Jun 18, 2014 2:41 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Then you need to use the pDim1 and pDim2 parameters. They default to the
size of the array-entered range. But since you want to transpose them, that
range isn't the right size. So:

=TRANSPOSE(RCHGetHTMLTable("http://www.nasdaq.com/symbol/mmm/short-interest
",">Settlement",-1,"",1,,25,4))

On Wed, Jun 18, 2014 at 2:32 PM, fredwwright@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks for the great example of pulling the nasdaq short interest history
> table. Is there any way to automatically transpose what it brings back
> into a row rather than a column - I want to create a cell with a sparkline
> graph of the total shares short over the past year?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

2a

put "share outstanding" data on WSJ

Thu Jun 19, 2014 12:28 am (PDT) . Posted by:

sri.yanto

dear randy,


i had a problem, i try to put outstanding data.


i had modify your current formula


smfConvertData(smfStrExtr(smfGetTagContent("http://quotes.wsj.com/ID/XIDX/"&B1,"span",1,"Key Stock Data","P/E Ratio"),"~","<"))

to get PE


to


smfConvertData(smfStrExtr(smfGetTagContent("http://quotes.wsj.com/ID/XIDX/"&B1,"span",1,"Key Stock Data","Shares Outstanding"),"~","<"))



to tried get ots share..


but it, result "blank"


do you have any idea...


thanks after all bro..

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2b

Re: put "share outstanding" data on WSJ

Thu Jun 19, 2014 1:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sample ticker symbol please? When I use MMM, I get a page not found error.

On Thu, Jun 19, 2014 at 12:28 AM, sri.yanto@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> i had a problem, i try to put outstanding data.
>
> i had modify your current formula
>
> smfConvertData(smfStrExtr(smfGetTagContent("http://quotes.wsj.com/ID/XIDX/"&B1,"span",1,"Key
> Stock Data","P/E Ratio"),"~","<"))
>
> to get PE
>
> to
>
> smfConvertData(smfStrExtr(smfGetTagContent("http://quotes.wsj.com/ID/XIDX/"&B1,"span",1,"Key
> Stock Data","Shares Outstanding"),"~","<"))
>
> to tried get ots share..
>
> but it, result "blank"
>
> do you have any idea...
>
> thanks after all bro..
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2c

Re: put "share outstanding" data on WSJ

Thu Jun 19, 2014 1:30 am (PDT) . Posted by:

sri.yanto

hoho ..sori..bro, i forgot it

=smfConvertData(smfStrExtr(smfGetTagContent("http://quotes.wsj.com/ID/XIDX/ASII","span",1,"Key Stock Data","Shares Outstanding"),"~","<"))



ASII the ticker bro


http://quotes.wsj.com/ID/XIDX/ASII http://quotes.wsj.com/ID/XIDX/ASII



Tks bro

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

Visit Your Group

• New Members 7

• Privacy • Unsubscribe • Terms of Use