Senin, 02 Februari 2015

[smf_addin] Digest Number 3310

15 Messages

Digest #3310
2a
2b
Re: Barchart option chain by "Randy Harmelink" rharmelink
3a
4a
Values Changing by bob_15861586
4b
Re: Values Changing by "Randy Harmelink" rharmelink
4c

Messages

Mon Feb 2, 2015 6:28 am (PST) . Posted by:

panda317

=RCHGetTableCell("http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t= http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t="&D2,6,"class=""row_lbl""")

returns 'Error' for all but 3 symbols (VEDIX, VEDTX, & WHOSX).

Also, it no longer formats as 'percent'

Mon Feb 2, 2015 6:50 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I can't investigate those it didn't work on if you tell me those it did
work on. I just tried a few more examples, and they worked fine for me. Did
you check out the URLs for those that didn't work?

It doesn't format as a percent because of the way it's presented on the web
page. You can always divide by 100.

On Mon, Feb 2, 2015 at 7:28 AM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> =RCHGetTableCell("
> http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=
> "&D2,6,"class=""row_lbl""")
>
> returns 'Error&#39; for all but 3 symbols (VEDIX, VEDTX, & WHOSX).
>
> Also, it no longer formats as 'percent&#39;
>

Mon Feb 2, 2015 6:54 am (PST) . Posted by:

panda317

Didn't work for;

BCZAX BCZIX EQCHX GVPIX GVPSX PEDIX PEDPX RYABX RYADX RYCGX RYGBX
Link on spreadsheet for all (even the 3 that worked) opens this page;

http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t= http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=

Mon Feb 2, 2015 7:00 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I just looked at the first two. They haven't been around a year.

The URL would need to have the ticker symbol appended, like it does in the
formula.

On Mon, Feb 2, 2015 at 7:54 AM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Didn't work for;
>
> BCZAX BCZIX EQCHX GVPIX GVPSX PEDIX PEDPX RYABX RYADX RYCGX
> RYGBX
> Link on spreadsheet for all (even the 3 that worked) opens this page;
>
>
> http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=
>
>

Mon Feb 2, 2015 7:02 am (PST) . Posted by:

panda317

Well, actually the numbers are correct, but no longer adds the '%' sign.

20.37 http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t= 26.66 http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t= 40.59 http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=

Mon Feb 2, 2015 7:06 am (PST) . Posted by:

panda317

OK, I clicked the url in the spreadsheet, and then appended the ticker to the url and got this page;

http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=eqchx http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=eqchx

http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=eqchx http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=eqchx Managed Futures:Top Quartile 2nd Quartile 3rd Quartile Bottom Quartile



View on performance.morningstar.com http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=eqchx
Preview by Yahoo





the data is there, but isn't returned on the spreadsheet

Mon Feb 2, 2015 7:08 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I got 40.59 returned here...

On Mon, Feb 2, 2015 at 8:06 AM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> OK, I clicked the url in the spreadsheet, and then appended the ticker to
> the url and got this page;
>
>
> http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=eqchx
>
> http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=eqchx
> Managed Futures:Top Quartile 2nd Quartile 3rd Quartile Bottom Quartile
> View on performance.morningstar.com
> <http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=eqchx>
> Preview by Yahoo
>
> the data is there, but isn't returned on the spreadsheet
>

Mon Feb 2, 2015 7:16 am (PST) . Posted by:

panda317

OK, well using MS Office Pro 2010 on WinPro 7 it does not work.

Yahoo works, mostly, so I'll stick with that.

Thanks, anyway!

Pat

Mon Feb 2, 2015 11:42 am (PST) . Posted by:

g3m1n1980

Randy,

I have some difficulity pulling the option chain.

For example Im trying just to grab the strike price (A1 is where I have the ticker input

=RCHGetTableCell("http://www.barchart.com/options/stocks/="&A1&"",1,">Strike",,,,-1,"</table",,"--")

TWTR | Stock Options, volatility and greeks for Twitter Inc http://www.barchart.com/options/stocks/TWTR


http://www.barchart.com/options/stocks/TWTR

TWTR | Stock Options, volatility and greeks for Twitt... http://www.barchart.com/options/stocks/TWTR Stock Option prices for Twitter Inc - TWTR. Stock option quotes, option chains, greeks and volatility.



View on www.barchart.com http://www.barchart.com/options/stocks/TWTR
Preview by Yahoo



Please see what I have wrong

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

"Randy Harmelink" rharmelink

Well, the function invocation you're using is saying to look for the
">Strike" header line of the table and then go back a row. Since ">Strike"
is in the first row of the table, that gives you an "Error" result because
it can't find anything there. Also, your generated URL is wrong -- you've
added an extraneous "=" before the ticker symbol.

What are you trying to pull? The first strike price available? If so:

=RCHGetTableCell("http://www.barchart.com/options/stocks/
"&B2,1,">Strike",,,,1)

On Mon, Feb 2, 2015 at 12:41 PM, xxjaysonxx@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I have some difficulity pulling the option chain.
>
> For example Im trying just to grab the strike price (A1 is where I have
> the ticker input
>
> =RCHGetTableCell("http://www.barchart.com/options/stocks/=
> "&A1&"",1,">Strike",,,,-1,"</table",,"--")
>
> Please see what I have wrong
>
>

Mon Feb 2, 2015 1:22 pm (PST) . Posted by:

"malli Boggala" malli.boggala

Hi Randy,
I'm trying to access data form Gurufocus using below formula, bust cell is empty, not pulling any data. RCHGetTableCell("http://www.gurufocus.com/stock/"&A5&"",1,"PFCF")
But seems some other data working fine like RCHGetTableCell("http://www.gurufocus.com/stock/"&A5&"",1,"ROIC")
would you pls. help me.Thanks in advance.
Regards,Malli

Mon Feb 2, 2015 1:47 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

That's because you're using a bad search string. The function will key off
the first occurrence of that string it finds. In the case of "PFCF", there
are nearly a dozen before that table entry, because it's used as part of
HTML tag processing. That's why I usually use the ">" trick, but it can
ONLY be used if the web page is written that way. It may be necessary to
look at the source code of the web page to come up with good search
strings. For example, this works:

=RCHGetTableCell("http://www.gurufocus.com/stock/"&B4,1,">PFCF")

Have you looked that the GuruFocus model/template that another add-in user
has uploaded to the "Uploads by Forum Members" folder of the FILES area of
the Yahoo group? You could save yourself a lot of work...

On Mon, Feb 2, 2015 at 12:42 PM, malli Boggala malli.boggala@...wrote:

>
> I'm trying to access data form Gurufocus using below formula, bust cell is
> empty, not pulling any data.
> RCHGetTableCell("http://www.gurufocus.com/stock/"&A5&"",1,"PFCF")
>
> But seems some other data working fine like RCHGetTableCell("
> http://www.gurufocus.com/stock/"&A5&"",1,"ROIC")
>
> would you pls. help me.
> Thanks in advance.
>
>

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

bob_15861586



I use the SMF macros to get the value of my stocks. However, sometimes it does. In one case, I was seeing it switch between today's closing value and yesterday's closing value. The stock in question was Exxon Mobil whose symbol is XOM. I wold not expect the value of a stock to change much after 4:15. I am thinking Yahoo is having problems. Is anybody having any similar issues?


The call I use to get the value of the stock is:
=RCHGetYahooQuotes( "XOM", "l1",,NOW() )


Bob

Mon Feb 2, 2015 4:08 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I'm not seeing it now. Perhaps they had a server that wasn't updated, so
whenever a request came from that server, it reverted back to the prior
day's close? Hard to say...

On Mon, Feb 2, 2015 at 3:22 PM, bob_15861586@... wrote:

> I use the SMF macros to get the value of my stocks. However, sometimes it
> does. In one case, I was seeing it switch between today's closing value and
> yesterday's closing value. The stock in question was Exxon Mobil whose
> symbol is XOM. I wold not expect the value of a stock to change much
> after 4:15. I am thinking Yahoo is having problems. Is anybody having any
> similar issues?
>
> The call I use to get the value of the stock is:
>
> =RCHGetYahooQuotes( "XOM", "l1",,NOW() )
>
>

Mon Feb 2, 2015 4:28 pm (PST) . Posted by:

tyoungnj

I have been seeing this for the last few days on several spreadsheets that use RCHGetYahooQuotes. The values should automatically update each time I open the file, but since last Wed I've found that I get differing values. Sometimes they're correct, sometimes it's the previous day's closing, other times it's something random. I've checked against the Yahoo Finance site and the data on the site is correct, so I'm not sure how/why this is happening. Nine times out of 10 it is fixed by just re-entering the stock symbol in the correct cell of the spreadsheet - I use the formula =RCHGetYahooQuotes([cell reference], "l1"). But I've got hundred of stocks I track so that is getting a little tedious. If anyone figures out a fix please post.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar