Sabtu, 29 Oktober 2011

[smf_addin] Digest Number 2000

Messages In This Digest (8 Messages)

Messages

1a.

Re: Get data for over 3000 companies? -  Follow up

Posted by: "Pete" petekoch@yahoo.com   petekoch

Fri Oct 28, 2011 6:47 am (PDT)



Here's a link to Microsoft's Ribbon Guide. It's for Office 2007, but any differences from 2010 should be minor.

http://office.microsoft.com/assistance/asstvid.aspx?assetid=XT101493291033&vwidth=1044&vheight=788&type=flash&CTT=11&Origin=HA101491511033&app=EXCEL&ver=12

--- In smf_addin@yahoogroups.com, Ron Spruell <hashky@...> wrote:
>
> Randy -
>
> I bought and installed Excel 2010.  That solved the problems.  I am lost in the new "Ribbon" interface, but time should cure my confusion.  I will be working on this spreadsheet as soon as I get used to the interface.
>
> Ron 
>
>
>
>
> >________________________________
> >From: Randy Harmelink <rharmelink@...>
> >To: smf_addin@yahoogroups.com
> >Sent: Friday, October 14, 2011 11:42 PM
> >Subject: Re: [smf_addin] Get data for over 3000 companies?
> >
> >
> > 
> >I think it's an EXCEL 2003 problem. I just got rid of the function and kept just:
> >
> >="http://finviz.com/export.ashx?v=151&T="&smfJoin(A8:A56,",")&"&c="&smfJoin(B6:C6,",")
> >
> >That string is exactly 255 bytes long. I doubt that is a coincidence. My bet would be that if that string gets longer than 255 bytes, EXCEL 2003 has a problem. Try these two functions:
> >
> >=LEN("http://finviz.com/export.ashx?v=151&T="&smfJoin(A8:A56,",")&"&c="&smfJoin(B6:C6,","))
> >=LEN("http://finviz.com/export.ashx?v=151&T="&smfJoin(A8:A66,",")&"&c="&smfJoin(B6:C6,","))
> >
> >...and see if you get an error on the second LEN() function.
> >
> >If that is the problem, the easiest solution would be to drop the "t=" parameter and just get a list of all ticker symbols. But that will make your VLOOKUP() processing a little slower.
> >
> >
> >On Fri, Oct 14, 2011 at 9:27 PM, Ron Spruell <hashky@...> wrote:
> >
> >
> >>
> >>I am using the beta version. 
> >>Stock Market Functions add-in, Version 2.1.2011.04.03 (C:\Program Files\SMF Add-In; 1)
> >>
> >>
> >>I installed the UDF sfJoin and tried it.  No change.  47 Tickers is the working limit.  After that everything turns to #Value!
> >>
> >>
> >>Here are 3 files.  The first is a pdf with a Ticker input Range of A8:A56 with values.  The second is a pdf with a Ticker input Range of A8:A57 which has the #VALUE! output.  The third is the xls file.
> >>
> >>
> >>Where should I go from here?
> >>
> >
> >
> >
> >
>

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

Re: Addin to import charts to excel sheet

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Fri Oct 28, 2011 8:40 am (PDT)



Randy, Is there a yahoo code for the forward (4.05) dividend or must I use an external query?

Don Guillett
SalesAid Software
dguillett1@gmail.com
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2b.

Re: Addin to import charts to excel sheet

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

Fri Oct 28, 2011 9:28 am (PDT)



I don't know of Yahoo codes for the forward looking dividend or yield. They
need to be retrieved on a "per ticker" basis.

On Fri, Oct 28, 2011 at 8:40 AM, dguillett1 <dguillett1@gmail.com> wrote:

>
> Randy, Is there a yahoo code for the forward (4.05) dividend or must I
> use an external query?
>
> [image: image]
>
> [image: image]
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2c.

Re: Addin to import charts to excel sheet

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Fri Oct 28, 2011 11:15 am (PDT)



Thanks, I thought as much.

Don Guillett
SalesAid Software
dguillett1@gmail.com

From: Randy Harmelink
Sent: Friday, October 28, 2011 11:27 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Addin to import charts to excel sheet

I don't know of Yahoo codes for the forward looking dividend or yield. They need to be retrieved on a "per ticker" basis.

On Fri, Oct 28, 2011 at 8:40 AM, dguillett1 <dguillett1@gmail.com> wrote:

Randy, Is there a yahoo code for the forward (4.05) dividend or must I use an external query?

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

Re: IPO Date information

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Fri Oct 28, 2011 11:37 am (PDT)



Randy -

Thanks for correcting my equations.

------------------------------------
=RCHGetYahooHistory($A$6,YEAR(Main!$G$2-4565),MONTH(Main!$G$2-4565),DAY(Main!$G$2-4565),YEAR(Main!$G$2),MONTH(Main!$G$2),DAY(Main!$G$2),"w","DA",,,1)

$A$6 = Ticker Symbol
Main!$G$2 = Date of Previous Close (or you could use TODAY())
For Date of the Previous Close I use =RCHGetYahooHistory("SPY",,,,,,,,,0)
----------------------------------------------------------
After seeing your answer, I realized I was wrong.  Do you have to last 2 inputs, 600 and 1, documented some place?

Ron

