Messages In This Digest (3 Messages)

1a.: SMF-Template-10-Year-Charts.xls From: Stocktor_Faust
1b.: Re: SMF-Template-10-Year-Charts.xls From: Randy Harmelink

2a.: Re: Getting quotes for indices when using "RCHGetYahooQuotes()" From: Wenxi Drake

View All Topics | Create New Topic

Messages

1a.: SMF-Template-10-Year-Charts.xls

Posted by: "Stocktor_Faust" dcryman@yahoo.com Stocktor_Faust

Sun Jun 26, 2011 3:27 pm (PDT)

I've been using the great template SMF-Template-10-Year-Charts.xls provided on this site which was working fine a couple months ago, but now won't load any data after entering a ticker, displaying #NAME? in all the fields. I can continue to use RCHGetElementNumber-Template-AdvFN-Financial-Statements and most of the other templates. I'm wondering if there was some change in ADVFN that invalidated the old template, or if I'm causing the error somehow (but it didn't resolve after redownloading the template). Is anyone else having this problem and is there a way to get it working again?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: SMF-Template-10-Year-Charts.xls

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

Sun Jun 26, 2011 5:01 pm (PDT)

I just tried the workbook from the "Files" area of the group and it worked
fine for me. Two immediate possibilities come to mind:

http://finance.groups.yahoo.com/group/smf_addin/message/10464
http://finance.groups.yahoo.com/group/smf_addin/message/11346

...but it is curious your other AdvFN workbooks continue to work. That's a
puzzle to me.

Are you using an old version of the add-in?

On Sun, Jun 26, 2011 at 2:31 PM, Stocktor_Faust <dcryman@yahoo.com> wrote:

> I've been using the great template SMF-Template-10-Year-Charts.xls provided
> on this site which was working fine a couple months ago, but now won't load
> any data after entering a ticker, displaying #NAME? in all the fields. I can
> continue to use RCHGetElementNumber-Template-AdvFN-Financial-Statements and
> most of the other templates. I'm wondering if there was some change in ADVFN
> that invalidated the old template, or if I'm causing the error somehow (but
> it didn't resolve after redownloading the template). Is anyone else having
> this problem and is there a way to get it working again?
>

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

2a.: Re: Getting quotes for indices when using "RCHGetYahooQuotes()"

Posted by: "Wenxi Drake" wenxi.drake@yahoo.com wenxi.drake

Sun Jun 26, 2011 6:23 pm (PDT)

Hi Randy,

Thank you so much! I just found out that you have already answered same question about Dow Jones. Thanks for the patience.

About the ^HSI, the problem is solved for now.

Thanks again!!!

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Friday, June 24, 2011 12:42 PM
Subject: Re: [smf_addin] Getting quotes for indices when using "RCHGetYahooQuotes()"

Yahoo is no long licensed to carry DJIA quotes, see: http://help.yahoo.com/l/us/yahoo/finance/known_issues/fitaki-13.html

However, the work-around I use is to use ticker symbol INDU, which appears to work (for now, anyway).

I tried ^HSI and it worked fine for me. However, I do have troubles trying to enter "^HSI" into an EXCEL cell -- EXCEL wants to change it to "^HIS". But it isn't the add-in that is changing the ticker symbol, it's the EXCEL auto-correct function. For example, just type ^HSI into a cell and before hitting enter, type a blank -- for me, EXCEL immediately changes ^HSI to ^HIS as soon as I type the blank and indicate I am done with the word.

On Fri, Jun 24, 2011 at 10:27 AM, wenxi.drake <wenxi.drake@yahoo.com> wrote:

Hi Thanks for the add-in. It's very helpful. But when I'm using "RCHGetYahooQuotes()" to get the prices and other information for Dow Jones Index (^DJI) and Hang Seng Index (^HSI), it doesn't work very well. I hope I can get some help from you. Thank you in advance.
>
>When quoting (^DJI), there is no information showing up at all.
>When quoting (^HSI), it automatically changes to (^HIS), and nothing but the symbol shows.
>
>I'm pretty sure I followed all the instructions right. All the other index or company quotes work well except above two. Please help me with this. Thank you very much!!
>

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