Rabu, 26 November 2014

[smf_addin] Digest Number 3251

9 Messages

Digest #3251

Messages

Tue Nov 25, 2014 5:30 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The add-in is meant for ad hoc data retrieval, not for building of
databases. Because it saves a web page internally before extracting data,
it has a limit of 1000 web pages per "session".

On Tue, Nov 25, 2014 at 2:42 AM, tzewei_79@...wrote:

> Starting from line 143 column D,F,G,H,K,L and M are showing "Error" all
> of a sudden. The formula are constant. I confirmed the website that they
> pointed to and the data to be extracted are there. Not sure what happened.
>
>

Tue Nov 25, 2014 7:30 am (PST) . Posted by:

"73fvkjr73" frederickknightjr

http://szeben.ro/qghoclk/buwrwkffynnutlktwydqgprgwkbpjaomq.qkxyovctngglhgpeqdigk

73fvkjr73@sbcglobal.net
11/25/2014 4:30:30 PM

Tue Nov 25, 2014 8:10 am (PST) . Posted by:

adam_sommers

I also restored the old version. It pulls individual stock option prices, but I can no longer get ETF option prices to pull. I've got SPY, GLD, XLU, XLK, XLB, XLI, XLV, XLF, XLE, and XLY all not working. Any ideas?

Tue Nov 25, 2014 8:59 am (PST) . Posted by:

adam_sommers

I can get them to work in a blank sheet, but not on my sheet, where they are part of a group of 100 tickers I'm pulling quotes for. Is there a limit?

Adam

Tue Nov 25, 2014 10:21 am (PST) . Posted by:

"Randy Harmelink" rharmelink

There is a limit -- 1000 web pages per session. It shouldn't matter which
workbooks the formulas are in though.

Is your new workbook using the exact same formulas? Is it possible Yahoo
didn't have options pages up for those equities this morning? They've had
missing options before.

On Tue, Nov 25, 2014 at 9:59 AM, adam@...wrote:

>
> I can get them to work in a blank sheet, but not on my sheet, where they
> are part of a group of 100 tickers I'm pulling quotes for. Is there a limit?
>

Tue Nov 25, 2014 5:19 pm (PST) . Posted by:

tzewei_79

Hi,


I'm trying to get the Payout percentage for STX.


=RCHGetTableCell("http://financials.morningstar.com/ratios/r.html?t=STX",2,"Payout Ratio %")



I always get "error". If I change to other sites, it is ok. I made sure I did not have 1000 calculated cells. Did I miss out something?


Tue Nov 25, 2014 8:24 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The add-in extracts data from the source code of a web page. That web page
is dynamically generated, so there is no data within the source code of the
web page itself. The payout ratio is pulled in from this static web page on
MorningStar:

http://financials.morningstar.com/financials/getFinancePart.html?&callback=?&t=STX

Note that it's a lot of raw data, so you can't use RCHGetTableCell() or
smfGetTagContent(). Instead, you need to parse it out at the basic level
with something like:

=smfConvertData(smfstrExtr(RCHGetWebData("
http://financials.morningstar.com/financials/getFinancePart.html?&callback=?&t=STX","""Y0
i91\""",20),">","<"))

The "Y0" in that string is for the first year of the table. The "i91" is
the identifier for the "Payout Ratio" data line. You'd need to examine the
source code of the web page to get the identifier value.

On Tue, Nov 25, 2014 at 6:19 PM, tzewei_79@... wrote:

>
> I'm trying to get the Payout percentage for STX.
>
> =RCHGetTableCell("http://financials.morningstar.com/ratios/r.html?t=STX
> ",2,"Payout Ratio %")
>
> I always get "error". If I change to other sites, it is ok. I made sure I
> did not have 1000 calculated cells. Did I miss out something?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.55

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)