[smf_addin] Digest Number 2983

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #2983

1a

Re: working through smfGetOptionQuotes-Examples-Table-Building-Exerc by "Randy Harmelink" rharmelink

2a

Unable to Get Results Certain Stocks which is available via Yahoo Fi by solar127

2b

Re: Unable to Get Results Certain Stocks which is available via Yaho by "Randy Harmelink" rharmelink

2c

Re: Unable to Get Results Certain Stocks which is available via Yaho by solar127

Messages

1a

Re: working through smfGetOptionQuotes-Examples-Table-Building-Exerc

Tue Feb 25, 2014 9:05 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I get the invalid source if I have "OX " as my source. Note the trialing
blank. But if I use "OX" without the extra blank it works fine.

I'm hoping that's your problem?

On Tue, Feb 25, 2014 at 9:57 PM, <gryemann@yahoo.com> wrote:

>
> I am working through smfGetOptionQuotes-Examples-Table-Building-Exercise.
> I have:B2: SPYB3: OXB5: =smfGetOptionExpiry() which evaluates to
> 2014-03-22
>
> C9:C18 =smfGetOptionStrikes($B$2,$B$5,"Call&quot;,$B$3,1). C9 evaluates to
> "Invalid data source: OX" and c10:c18 appear as empty.
>
> B20: =smfGetOptionStrikes($B$2,$B$5,"Call&quot;,$B$3,,2,1). It evaluates to
> "Invalid data source"
>
> D8:F8 =smfGetOptionQuotes("",D$7,1). These evaluate to "Last Price",
> "Bid Price", "Ask Price"
>
> D9:F18 =smfGetOptionQuotes($C9,D$7,,$B$3) appear as empty.
>
> I am using excel 2010.
>
> I am guessing the "OX" in B3 is in error. What can I try instead.
>
> Any other ideas from the above?
>
>

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

2a

Unable to Get Results Certain Stocks which is available via Yahoo Fi

Tue Feb 25, 2014 11:12 pm (PST) . Posted by:

solar127

Hi All,

I have trouble when getting some specific quote for some stock, for e.g.
8002.HK
If I use some standard API http://finance.yahoo.com/d/quotes.csv?s=8002 http://finance.yahoo.com/d/quotes.csv?s=AAPL.HK&f=snbaopl1
I would be able to get the results.

However, if I use the smfPricesByDates("8002.HK", "2014/02/10"), I was not able to get any results.
Such situation only apply to certain stocks number, e.g. 700.HK will not have such problem.

Any idea on the cause?

Note: Such situation also occur if I use http://table.finance.yahoo.com/table.csv?s=8002.HK
Many thanks.

Best Regards,
Richard

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

2b

Re: Unable to Get Results Certain Stocks which is available via Yaho

Tue Feb 25, 2014 11:16 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It's because Yahoo doesn't have any historical quotes on 8002.HK:

http://finance.yahoo.com/q/hp?s=8002.HK

I don't see any historical quotes for 700.HK, and I get the same #N/A
result.

On Wed, Feb 26, 2014 at 12:08 AM, <tangrichard@hotmail.com> wrote:

>
>
> I have trouble when getting some specific quote for some stock, for e.g.
>
> 8002.HK
>
> If I use some standard API http://finance.yahoo.com/d/quotes.csv?s=8002<http://finance.yahoo.com/d/quotes.csv?s=AAPL>
> .HK&f=snbaopl1
>
> I would be able to get the results.
>
> However, if I use the smfPricesByDates("8002.HK", "2014/02/10"), I was
> not able to get any results.
>
> Such situation only apply to certain stocks number, e.g. 700.HK will not
> have such problem.
>
> Any idea on the cause?
>
> Note: Such situation also occur if I use http://table.finance.yahoo.com
> /table.csv?s=8002.HK
>
>

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

2c

Re: Unable to Get Results Certain Stocks which is available via Yaho

Tue Feb 25, 2014 11:23 pm (PST) . Posted by:

solar127

Thanks for the response :) Then I guess I should seek another source for HKEx Growth Enterprise Market/HKEx GEM.
For the #N/A, the number should 0700.HK, historial price is there.

Thanks :)

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

Visit Your Group

• New Members 33

• Privacy • Unsubscribe • Terms of Use