Messages In This Digest (9 Messages)

1a.: Re: Retrieving Yahoo Option Data From: Bob Farkaly
1b.: Re: Retrieving Yahoo Option Data From: Randy Harmelink

2a.: 10-Y Financial Data From: li.dong99
2b.: Re: 10-Y Financial Data From: Randy Harmelink

3a.: How do you reinstall the add in? From: liquorishallsorts
3b.: Re: How do you reinstall the add in? From: Randy Harmelink

4a.: List of NYSE and S & P 500 stock symbols From: cesarleitao
4b.: Re: List of NYSE and S & P 500 stock symbols From: Randy Harmelink
4c.: Re: List of NYSE and S & P 500 stock symbols From: sudhir agarwal

View All Topics | Create New Topic

Messages

1a.: Re: Retrieving Yahoo Option Data

Posted by: "Bob Farkaly" rfarkaly@san.rr.com rfarkaly

Thu Mar 22, 2012 7:49 am (PDT)

This is the response to =RCHGetElementNumber("Version")

Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program Files\SMF Add-In; 1)

Bob

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: 21 March, 2012 6:23 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Retrieving Yahoo Option Data

Other than the mention of the two sessions, I would have thought it was that you're using an older version of the add-in. What do you get with:

=RCHGetElementNumber("Version")

On Wed, Mar 21, 2012 at 5:34 PM, Bob Farkaly <rfarkaly@san.rr.com> wrote:

Sorry for the bandwidth. I thought I had this nailed because your examples worked and I was able to take advantage of several of the documented parameters. But now I am having the problem that plagued me earlier and was part of the reason for my post. When I use the "=RCH" functions, they work as expected. Using the "=smf" functions, the only response I get is "#NAME". I didn't do anything between my two sessions on Excel today, so I am at a loss to understand what is happening. Have you seen this behavior before?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
1b.: Re: Retrieving Yahoo Option Data

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

Thu Mar 22, 2012 9:02 am (PDT)

Then the smf* functions should work, unless you're spelling them
incorrectly.

On Thu, Mar 22, 2012 at 7:48 AM, Bob Farkaly <rfarkaly@san.rr.com> wrote:

>
> This is the response to =RCHGetElementNumber("Version")****
>
> ** **
>
> Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program
> Files\SMF Add-In; 1)****
>
> Bob
>

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

2a.: 10-Y Financial Data

Posted by: "li.dong99" dodoflying@gmail.com li.dong99

Thu Mar 22, 2012 9:01 am (PDT)

Hi,

Is there any way to get 10 year financial data (yearly/quarterly) ?

Thanks in advance!

Don

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.: Re: 10-Y Financial Data

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

Thu Mar 22, 2012 9:03 am (PDT)

Check out the AdvFN elements and templates.

On Thu, Mar 22, 2012 at 6:54 AM, li.dong99 <dodoflying@gmail.com> wrote:

>
> Is there any way to get 10 year financial data (yearly/quarterly) ?
>

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

3a.: How do you reinstall the add in?

Posted by: "liquorishallsorts" liquorishallsorts@yahoo.co.uk liquorishallsorts

Thu Mar 22, 2012 9:11 am (PDT)

I successfully installed the add in (in Excel 2007) but it has now stopped working. When I re-open the spreadsheet I get a message saying Excel found unreadable content, and then that it was able to open the file by removing the following:

Removed Feature: External formula reference from /xl/externalLinks/externalLink1.xml part (Cached values from external formula reference)
Removed Records: Formula from /xl/worksheets/sheet1.xml part
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)

If I input =RCHGetYahooQuotes("ABF.L",l1,"uk") in a cell in a new spreadsheet, then after closing and reopening it, it is replaced with ='C:\Users\Myusername\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\M9633UGU\RCH_Stock_Market_Functions[1].xla'!rchgetyahooquotes("abf.l",L1,"uk") and the cell is empty.

I think the add in may have got corrupted (by deleting temporary internet files maybe?) but I can't see how to remove it to re-install it.

Any help appreciated.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.: Re: How do you reinstall the add in?

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

Thu Mar 22, 2012 9:25 am (PDT)

Try this process, which has cleared up some issues for others in the past:

1. Go to the add-in manager and uncheck the add-in.
2. Exit EXCEL (which should remove any references to the add-in from the
registry)
3. Restart EXCEL
4. Go to the add-in manager and put the add-in back into the list
5. Exit EXCEL (to save the new settings)
6. Restart EXCEL

