I just got $3.25, did an update and got $3.20.

How are you updating them? You need to use the smfForceRecalculation macro.
If that still doesn't update, you probably have IE caching pages. You'll
need to change your Internet Options to make sure it always gets a new copy
of the web page.

More details on both of these topics are in the LINKS area of the group.

On Fri, Oct 11, 2013 at 11:51 AM, <dbltapp00@yahoo.com> wrote:

>
> This works, including using b for bid and l for last: =smfGetOptionQuotes(
> "AAPL Oct 2013 $500 Call", "a"). Problem is, the values returned are wrong.
> Getting $2.70 to $2.80 values that never change when I update them, should
> be getting $3.20s.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (14) . Top ^

1b

Re: =smfGetYahooOptionQuote() and =smfGetOptionQuotes()

Fri Oct 11, 2013 12:04 pm (PDT) . Posted by:

dbltapp00

This gives me around $1.05:
=smfGetYahooOptionQuote( "MCP","C",DATE(2013,10,19),6,"l")

This generates an error:
=smfGetYahooOptionQuote( "MCP","C",DATE(2013,10,19),7.5,"l")

Maybe single digit issue?

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

Details/example please. This works fine here:

=smfGetOptionQuotes("SPY 10/11 2013 $170.50 Call","b")

On Fri, Oct 11, 2013 at 10:53 AM, <dbltapp00@... mailto:dbltapp00@...> wrote:

Never mind, I hadn't seen the 2.1 versions. Plugged it in and it's working for most input values. The only problem is when the strike price isn't a whole number ($7.5). Then it throws an error.

Reply to sender . Reply to group . Reply via Web Post . All Messages (14) . Top ^

1c

Re: =smfGetYahooOptionQuote() and =smfGetOptionQuotes()

Fri Oct 11, 2013 12:32 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Of course you get an error -- Yahoo has no $7.50 Call option for that stock
for 10/19...

http://finance.yahoo.com/q/op?s=MCP

On Fri, Oct 11, 2013 at 12:04 PM, <dbltapp00@yahoo.com> wrote:

>
> This gives me around $1.05:
> =smfGetYahooOptionQuote( "MCP","C",DATE(2013,10,19),6,"l")
>
> This generates an error:
> =smfGetYahooOptionQuote( "MCP","C",DATE(2013,10,19),7.5,"l")
>
> Maybe single digit issue?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (14) . Top ^

1d

Re: =smfGetYahooOptionQuote() and =smfGetOptionQuotes()

Fri Oct 11, 2013 12:38 pm (PDT) . Posted by:

dbltapp00

It was IE caching. Works fine now save for the non-whole number issue. Thanks so much for your work on these functions.

---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:

I just got $3.25, did an update and got $3.20.

How are you updating them? You need to use the smfForceRecalculation macro. If that still doesn't update, you probably have IE caching pages. You'll need to change your Internet Options to make sure it always gets a new copy of the web page.

More details on both of these topics are in the LINKS area of the group.

On Fri, Oct 11, 2013 at 11:51 AM, <dbltapp00@... mailto:dbltapp00@...> wrote:

This works, including using b for bid and l for last: =smfGetOptionQuotes( "AAPL Oct 2013 $500 Call", "a"). Problem is, the values returned are wrong. Getting $2.70 to $2.80 values that never change when I update them, should be getting $3.20s.

Reply to sender . Reply to group . Reply via Web Post . All Messages (14) . Top ^

1e

Re: =smfGetYahooOptionQuote() and =smfGetOptionQuotes()

Fri Oct 11, 2013 10:42 pm (PDT) . Posted by:

aronnisch

When you live in "," delimited world, then it is a feature. Sometimes ago Randy H. answered this questeion, and it will never work.

If i am to late with my input, please apologise.

best wishes
Axel

---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:

Never mind, I hadn't seen the 2.1 versions. Plugged it in and it's working for most input values. The only problem is when the strike price isn't a whole number ($7.5). Then it throws an error.

---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:

Either the most recent official release in the FILES area of the group, or the beta version (in the "Works in Progress" folder).
On Fri, Oct 11, 2013 at 7:58 AM, <dbltapp00@... mailto:dbltapp00@...> wrote:
Uhm... is there a version where they do?
---In smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:

Those functions don't exist in version 2.0 of the add-in...
On Thu, Oct 10, 2013 at 5:55 PM, <dbltapp00@... mailto:dbltapp00@...> wrote:

I'd really appreciate anyone telling me why these don't work in Excel 2007:

=smfGetOptionQuotes( "AMT Oct 2013 $75 Call", "a",1)

=smfGetYahooOptionQuote( "AMT","C",DATE(2013,10,19),75,"l")

They both return #NAME?. Using smf version 2.0j

Reply to sender . Reply to group . Reply via Web Post . All Messages (14) . Top ^

2a

Re: Currency for Yahoo data

Fri Oct 11, 2013 7:19 pm (PDT) . Posted by:

lawrence.leesh

Hi Randy

This formula you gave me is now returning a blank cell. Is there any change I should make to it?

=smfstrExtr(RCHGetTableCell("http://sg.finance.yahoo.com/q/is?s=EB5.SI&annual http://sg.finance.yahoo.com/q/is?s=EB5.SI&annual",0,"Currency in")," in ",".")

thanks

LL

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

I don't see anything related to currency on that page.

On Thu, Aug 1, 2013 at 5:37 AM, lawrence.leesh <lawrence.leesh@... mailto:lawrence.leesh@...> wrote:

