[smf_addin] Digest Number 3694

EXCEL Stock Market Functions Add-in Group

6 Messages

Digest #3694

1a

RCHGetYahooQuotes Function：it display N/A for shanghai exchang by cjbcmp

1b

Re: [smf_addin] RCHGetYahooQuotes Function：it display N/A for by "Randy Harmelink" rharmelink

1c

Re: [smf_addin] RCHGetYahooQuotes Function：it disp      lay N/A for by cjbcmp

1d

Re: [smf_addin] RCHGetYahooQuotes Function：it disp lay N/A for by "Randy Harmelink" rharmelink

2a

Re: VBA code for RCHGetElementNumbers 4681,4684,4690 and 4705 by samil_beret

2b

Re: VBA code for RCHGetElementNumbers 4681,4684,4690 and 4705 by "Randy Harmelink" rharmelink

Messages

1a

RCHGetYahooQuotes Function：it display N/A for shanghai exchang

Sun May 8, 2016 2:54 am (PDT) . Posted by:

cjbcmp

=RCHGetYahooQuotes("600000.SS","b") display N/A，600000.SS is a stock ticker for shanghai exchange in china.


=RCHGetYahooQuotes("161033.SZ","b") can work，161033.SZ is a stock ticker for shengzheng exchange in china.


OS ： windows 8.1
excel version: excel 2013.


what is the problem?


thank you for your all do.

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

1b

Re: [smf_addin] RCHGetYahooQuotes Function：it display N/A for

Sun May 8, 2016 2:56 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but "N/A" is what Yahoo is returning for ​600000.SS...

On Sat, May 7, 2016 at 9:43 PM, cjbcmp@
​...wrote:

> =RCHGetYahooQuotes("600000.SS","b") display N/A，
> ​​
> 600000.SS is a stock ticker for shanghai exchange in china.
>
> =RCHGetYahooQuotes("161033.SZ","b") can work，161033.SZ is a stock ticker
> for shengzheng exchange in china.
>
> OS ： windows 8.1
>
> excel version: excel 2013.
>
> what is the problem?
>
> thank you for your all do.
>

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

1c

Re: [smf_addin] RCHGetYahooQuotes Function：it disp      lay N/A for

Sun May 8, 2016 9:17 am (PDT) . Posted by:

cjbcmp

There are two stock exchanges in china. They are Shanghai Stock Exchange and Shengzheng Stock Exchange .

=RCHGetYahooQuotes("000001.SZ","b") can work，000001.SZ is a stock ticker for Shengzheng stock exchange in china.


Shenzhen Development Bank Co., Ltd. http://finance.yahoo.com/q?s=000001.SZ



http://finance.yahoo.com/q?s=000001.SZ

Shenzhen Development Bank Co., Ltd. http://finance.yahoo.com/q?s=000001.SZ View the basic 000001.SZ stock chart on Yahoo! Finance. Change the date range, chart type and compare against other companies.



View on finance.yahoo.com http://finance.yahoo.com/q?s=000001.SZ
Preview by Yahoo






600000.SS is a stock ticker for Shanghai stock exchange in china. we can also get the data at finance.yahoo.com. such as: finance.yahoo.com/q?s=600000.SS

HOW can we support the stock ticker for Shanghai stock exchange?

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

1d

Re: [smf_addin] RCHGetYahooQuotes Function：it disp lay N/A for

Sun May 8, 2016 10:43 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You'd need to contact Yahoo.

On the http://finance.yahoo.com/q?s=600000.SS web page, you'll find a link
that says "Download Data (delayed)". Try that link and you'll get all "N/A"
values. Tell Yahoo that's what that link is giving you and ask them to
please make the data available....

On Sun, May 8, 2016 at 9:17 AM, cjbcmp@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> There are two stock exchanges in china. They are Shanghai Stock Exchange
> and Shengzheng Stock Exchange .
>
> =RCHGetYahooQuotes("000001.SZ","b") can work，000001.SZ is a stock ticker
> for Shengzheng stock exchange in china.
>
>
> Shenzhen Development Bank Co., Ltd.
> <http://finance.yahoo.com/q?s=000001.SZ>
> [image: image] <http://finance.yahoo.com/q?s=000001.SZ>
> Shenzhen Development Bank Co., Ltd.
> <http://finance.yahoo.com/q?s=000001.SZ>
> View the basic 000001.SZ stock chart on Yahoo! Finance. Change the date
> range, chart type and compare against other companies.
> View on finance.yahoo.com <http://finance.yahoo.com/q?s=000001.SZ>
> Preview by Yahoo
>
>
>
> 600000.SS is a stock ticker for Shanghai stock exchange in china. we can
> also get the data at finance.yahoo.com. such as:
> finance.yahoo.com/q?s=600000.SS
>
>
>
> HOW can we support the stock ticker for Shanghai stock exchange?
>
>

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

2a

Re: VBA code for RCHGetElementNumbers 4681,4684,4690 and 4705

Sun May 8, 2016 7:40 am (PDT) . Posted by:

samil_beret

Thanks Randy.

When you say "just add the SMF Library as a reference item for the VBA project", I am not sure what you mean. How do I accomplish that?.


I am not well versed in VBA, but I am learning.


Thanks for your help.


Samil Beret

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

2b

Re: VBA code for RCHGetElementNumbers 4681,4684,4690 and 4705

Sun May 8, 2016 10:39 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Use menu option > Tools > References in the VBA project and check the box
in front of the "RCH_Stock_Market_Functions" reference library.

On Sun, May 8, 2016 at 7:40 AM, sberet@
​...wrote:

>
> When you say "just add the SMF Library as a reference item for the VBA
> project", I am not sure what you mean. How do I accomplish that?.
>
> I am not well versed in VBA, but I am learning.
>
>
>

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 22

• Privacy • Unsubscribe • Terms of Use