Messages In This Digest (12 Messages)

1a.: info From: eatplantfoods
1b.: Re: info From: Randy Harmelink

2a.: Errors with RCHGetTableCell Function From: dennisharless
2b.: Re: Errors with RCHGetTableCell Function From: Randy Harmelink
2c.: Re: Errors with RCHGetTableCell Function From: dennisharless
2d.: Re: Errors with RCHGetTableCell Function From: Randy Harmelink

3a.: 10Y EPS from MSN table From: antonvanas1989
3b.: Re: 10Y EPS from MSN table From: Randy Harmelink
3c.: Re: 10Y EPS from MSN table From: govtsharpshooter
3d.: Re: 10Y EPS from MSN table From: Randy Harmelink

4a.: where to download smfForceRecalculation macro From: Yang
4b.: Re: where to download smfForceRecalculation macro From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.: info

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

Sat Jan 7, 2012 11:36 am (PST)

will this program work woith excel 2002. I get a macro error when it starts to load. thanks bill

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: info

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

Sat Jan 7, 2012 11:37 am (PST)

As far as I know, it does. More details?

On Sat, Jan 7, 2012 at 10:01 AM, eatplantfoods <eatplantfoods@yahoo.com>wrote:

> will this program work woith excel 2002. I get a macro error when it
> starts to load. thanks bill
>

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

2a.: Errors with RCHGetTableCell Function

Posted by: "dennisharless" dharless@hotmail.com dennisharless

Sat Jan 7, 2012 11:37 am (PST)

Hello all,

For the last 24 hours none of my function calls to get option prices are working. My function calls for stock prices are working just fine. Is anyone else seeing the same behavior? I have used the same function for over a year with no issues. I suspect the issue may be at the Yahoo end but just checking to see if a missed a parameter change.

Example function:
=RCHGetTableCell("http://finance.yahoo.com/q?s="AAPL120721P00320000,1,">Last")

When i enter Http://finance.yahoo.com/q?s="AAPL120721P00320000,1,">Last into the browser it returns the option price.

Any help or guidance is greatly appreciated.

Denny

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2b.: Re: Errors with RCHGetTableCell Function

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

Sat Jan 7, 2012 11:39 am (PST)

Your function below is invalid. However, when I use:

=RCHGetTableCell("http://finance.yahoo.com/q?s=AAPL120721P00320000
",1,">Last")

...it works fine here.

On Sat, Jan 7, 2012 at 10:58 AM, dennisharless <dharless@hotmail.com> wrote:

>
> For the last 24 hours none of my function calls to get option prices are
> working. My function calls for stock prices are working just fine. Is
> anyone else seeing the same behavior? I have used the same function for
> over a year with no issues. I suspect the issue may be at the Yahoo end
> but just checking to see if a missed a parameter change.
>
> Example function:
> =RCHGetTableCell("http://finance.yahoo.com/q?s=
> "AAPL120721P00320000,1,">Last")
>
> When i enter Http://finance.yahoo.com/q?s="AAPL120721P00320000,1,">Last
> into the browser it returns the option price.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2c.: Re: Errors with RCHGetTableCell Function

Posted by: "dennisharless" dharless@hotmail.com dennisharless

Sat Jan 7, 2012 2:06 pm (PST)

Thanks. For some reason i still can't get the function to resolve, even when i paste your exact text directly into Excel. The issue must be on my side but i can't see it.

I resolved the problem by switching to one of the GetOptionQuote functions and it is working fine now.

Thanks for the quick response - Go Lions!!
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Your function below is invalid. However, when I use:
>
> =RCHGetTableCell("http://finance.yahoo.com/q?s=AAPL120721P00320000
> ",1,">Last")
>
> ...it works fine here.
>
> On Sat, Jan 7, 2012 at 10:58 AM, dennisharless <dharless@...> wrote:
>
> >
> > For the last 24 hours none of my function calls to get option prices are
> > working. My function calls for stock prices are working just fine. Is
> > anyone else seeing the same behavior? I have used the same function for
> > over a year with no issues. I suspect the issue may be at the Yahoo end
> > but just checking to see if a missed a parameter change.
> >
> > Example function:
> > =RCHGetTableCell("http://finance.yahoo.com/q?s=
> > "AAPL120721P00320000,1,">Last")
> >
> > When i enter Http://finance.yahoo.com/q?s="AAPL120721P00320000,1,">Last
> > into the browser it returns the option price.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2d.: Re: Errors with RCHGetTableCell Function

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

Sat Jan 7, 2012 2:12 pm (PST)

Did you try running smfForceRecalculation (see "Links" area of the group
for more info)? It could be you retrieved a bad copy of the web page, or
got a timeout from Yahoo, and need to get a fresh copy of the page. You
also might want to make sure your Internet Options are set to always get a
fresh copy of the web page.

On Sat, Jan 7, 2012 at 3:06 PM, dennisharless <dharless@hotmail.com> wrote:

>
> Thanks. For some reason i still can't get the function to resolve, even
> when i paste your exact text directly into Excel. The issue must be on my
> side but i can't see it.
>
> I resolved the problem by switching to one of the GetOptionQuote functions
> and it is working fine now.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

3a.: 10Y EPS from MSN table

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

Sat Jan 7, 2012 1:17 pm (PST)

Hi Randy,
Im trying to get 10Y eps from data table from MSN web but can't get it fixed..

http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=10YearSummary&symbol=US%3aKO&stmtView=Ann

=RCHGetTableCell("http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker; ?????

Dont know if i use the correct parameter..

Anton

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3b.: Re: 10Y EPS from MSN table

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

Sat Jan 7, 2012 1:47 pm (PST)

Easy route:

=RCHGetElementNumber(Ticker, 333)

...elements 333 thru 342. Basically, that element is defined something like:

=RCHGetTableCell("
http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=10YearSummary&Symbol=KO",6,"Income
Statement - 10 Year Summary",">",,,2)

Just vary the 2 from 2 to 11.

On Sat, Jan 7, 2012 at 2:16 PM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

>
> Im trying to get 10Y eps from data table from MSN web but can't get it
> fixed..
>
>
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=10YearSummary&symbol=US%3aKO&stmtView=Ann
>
>
> =RCHGetTableCell("
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker;
> ?????
>
> Dont know if i use the correct parameter..
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3c.: Re: 10Y EPS from MSN table

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

Sun Jan 8, 2012 1:16 am (PST)

How would you find EPS on an annual basis i.e. for 2011, 2010, 2009...etc.

Thanks,
GSS

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Easy route:
>
> =RCHGetElementNumber(Ticker, 333)
>
> ...elements 333 thru 342. Basically, that element is defined something like:
>
> =RCHGetTableCell("
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=10YearSummary&Symbol=KO",6,"Income
> Statement - 10 Year Summary",">",,,2)
>
> Just vary the 2 from 2 to 11.
>
> On Sat, Jan 7, 2012 at 2:16 PM, antonvanas1989 <antonvanas1989@...>wrote:
>
> >
> > Im trying to get 10Y eps from data table from MSN web but can't get it
> > fixed..
> >
> >
> > http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=10YearSummary&symbol=US%3aKO&stmtView=Ann
> >
> >
> > =RCHGetTableCell("
> > http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker;
> > ?????
> >
> > Dont know if i use the correct parameter..
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3d.: Re: 10Y EPS from MSN table

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

Sun Jan 8, 2012 1:17 am (PST)

That's exactly what was being discussed -- see the previous messages in the
thread.

On Sun, Jan 8, 2012 at 2:13 AM, govtsharpshooter <govtsharpshooter@yahoo.com
> wrote:

> How would you find EPS on an annual basis i.e. for 2011, 2010, 2009...etc.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

4a.: where to download smfForceRecalculation macro

Posted by: "Yang" murfyang@yahoo.com.sg murfyang

Sat Jan 7, 2012 6:54 pm (PST)

hi randy, i have been searching thru the Attachements, work in progress, files, practically the whole place & i can't locate where to download the above. Is there something i am missing? thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.: Re: where to download smfForceRecalculation macro

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

Sat Jan 7, 2012 6:57 pm (PST)

It's already in the add-in. Check out the "Links" area of the group for
information on it.

The list of macros that EXCEL pops up with Alt+F8 doesn't list macros from
add-ins. An add-in isn't considered to be an "open workbook".

On Sat, Jan 7, 2012 at 7:22 PM, Yang <murfyang@yahoo.com.sg> wrote:

> hi randy, i have been searching thru the Attachements, work in progress,
> files, practically the whole place & i can't locate where to download the
> above. Is there something i am missing? thanks
>

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

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

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

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

Minggu, 08 Januari 2012

Messages In This Digest (12 Messages)

Messages

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

Sat Jan 7, 2012 11:36 am (PST)

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

Sat Jan 7, 2012 11:37 am (PST)

Posted by: "dennisharless" dharless@hotmail.com dennisharless

Sat Jan 7, 2012 11:37 am (PST)

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

Sat Jan 7, 2012 11:39 am (PST)

Posted by: "dennisharless" dharless@hotmail.com dennisharless

Sat Jan 7, 2012 2:06 pm (PST)

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

Sat Jan 7, 2012 2:12 pm (PST)

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

Sat Jan 7, 2012 1:17 pm (PST)

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

Sat Jan 7, 2012 1:47 pm (PST)

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

Sun Jan 8, 2012 1:16 am (PST)

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

Sun Jan 8, 2012 1:17 am (PST)

Posted by: "Yang" murfyang@yahoo.com.sg murfyang

Sat Jan 7, 2012 6:54 pm (PST)

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

Sat Jan 7, 2012 6:57 pm (PST)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me