On Thu, Mar 22, 2012 at 9:09 AM, liquorishallsorts <
liquorishallsorts@yahoo.co.uk> wrote:

> I successfully installed the add in (in Excel 2007) but it has now stopped
> working. When I re-open the spreadsheet I get a message saying Excel found
> unreadable content, and then that it was able to open the file by removing
> the following:
>
> Removed Feature: External formula reference from
> /xl/externalLinks/externalLink1.xml part (Cached values from external
> formula reference)
> Removed Records: Formula from /xl/worksheets/sheet1.xml part
> Removed Records: Formula from /xl/calcChain.xml part (Calculation
> properties)
>
> If I input =RCHGetYahooQuotes("ABF.L",l1,"uk") in a cell in a new
> spreadsheet, then after closing and reopening it, it is replaced with
> ='C:\Users\Myusername\AppData\Local\Microsoft\Windows\Temporary Internet
> Files\Content.IE5\M9633UGU\RCH_Stock_Market_Functions[1].xla'!rchgetyahooquotes("abf.l",L1,"uk")
> and the cell is empty.
>
> I think the add in may have got corrupted (by deleting temporary internet
> files maybe?) but I can't see how to remove it to re-install it.
>
> Any help appreciated.
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

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

4a.: List of NYSE and S & P 500 stock symbols

Posted by: "cesarleitao" cesarleitao@uol.com.br cesarleitao

Thu Mar 22, 2012 1:41 pm (PDT)

Hi,

Would anyone provide me with lists of NYSE and S & P 500 stock symbols?

Thanks a lot.

Kind regards

Cesar

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
4b.: Re: List of NYSE and S & P 500 stock symbols

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

Thu Mar 22, 2012 1:43 pm (PDT)

Should be able to generate it yourself from the FinViz screener:

http://finviz.com/screener.ashx

On Thu, Mar 22, 2012 at 11:52 AM, cesarleitao <cesarleitao@uol.com.br>wrote:

>
> Would anyone provide me with lists of NYSE and S & P 500 stock symbols?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
4c.: Re: List of NYSE and S & P 500 stock symbols

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Thu Mar 22, 2012 1:51 pm (PDT)

[Attachment(s) from sudhir agarwal included below]

Here you go.
Hope it helps...

On Thu, Mar 22, 2012 at 2:52 PM, cesarleitao <cesarleitao@uol.com.br> wrote:

> **
>
>
>
> Hi,
>
> Would anyone provide me with lists of NYSE and S & P 500 stock symbols?
>
> Thanks a lot.
>
> Kind regards
>
> Cesar
>
>
>

Attachment(s) from sudhir agarwal

1 of 1 File(s)

List of NYSE and S&P companies.xlsx

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

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

EXCEL FEED

Jumat, 23 Maret 2012

[smf_addin] Digest Number 2154[1 Attachment]

Messages In This Digest (9 Messages)

Messages

Re: Retrieving Yahoo Option Data

Posted by: "Bob Farkaly" rfarkaly@san.rr.com rfarkaly

Thu Mar 22, 2012 7:49 am (PDT)

Re: Retrieving Yahoo Option Data

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

Thu Mar 22, 2012 9:02 am (PDT)

10-Y Financial Data

Posted by: "li.dong99" dodoflying@gmail.com li.dong99

Thu Mar 22, 2012 9:01 am (PDT)

Re: 10-Y Financial Data

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

Thu Mar 22, 2012 9:03 am (PDT)

How do you reinstall the add in?

Posted by: "liquorishallsorts" liquorishallsorts@yahoo.co.uk liquorishallsorts

Thu Mar 22, 2012 9:11 am (PDT)

Re: How do you reinstall the add in?

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

Thu Mar 22, 2012 9:25 am (PDT)

List of NYSE and S & P 500 stock symbols

Posted by: "cesarleitao" cesarleitao@uol.com.br cesarleitao

Thu Mar 22, 2012 1:41 pm (PDT)

Re: List of NYSE and S & P 500 stock symbols

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

Thu Mar 22, 2012 1:43 pm (PDT)

Re: List of NYSE and S & P 500 stock symbols

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Thu Mar 22, 2012 1:51 pm (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me