Kamis, 17 November 2011

[smf_addin] Digest Number 2018

Messages In This Digest (8 Messages)

Messages

1a.

Re: Need Help with RCHCreateCOmment

Posted by: "GaryFera" gfera@shaw.ca   GaryFera

Wed Nov 16, 2011 7:08 am (PST)



Thanks, Randy. I surely thought that I had the URL of the actual image like I did for the Yahoo images. I will have to keep looking for a web site that will solve this prbolem for me.

Gary

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You need the URL of the image itself, not the web page the image is on. The
> chart image is dynamically created via a script, so there is no URL for the
> image. I don't see any way for the add-in to copy the image into EXCEL.
>
> On Tue, Nov 15, 2011 at 2:58 PM, GaryFera <gfera@...> wrote:
>
> > Randy, I use the RCHCreateComment command to bring in stock charts from
> > My.Yahoo.com and it works. I am trying to duplicate the chart extraction
> > approach with the MarketWatch web site because they have charts on options
> > which seem to almost impossible to find. But I am unable to get the command
> > (shown below) to work. I have signed up to the MarketWatch web site and am
> > properly logged in as far as I can tell.
> >
> > Any guidance would be appreciated.
> >
> > Gary
> >
> > =RCHCreateComment("
> > http://www.marketwatch.com/investing/stock/IBM/option/IBMA21123200000",99)
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2a.

Trouble with Get Table Cell formula

Posted by: "friedman_steve" friedman_steve@yahoo.com   friedman_steve

Wed Nov 16, 2011 9:02 am (PST)



I'm trying to get data from a table. It works for the header rows, but when i alter formula to grab data area, it doesn't spit back the data.

FORMULA I'M USING
=RCHGetTableCell("http://www.ivolatility.com/options.j?ticker=axas&R=0&top_lookup__is__sent=1&lhid=495358669",2,"price")

WHAT I GET
'); wr(d[237]); wr('

when i adjust formula for headers, it works.
when i have it look where the data is, i get things similar to what i showed above.

Any suggestions?
NOTE: The site requires login, but i already have computer set to recognize my login & it does get the table up (as proven by ability to grab the headers)

Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2b.

Re: Trouble with Get Table Cell formula

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Nov 16, 2011 9:30 am (PST)



That's because they create the tables via JavaScript. It's been discussed
here before.

I just did a search on the message archives, and think this best answers
your exact question:

http://finance.groups.yahoo.com/group/smf_addin/message/9476

For example:

=VALUE(smfStrExtr(RCHGetWebData("
http://www.ivolatility.com/options.j?ticker=axas
",smfStrExtr(RCHGetTableCell("
http://www.ivolatility.com/options.j?ticker=axas",1,"Index
Mean"),"wr(",")")),"='","'"))

...returns the 88.35% IV Index Mean current value.

On Wed, Nov 16, 2011 at 9:32 AM, friedman_steve <friedman_steve@yahoo.com>wrote:

> I'm trying to get data from a table. It works for the header rows, but
> when i alter formula to grab data area, it doesn't spit back the data.
>
> FORMULA I'M USING
> =RCHGetTableCell("
> http://www.ivolatility.com/options.j?ticker=axas&R=0&top_lookup__is__sent=1&lhid=495358669
> ",2,"price")
>
> WHAT I GET
> '); wr(d[237]); wr('
>
>
> when i adjust formula for headers, it works.
> when i have it look where the data is, i get things similar to what i
> showed above.
>
> Any suggestions?
> NOTE: The site requires login, but i already have computer set to
> recognize my login & it does get the table up (as proven by ability to grab
> the headers)
>
> Thanks.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2c.

Re: Trouble with Get Table Cell formula

Posted by: "friedman_steve" friedman_steve@yahoo.com   friedman_steve

Wed Nov 16, 2011 12:01 pm (PST)



Awesome. Truly amazing Randy.
I've got it working.
One followup though..... since it requires login... whenever i open excel I manually do a new web query, go to ivolatility website, login, and then hit cancel.
Then the formulas work.

Is there an easier way to do this?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That's because they create the tables via JavaScript. It's been discussed
> here before.
>
> I just did a search on the message archives, and think this best answers
> your exact question:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/9476
>
> For example:
>
> =VALUE(smfStrExtr(RCHGetWebData("
> http://www.ivolatility.com/options.j?ticker=axas
> ",smfStrExtr(RCHGetTableCell("
> http://www.ivolatility.com/options.j?ticker=axas",1,"Index
> Mean"),"wr(",")")),"='","'"))
>
> ...returns the 88.35% IV Index Mean current value.
>
> On Wed, Nov 16, 2011 at 9:32 AM, friedman_steve <friedman_steve@...>wrote:
>
> > I'm trying to get data from a table. It works for the header rows, but
> > when i alter formula to grab data area, it doesn't spit back the data.
> >
> > FORMULA I'M USING
> > =RCHGetTableCell("
> > http://www.ivolatility.com/options.j?ticker=axas&R=0&top_lookup__is__sent=1&lhid=495358669
> > ",2,"price")
> >
> > WHAT I GET
> > '); wr(d[237]); wr('
> >
> >
> > when i adjust formula for headers, it works.
> > when i have it look where the data is, i get things similar to what i
> > showed above.
> >
> > Any suggestions?
> > NOTE: The site requires login, but i already have computer set to
> > recognize my login & it does get the table up (as proven by ability to grab
> > the headers)
> >
> > Thanks.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2d.

Re: Trouble with Get Table Cell formula

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Nov 16, 2011 12:32 pm (PST)



Nothing the add-in can automate. You could write your own VBA code to use
the IE object to log into the page. The security cookie appears to expire
at the end of the session.

I left out security processing from the add-in on purpose. It can vary too
much from site to site, and I don't like the idea of people having their
user name and passwords exposed easily, since the add-in would need to
retrieve them from somewhere.

On Wed, Nov 16, 2011 at 1:01 PM, friedman_steve <friedman_steve@yahoo.com>wrote:

> One followup though..... since it requires login... whenever i open excel
> I manually do a new web query, go to ivolatility website, login, and then
> hit cancel.
> Then the formulas work.
>
> Is there an easier way to do this?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2e.

Re: Trouble with Get Table Cell formula

Posted by: "friedman_steve" friedman_steve@yahoo.com   friedman_steve

Wed Nov 16, 2011 1:40 pm (PST)



gotcha.
The thing worked great.... downloaded for a bunch of tickers. I noticed that when i put in formula for around 5 tickers or so at once, it worked.... when did bigger group (like 20) at once.... it would stop out (give ERROR for some of them).

I usually set on MANUAL calcuation and then update the formulas Find/Replace the = for =, to update them.

Thanks again.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Nothing the add-in can automate. You could write your own VBA code to use
> the IE object to log into the page. The security cookie appears to expire
> at the end of the session.
>
> I left out security processing from the add-in on purpose. It can vary too
> much from site to site, and I don't like the idea of people having their
> user name and passwords exposed easily, since the add-in would need to
> retrieve them from somewhere.
>
> On Wed, Nov 16, 2011 at 1:01 PM, friedman_steve <friedman_steve@...>wrote:
>
> > One followup though..... since it requires login... whenever i open excel
> > I manually do a new web query, go to ivolatility website, login, and then
> > hit cancel.
> > Then the formulas work.
> >
> > Is there an easier way to do this?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2f.

Re: Trouble with Get Table Cell formula

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Nov 16, 2011 1:54 pm (PST)



Hmmm. I just tried that formula with all 30 of the DJIA stocks and they all
worked fine for me -- I just cut and paste the 30 symbols under my example
of AXAS (using a cell reference for the ticker symbol) and then copied the
formula down. And watched. One by one, they all recalculated OK with a
value.

Additional items off the same web page shouldn't matter, because it should
only retrieve the web page a single time for all of the extractions from
the same URL.

On Wed, Nov 16, 2011 at 2:40 PM, friedman_steve <friedman_steve@yahoo.com>wrote:

> I noticed that when i put in formula for around 5 tickers or so at once,
> it worked.... when did bigger group (like 20) at once.... it would stop out
> (give ERROR for some of them).
>
> I usually set on MANUAL calcuation and then update the formulas
> Find/Replace the = for =, to update them.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3a.

Re: Free Cash Flow per Share

Posted by: "investor952" investor952@yahoo.com   investor952

Wed Nov 16, 2011 6:20 pm (PST)



Funny..I was just looking for a source of free cash flow also...for NRGY also...which I have been taking a bath on. What is wrong with that dog? From your numbers below, the fcf isn't nearly enough to pay the dividend. What are they paying the dividend from?

--- In smf_addin@yahoogroups.com, Ron Spruell <hashky@...> wrote:
>
> Does anyone know of a reliable source of Free Cash Flow per share?  I am interested in MLPs and REITs that depend on FCF/Share.
>
> An example is NRGY (from ValueLine 9/9/2011 for the year 2011):
>
> Cash Flow per Unit    1.55
> Earnings per Unit        0.50
> Dist. Decl'd per Unit   2.82
> Capital Spending per Unit     0.90
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 02.17

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)