Sabtu, 25 Juni 2011

[smf_addin] Digest Number 1867

Messages In This Digest (7 Messages)

Messages

1a.

Getting quotes for indices when using "RCHGetYahooQuotes()"

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

Fri Jun 24, 2011 10:30 am (PDT)



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!!

Regards,
Wenxi

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

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

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

Fri Jun 24, 2011 10:42 am (PDT)



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 (2)
2a.

Re: FX Rates

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

Fri Jun 24, 2011 10:48 am (PDT)



All I can suggest is going to the website and playing with some of the
parameters, to see if there might be a problem there.

On Tue, Jun 21, 2011 at 5:32 AM, bushpilote <bushpilote@yahoo.ca> wrote:

>
> Having established that the set up is not the source of the problem, can
> you offer me some guidance on what to look for on their website in the
> context of the add-in that would help me make sense of it all?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
3a.

Re: Info about company

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

Fri Jun 24, 2011 10:54 am (PDT)



Check out this message and some of the replies:

http://finance.groups.yahoo.com/group/smf_addin/messages/13777?threaded=1&m=e&var=1&tidx=1
http://finance.groups.yahoo.com/group/smf_addin/message/14162

I have no idea what an "IR email" is -- some type of investor contact? If
so, I know no more than you. However, the other items can all come from the
Yahoo profile page mentioned in the above messages. Of course, the
difficulty is that different companies use different titles for their
executives.

On Tue, Jun 21, 2011 at 6:07 AM, JCHyjun <JCHyjun@aol.com> wrote:

>
> Is it possible (and how) download information about
> company WWW site
> company IR email
> company CEO name
> company Chair of Board name
> based on the company ticker?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4a.

Just want a simple start ...

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

Fri Jun 24, 2011 3:10 pm (PDT)



I use Excel 2002 and for years have used MSN Stock Quotes Add-in ... just for investment spreadsheets, and literally the only functions I use are Date of Last Sale, Last Price, and Percent Change for several stocks and mutual funds. I just update quotes at the end of the day. In the past week, MSN Stock Quotes has stopped working. Today I found this group, and my question is this: since I'm using Excel 2002, should I use your version 2.1, or should I download one of your "obsolete" 2.0 versions, and if so, which one? Thanks!

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

Re: Just want a simple start ...

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

Fri Jun 24, 2011 4:28 pm (PDT)



I would actually suggest you load the most recent version, 2.1.2011.04.03,
from the "Works in Progress" folder. You definitely do NOT want one of the
obsolete versions. They are really there just for reference/backup.

For what you used to do, an array-entered RCHGetYahooQuotes() function
should cover everything you need and get the data very quickly.

On Fri, Jun 24, 2011 at 1:05 PM, lk1_2000 <lk1_2000@yahoo.com> wrote:

> I use Excel 2002 and for years have used MSN Stock Quotes Add-in ... just
> for investment spreadsheets, and literally the only functions I use are Date
> of Last Sale, Last Price, and Percent Change for several stocks and mutual
> funds. I just update quotes at the end of the day. In the past week, MSN
> Stock Quotes has stopped working. Today I found this group, and my question
> is this: since I'm using Excel 2002, should I use your version 2.1, or
> should I download one of your "obsolete" 2.0 versions, and if so, which one?
> Thanks!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4c.

Re: Just want a simple start ...

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

Fri Jun 24, 2011 8:09 pm (PDT)



Thanks for the quick response! I will give it a shot tomorrow after I get home from work ... hopefully, I will never look back at msn.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I would actually suggest you load the most recent version, 2.1.2011.04.03,
> from the "Works in Progress" folder. You definitely do NOT want one of the
> obsolete versions. They are really there just for reference/backup.
>
> For what you used to do, an array-entered RCHGetYahooQuotes() function
> should cover everything you need and get the data very quickly.
>
> On Fri, Jun 24, 2011 at 1:05 PM, lk1_2000 <lk1_2000@...> wrote:
>
> > I use Excel 2002 and for years have used MSN Stock Quotes Add-in ... just
> > for investment spreadsheets, and literally the only functions I use are Date
> > of Last Sale, Last Price, and Percent Change for several stocks and mutual
> > funds. I just update quotes at the end of the day. In the past week, MSN
> > Stock Quotes has stopped working. Today I found this group, and my question
> > is this: since I'm using Excel 2002, should I use your version 2.1, or
> > should I download one of your "obsolete" 2.0 versions, and if so, which one?
> > Thanks!
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
Visit Your Group
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

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

Diposting oleh EXCEL FEED LEARNING di 03.47

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)