May I trouble you to give me the formula for advfn currency for say AAPL financials? http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

2b

Re: Currency for Yahoo data

Fri Oct 11, 2013 7:25 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you. It works fine here...

On Fri, Oct 11, 2013 at 7:19 PM, <lawrence.leesh@yahoo.com> wrote:

> This formula you gave me is now returning a blank cell. Is there any
> change I should make to it?
>
> =smfstrExtr(RCHGetTableCell("
> http://sg.finance.yahoo.com/q/is?s=EB5.SI&annual",0,"Currency in")," in
> ",".")
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

2c

Re: Currency for Yahoo data

Fri Oct 11, 2013 7:35 pm (PDT) . Posted by:

lawrence.leesh

Not sure what the problem is. Could you help me to try another formula to return SGD from this page?

http://sg.finance.yahoo.com/q/hp?s=N4E.SI

thanks

LL

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

Not sure what to tell you. It works fine here...

On Fri, Oct 11, 2013 at 7:19 PM, <lawrence.leesh@... mailto:lawrence.leesh@...> wrote:
This formula you gave me is now returning a blank cell. Is there any change I should make to it?

=smfstrExtr(RCHGetTableCell("http://sg.finance.yahoo.com/q/is?s=EB5.SI&annual http://sg.finance.yahoo.com/q/is?s=EB5.SI&annual",0,"Currency in")," in ",".")

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

2d

Re: Currency for Yahoo data

Fri Oct 11, 2013 7:39 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfstrExtr(smfGetTagContent("http://sg.finance.yahoo.com/q/hp?s=N4E.SI","p",-1,"Currency
in")," in ",".")

On Fri, Oct 11, 2013 at 7:35 PM, <lawrence.leesh@yahoo.com> wrote:

>
> Not sure what the problem is. Could you help me to try another formula to
> return SGD from this page?
>
> http://sg.finance.yahoo.com/q/hp?s=N4E.SI
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

2e

Re: Currency for Yahoo data

Fri Oct 11, 2013 7:41 pm (PDT) . Posted by:

lawrence.leesh

Thanks Randy. This works.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

Try:

=smfstrExtr(smfGetTagContent("http://sg.finance.yahoo.com/q/hp?s=N4E.SI http://sg.finance.yahoo.com/q/hp?s=N4E.SI","p",-1,"Currency in")," in ",".")

On Fri, Oct 11, 2013 at 7:35 PM, <lawrence.leesh@... mailto:lawrence.leesh@...> wrote:

Not sure what the problem is. Could you help me to try another formula to return SGD from this page?
http://sg.finance.yahoo.com/q/hp?s=N4E.SI http://sg.finance.yahoo.com/q/hp?s=N4E.SI

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

2f

Re: Currency for Yahoo data

Fri Oct 11, 2013 8:40 pm (PDT) . Posted by:

lawrence.leesh

When I put in this formula

=RCHGetTableCell("http:// investing.money.msn.com/ investments/earnings- estimates?symbol=aapl http://investing.money.msn.com/investments/earnings-estimates?symbol=aapl",0,"
Financial Data in")

I get 15.6

How do I change the formule to get
FInancial Data in US Dollars

thanks

LL

---In smf_addin@yahoogroups.com, <lawrence.leesh@...> wrote:

Thanks Randy. This works.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

Try:

=smfstrExtr(smfGetTagContent("http://sg.finance.yahoo.com/q/hp?s=N4E.SI http://sg.finance.yahoo.com/q/hp?s=N4E.SI","p",-1,"Currency in")," in ",".")

On Fri, Oct 11, 2013 at 7:35 PM, <lawrence.leesh@... mailto:lawrence.leesh@...> wrote:

Not sure what the problem is. Could you help me to try another formula to return SGD from this page?
http://sg.finance.yahoo.com/q/hp?s=N4E.SI http://sg.finance.yahoo.com/q/hp?s=N4E.SI

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

2g

Re: Currency for Yahoo data

Fri Oct 11, 2013 8:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's not in a table cell. Try:

=smfGetTagContent("
http://investing.money.msn.com/investments/earnings-estimates?symbol=aapl",
"span",-1,"Financial data in")

On Fri, Oct 11, 2013 at 8:40 PM, <lawrence.leesh@yahoo.com> wrote:

>
> When I put in this formula
>
> =RCHGetTableCell("http:// investing.money.msn.com/ investments/earnings-
> estimates?symbol=aapl<http://investing.money.msn.com/investments/earnings-estimates?symbol=aapl>
> ",0,"
> Financial Data in")
>
> I get 15.6
>
> How do I change the formule to get
> FInancial Data in US Dollars
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

2h

Re: Currency for Yahoo data

Fri Oct 11, 2013 9:14 pm (PDT) . Posted by:

lawrence.leesh

Thanks Randy.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

It's not in a table cell. Try:

=smfGetTagContent("http://investing.money.msn.com/investments/earnings-estimates?symbol=aapl http://investing.money.msn.com/investments/earnings-estimates?symbol=aapl",
"span",-1,"Financial data in")

On Fri, Oct 11, 2013 at 8:40 PM, <lawrence.leesh@... mailto:lawrence.leesh@...> wrote:

When I put in this formula
=RCHGetTableCell("http:// investing.money.msn.com/ investments/earnings- estimates?symbol=aapl http://investing.money.msn.com/investments/earnings-estimates?symbol=aapl",0,"
Financial Data in")

I get 15.6

How do I change the formule to get
FInancial Data in US Dollars