>________________________________
>From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, October 27, 2011 10:55 AM
>Subject: Re: [smf_addin] IPO Date information
>
>
> 
>I think this would get you the date of the first trading date from Yahoo's historical quotes:
>
>=RCHGetYahooHistory("MMM",,,,,,,"m","D",0,,1,600,1)
>
>
>On Thu, Oct 27, 2011 at 7:43 AM, curls07 <agc11d@gmail.com> wrote:
>
>
>>I'm doing some IPO research and I'm looking to get the first day of trading from some companies that don't easily list their IPO date. Does anyone have any ideas on how I could turn a url like this into my own element; http://finance.yahoo.com/q/hp?s=HSOL&d=9&e=27&f=2011&g=d&a=11&b=20&c=2006&z=66&y=1188
>>
>>so that i can extract the first date of trading as the IPO date.
>>
>>or Does anyone have any better ideas on how to get the job done?
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3b.

Re: IPO Date information

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

Fri Oct 28, 2011 11:42 am (PDT)



Not really. I originally added the pDim1 and pDim2 parameters to
array-entered functions so that they could be used as VBA subroutines by
other VBA routines -- otherwise, the size of the returned array is
determined by the range the function is entered into.

Basically, they're the number of rows and columns of data that the function
should return.

On Fri, Oct 28, 2011 at 11:37 AM, Ron Spruell <hashky@yahoo.com> wrote:

>
> After seeing your answer, I realized I was wrong. Do you have to last 2
> inputs, 600 and 1, documented some place?
>
> ------------------------------
> *From:* Randy Harmelink <rharmelink@gmail.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Thursday, October 27, 2011 10:55 AM
> *Subject:* Re: [smf_addin] IPO Date information
>
>
> I think this would get you the date of the first trading date from Yahoo's
> historical quotes:
>
> =RCHGetYahooHistory("MMM",,,,,,,"m","D",0,,1,600,1)
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4a.

Re: RCH_STOCK_MARKET_FUNCTIONS.XLA ISSUES

Posted by: "Sylvester" sylvesterstanleyjr@yahoo.com   sylvesterstanleyjr

Fri Oct 28, 2011 3:56 pm (PDT)



The =RCHGetElementNumber(Version) worked.

When I open my worksheet A message comes up and say they are some cells they are one or more cells that cannot be updated.

After updated the formula for P/E Ratios on my worksheet and hit enter, it just comes up error. The ticker symbol I am using is msft. I think their is something wrong with the link to msn. Is there any other way I can get PE Ratios for FY1 thru FY10. Thank you for all your help.

--- In smf_addin@yahoogroups.com, "scott" <scott_grant2@...> wrote:
>
>
> The version has always worked for me, it did this time as well..
>
> I get a circular reference warning on the second one.."RCHGetElementNumber"
> i didnt have any stock symbol in the cell A1
> i just pasted =RCHGetElementNumber($A$1,167)
>
> thanks for trying to help me..
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Check the "Links" area of the group for info on #NAME? errors.
> >
> > Basically, you'll get the path on the formula whenever EXCEL cannot resolve
> > the links. If it does find the add-in, then it will consider the link
> > resolved and remove the path. Otherwise, you have to handle them manually.
> > It's an EXCEL thing.
> >
> > In a new worksheet, what do you get from:
> >
> > =RCHGetElementNumber("Version")
> >
> > If that works, you do have the add-in installed. What error message did you
> > get from:
> >
> > =RCHGetElementNumber($A$1,167)
> >
> > If just "Error", what ticker symbol did you have in cell A1? If "Undefined",
> > there's another "Links" item you need to look at.
> >
> > On Wed, Oct 12, 2011 at 6:19 PM, Sylvester <sylvesterstanleyjr@>wrote:
> >
> > > When I first login in to excel I get workbook prompt saying that this
> > > workbook contains links to other data sources and if I would like to update
> > > the link. Then I hit the update tab and then I get a prompt saying this
> > > workbook contains one or two links that cannot be updated. I then click the
> > > edit link tab and this is what i get "RCH_STOCK_MARKET_FUNCTIIONS.XLA A
> > > ERROR SOURCE NOT FOUND"
> > >
> > > If I just don't update, I can go to a cell displaying "#NAME?" and it will
> > > have an array formula like "='C:\Program Files\SMF
> > > Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber($A$1,167)
> > >
> > > If I edit the cell to remove everything between the "=" and "xla"
> > > =RCHGetElementNumber($A$1,167) and hit enter I get a error message in the
> > > cell.
> > >
> > > So why is having 'C:\Program Files\SMF
> > > Add_In\RCH_Stock_Market_Functions.xla'!
> > > a problem?
> > >
> > > I think I have things installed correctly. I'm running Windows 7 ultimate
> > > with Excel 2010
> > >
> >
>

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

Re: RCH_STOCK_MARKET_FUNCTIONS.XLA ISSUES

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

Fri Oct 28, 2011 5:26 pm (PDT)



Check the "Links" area of the group for information on resolving links.

Without the details of what functions you're using to get "Error" I can only
guess -- if RCHGetElementNumber(), you probably just need the new
smf-elements-1.txt file from the "Works in Progress" folder. MSN changed
their website structure earlier this year.

On Fri, Oct 28, 2011 at 3:55 PM, Sylvester <sylvesterstanleyjr@yahoo.com>wrote:

> The =RCHGetElementNumber(Version) worked.
>
> When I open my worksheet A message comes up and say they are some cells
> they are one or more cells that cannot be updated.
>
> After updated the formula for P/E Ratios on my worksheet and hit enter, it
> just comes up error. The ticker symbol I am using is msft. I think their
> is something wrong with the link to msn. Is there any other way I can get
> PE Ratios for FY1 thru FY10. Thank you for all your help.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

Need traffic?

Drive customers

With search ads

on Yahoo!

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 02.48

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)