Sabtu, 02 Januari 2016

[smf_addin] Digest Number 3596

10 Messages

Digest #3596

Messages

Thu Dec 31, 2015 7:24 am (PST) . Posted by:

midi_guitar

Randy - Thanks for the reply.


I've been successfully using Google Sheets to extract the index bid/ask from individual option quotes:


=index ( importhtml("http://finance.yahoo.com/q?s=RUT160115P01200000","table",0),3,2)


is there as SMF that will do a simple table read? It seems GetHTMLTable and GetTableCell both need to look for something first. Am I missing something simple?


If not, does anyone know of an Excel add-in function matching Google's importhtml()?


Thanks! Happy 2016!






Thu Dec 31, 2015 7:36 am (PST) . Posted by:

"Randy Harmelink" rharmelink

This should get the whole table:

=RCHGetHTMLTable("http://finance.yahoo.com/q?s=RUT160115P01200000","Prev
Close:",-1)

You don't NEED to search for something first. If you only want the second
table on the web page, you could do:

=RCHGetHTMLTable("http://finance.yahoo.com/q?s=RUT160115P01200000
","",2,"",2)

But I would think the easiest way to get bid and ask would be:

=RCHGetTableCell("http://finance.yahoo.com/q?s=RUT160115P01200000",1,"Bid:")
=RCHGetTableCell("http://finance.yahoo.com/q?s=RUT160115P01200000",1,"Ask:")

On Thu, Dec 31, 2015 at 8:24 AM, midi_guitar@... wrote:

>
> Randy - Thanks for the reply.
>
> I've been successfully using Google Sheets to extract the index bid/ask
> from individual option quotes:
>
> =index ( importhtml("http://finance.yahoo.com/q?s=RUT160115P01200000
> ","table",0),3,2)
>
> is there as SMF that will do a simple table read? It seems GetHTMLTable
> and GetTableCell both need to look for something first. Am I missing
> something simple?
>
> If not, does anyone know of an Excel add-in function matching Google's
> importhtml()?
>
> Thanks! Happy 2016!
>

Thu Dec 31, 2015 11:06 pm (PST) . Posted by:

mmpasha

Hi All,

I had clicked on the link to download the "SMF-Addin-Combined-Documentation-010212.pdf" but the link doesn't include the file. Is it possible to upload again or can someone email a copy if they have it?

It would be much appreciated!

Thanks for your help!

-Muzaffer

Fri Jan 1, 2016 10:15 am (PST) . Posted by:

cgrablew

Randy,


I apologize if this has already been asked but is Zack's Recommendations (13873) no longer available or is it somewhere else?


Thanks,


Chuck Grablewski
cgrablew@gmail.com

Fri Jan 1, 2016 1:10 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Zacks Rank and Recommendation are no longer available to non-subscribers...

On Fri, Jan 1, 2016 at 11:15 AM, cgrablew@... wrote:

> I apologize if this has already been asked but is Zack's
> Recommendations (13873) no longer available or is it somewhere else?
>
>

Fri Jan 1, 2016 3:09 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I don't want to have an element for "Last Price" because then it's what
most people would use, instead of RCHGetYahooQuotes(). And
RCHGetYahooQuotes() is so much more efficient...

But you can do it yourself, with:

=smfGetTagContent("http://www.barchart.com/technicals/stocks/MMM
","span",-1,"id=""dtaLast""",,,,1)

On Fri, Jan 1, 2016 at 3:33 PM, mff3429@... wrote:

>
> would this be possible?
>

Fri Jan 1, 2016 6:17 pm (PST) . Posted by:

mff2805

thx,
i was getting other info from that same page, so i was thinking there be no extra overhead/time/etc to get that number too.

hey, happy new year. i've really grown to like the addin over these years.
mike

Fri Jan 1, 2016 6:12 pm (PST) . Posted by:

mff2805

any ideas why not?
this ticker is one that's in my database and my auto-update always chokes on thsi ticker. so i have to manually skip it. not a big deal, but a lingering question.
thx,
mike


Fri Jan 1, 2016 6:34 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Hard to answer without more details. Which templates? Which formulas? Which
web sites?

STZ is an ETF, so stock-only or mutual fund-only web page extractions won't
work for it.

On Fri, Jan 1, 2016 at 7:12 PM, mff3429@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> any ideas why not?
> this ticker is one that's in my database and my auto-update always chokes
> on thsi ticker. so i have to manually skip it. not a big deal, but a
> lingering question.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.12

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)