Messages In This Digest (19 Messages)
- 1a.
- MSN data working? From: supernaut570
- 1b.
- Re: MSN data working? From: Randy Harmelink
- 1c.
- Re: MSN data working? From: supernaut570
- 2a.
- Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum From: Ron Spruell
- 2b.
- Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum From: Randy Harmelink
- 2c.
- Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum From: Ron Spruell
- 2d.
- Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum From: Randy Harmelink
- 3a.
- 3 month return From: ufdn16
- 3b.
- Re: 3 month return From: Randy Harmelink
- 3c.
- Re: 3 month return From: NicholasDavid
- 3d.
- Re: 3 month return From: Randy Harmelink
- 4.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
- 5a.
- New element file From: ufdn16
- 5b.
- Re: New element file From: Randy Harmelink
- 6a.
- Randy please help! From: lee
- 6b.
- Re: Randy please help! From: Randy Harmelink
- 7a.
- Re: StockScouter Rating From: KailuaKid
- 8a.
- Some Element Numbers Not Working From: ro.valen
- 8b.
- Re: Some Element Numbers Not Working From: Randy Harmelink
Messages
- 1a.
-
MSN data working?
Posted by: "supernaut570" steve@lovisa.us supernaut570
Sat Jun 9, 2012 7:21 am (PDT)
Hi Randy. I just unearthed an old file that uses the SMF addin (all or almost all data drawn from MSN) and it wasn't displaying any data - not even simple stuff like last price (element 25). So I downloaded and installed the latest addin version, but with the same results - nothing.
I'm wondering if maybe MSN changed their page since the last definitions document? Any ideas? Is it working for others?
Thanks for any help you can offer. Much appreciated.
- 1b.
-
Re: MSN data working?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 9, 2012 8:16 am (PDT)
You guess is right -- see:
http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
On Sat, Jun 9, 2012 at 7:21 AM, supernaut570 <steve@lovisa.us > wrote:
> Hi Randy. I just unearthed an old file that uses the SMF addin (all or
> almost all data drawn from MSN) and it wasn't displaying any data - not
> even simple stuff like last price (element 25). So I downloaded and
> installed the latest addin version, but with the same results - nothing.
>
> I'm wondering if maybe MSN changed their page since the last definitions
> document? Any ideas? Is it working for others?
>
> Thanks for any help you can offer. Much appreciated.
>
- 1c.
-
Re: MSN data working?
Posted by: "supernaut570" steve@lovisa.us supernaut570
Sat Jun 9, 2012 1:39 pm (PDT)
Thanks so much. I used to be a big fan of the Motley Fool's Foolish 8 Scorecard available on Quicken.com, until they took it down about 5 years ago (maybe longer now...). Anyway, I tried to re-create it using your add-in. It's a big time saver for my screening process.
I uploaded it to the group. Maybe someone will have suggestions for improving it - and hopefully someone else will find it as useful a screening tool as I have.
http://finance.groups.yahoo. com/group/ smf_addin/ message/18930
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You guess is right -- see:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
>
> On Sat, Jun 9, 2012 at 7:21 AM, supernaut570 <steve@...> wrote:
>
> > Hi Randy. I just unearthed an old file that uses the SMF addin (all or
> > almost all data drawn from MSN) and it wasn't displaying any data - not
> > even simple stuff like last price (element 25). So I downloaded and
> > installed the latest addin version, but with the same results - nothing.
> >
> > I'm wondering if maybe MSN changed their page since the last definitions
> > document? Any ideas? Is it working for others?
> >
> > Thanks for any help you can offer. Much appreciated.
> >
>
- 2a.
-
Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum
Posted by: "Ron Spruell" hashky@yahoo.com hashky
Sat Jun 9, 2012 8:24 am (PDT)
Clark -
Here is one that will work with the "N/A" error. You can change the "--" to "" to get a blank cell. You are array entering this, aren't you?
=IF(rchgetyahooquotes($A7,"ny" )="N/A"," --",rchgetyahooq uotes($A7, "ny"))
Ron Spruell
>____________________ _________ ___
> From: Clark F. Grain <cgrain@rcn.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, June 8, 2012 6:55 PM
>Subject: Re: [smf_addin] Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNumber
>
>
>
>Try the IFERROR Formula in Excel.
>
>Clark Grain
>----- Original Message -----
>>From: Steven
>>To: smf_addin@yahoogroups.com
>>Sent: Friday, June 08, 2012 12:40
PM
>>Subject: [smf_addin] Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNumber
>>
>>
>>Hello all,
>>
>>I have been trying to figure this out and I am stumped.
Probably my Excel skills are too elementary and Google has helped.
>>
>>I
have a sheet that pulls all sorts of data using the add-in, and for some
fields when negative (earnings) or non-existent (FCF), it pulls a "#VALUE" or
"N/A".
>>
>>I would like to write a formula that would just leave the cell
blank if these values are pulled. I used some IF commands in other cells but
can't see how to use this with the add-in cells.
>>
>>An example formula
which is simple:
>>
>>=RCHGetYahooQuotes($A7, "y")
>>
>>This pulls the
yield for ticker in cell A7. Right now that is NVDA with no yield. I get
#VALUE. How can I modify that cell to leave it blank, until the day the NVDA
has a yield? Many thanks in advance.
>>
>>
>
>
> - 2b.
-
Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 9, 2012 8:33 am (PDT)
Not recommended. That means you would have two Internet accesses for each
good data item...
On Sat, Jun 9, 2012 at 8:24 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> Here is one that will work with the "N/A" error. You can change the "--"
> to "" to get a blank cell. You are array entering this, aren't you?
>
> =IF(rchgetyahooquotes($A7,"ny" )="N/A"," --",rchgetyahooq uotes($A7, "ny"))
>
>
- 2c.
-
Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum
Posted by: "Ron Spruell" hashky@yahoo.com hashky
Sat Jun 9, 2012 4:10 pm (PDT)
I don't do it. I knew there was some reason I didn't. I normally pull in all my Yahoo data in an array on one tab, normally named Web_data. Then I use Vlookup or Index/Match on another Tab. That way I can sort, filter, etc.
>____________________ _________ ___
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Saturday, June 9, 2012 10:33 AM
>Subject: Re: [smf_addin] Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNumber
>
>
>
>Not recommended. That means you would have two Internet accesses for each good data item...
>
>
>On Sat, Jun 9, 2012 at 8:24 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>Here is one that will work with the "N/A" error. You can change the "--" to "" to get a blank cell. You are array entering this, aren't you?
>>
>>
>>
>>=IF(rchgetyahooquotes($A7, "ny")="N/ A","--",rchgetya hooquotes( $A7,"ny") )
>>
>
>
>
> - 2d.
-
Re: Keep Cells blank for Data using RCHGetYahoo and RCHGetElementNum
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 9, 2012 4:16 pm (PDT)
Yup. That gives you the best of both worlds -- the quickest way to actually
retrieve the data, but also have the ability to manipulate it.
On Sat, Jun 9, 2012 at 4:10 PM, Ron Spruell <hashky@yahoo.com > wrote:
>
> I don't do it. I knew there was some reason I didn't. I normally pull in
> all my Yahoo data in an array on one tab, normally named Web_data. Then I
> use Vlookup or Index/Match on another Tab. That way I can sort, filter,
> etc.
>
- 3a.
-
3 month return
Posted by: "ufdn16" ufdn16@yahoo.com ufdn16
Sat Jun 9, 2012 9:40 am (PDT)
why do I get an error with =RCHGetYahooQuotes(ticker1,27)
trying to retrieve 3 month return.
also, 28 and 29 have same result
- 3b.
-
Re: 3 month return
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 9, 2012 11:39 am (PDT)
That function invocation should return nothing, because there is no Yahoo
code 27 available from Yahoo. Nor Yahoo codes 28 and 29.
Most probably you are talking about the RCHGetElementNumber() function? If
so, see:
http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
On Sat, Jun 9, 2012 at 9:40 AM, ufdn16 <ufdn16@yahoo.com > wrote:
> why do I get an error with =RCHGetYahooQuotes(ticker1,27)
> trying to retrieve 3 month return.
>
> also, 28 and 29 have same result
>
- 3c.
-
Re: 3 month return
Posted by: "NicholasDavid" nicholasdavid@comcast.net davidnicholas738
Sat Jun 9, 2012 12:26 pm (PDT)
Well, that was embarrassing.
Ok, I have the element text file you directed me to.
What do I do with it.
Do I just put this file in my smf_addin file and delete the elementnumber file I already have?
----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com >
To: "smf addin" <smf_addin@yahoogroups.com >
Sent: Saturday, June 9, 2012 1:39:36 PM
Subject: Re: [smf_addin] 3 month return
That function invocation should return nothing, because there is no Yahoo code 27 available from Yahoo. Nor Yahoo codes 28 and 29.
Most probably you are talking about the RCHGetElementNumber() function? If so, see:
http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
On Sat, Jun 9, 2012 at 9:40 AM, ufdn16 < ufdn16@yahoo.com > wrote:
why do I get an error with =RCHGetYahooQuotes(ticker1,27)
trying to retrieve 3 month return.
also, 28 and 29 have same result
- 3d.
-
Re: 3 month return
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 9, 2012 12:30 pm (PDT)
Pretty much.
You should exit EXCEL. Replace the file in the add-in folder with the newly
downloaded file. Restart EXCEL.
On Sat, Jun 9, 2012 at 12:26 PM, NicholasDavid <nicholasdavid@comcast.net >wrote:
>
> Ok, I have the element text file you directed me to.
> What do I do with it.
> Do I just put this file in my smf_addin file and delete the elementnumber
> file I already have?
>
- 4.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Sat Jun 9, 2012 1:34 pm (PDT)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/Foolish8_Scorecard_ MSN_2012. xls
Uploaded by : supernaut570 <steve@lovisa.us >
Description : MOTLEY FOOL'S FOOLISH 8 ONE-CLICK SCORECARD
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Uploads%20by% 20forum%20member s/Foolish8_ Scorecard_ MSN_2012. xls
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
supernaut570 <steve@lovisa.us >
- 5a.
-
New element file
Posted by: "ufdn16" ufdn16@yahoo.com ufdn16
Sat Jun 9, 2012 1:36 pm (PDT)
Randy , I still get an error when I use the formula =rchgetelementnumber(ticker1, 27)
I followed your instructions.
I deleted everything in my smf_addin directory then went to the group website in the in-process file and retrieved the new smf_add in file.
I chose the xls file not the text file which you directed me to.
I unzipped the file and it was placed in my smf_addin directory.
I find that all my other element numbers in my worksheet are being updated. But, I still can't get 27,28,29 or 25
I at a loss.
- 5b.
-
Re: New element file
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 9, 2012 1:40 pm (PDT)
What do you get with:
=RCHGetElementNumber("Version" )
=RCHGetElementNumber("MMM",25)
=smfGetAParms(25)
On Sat, Jun 9, 2012 at 1:36 PM, ufdn16 <ufdn16@yahoo.com > wrote:
> Randy , I still get an error when I use the formula
> =rchgetelementnumber(ticker1, 27)
>
> I followed your instructions.
>
> I deleted everything in my smf_addin directory then went to the group
> website in the in-process file and retrieved the new smf_add in file.
> I chose the xls file not the text file which you directed me to.
>
> I unzipped the file and it was placed in my smf_addin directory.
>
> I find that all my other element numbers in my worksheet are being
> updated. But, I still can't get 27,28,29 or 25
>
> I at a loss.
>
- 6a.
-
Randy please help!
Posted by: "lee" lguthrienyc@yahoo.com lguthrienyc
Sat Jun 9, 2012 1:41 pm (PDT)
Hi Randy, quick question. I'm new to your group and tried to download addin. Have not completed it but now when I try to open any excel program on my mac it will not open and brings up a box that says project on top which i believe is related to the addin. Do you know how I can delete what I've done at least for now so that I can use my excel files etc? Thanks very much, Lee
- 6b.
-
Re: Randy please help!
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 9, 2012 1:43 pm (PDT)
I know almost nothing about Macs. But just downloading the add-in shouldn't
do anything to EXCEL.
On Sat, Jun 9, 2012 at 1:38 PM, lee <lguthrienyc@yahoo.com > wrote:
> Hi Randy, quick question. I'm new to your group and tried to download
> addin. Have not completed it but now when I try to open any excel program
> on my mac it will not open and brings up a box that says project on top
> which i believe is related to the addin. Do you know how I can delete what
> I've done at least for now so that I can use my excel files etc? Thanks
> very much, Lee
>
- 7a.
-
Re: StockScouter Rating
Posted by: "KailuaKid" Gary.Hartling@gmail.com garyhartling
Sat Jun 9, 2012 2:39 pm (PDT)
Or, since it's already defined, you could use the built-in function RCHGetElementNumber("MMM",543) . --Gary
--- In smf_addin@yahoogroups.com , "Brendyn" <bsarnacki2000@...> wrote:
>
> If this will help anyone. I found this to work for getting the stockscouter rating number:
> =1*MID(smfGetTagContent("http://investing. money.msn. "&A3,"p",0,"com/investments/ stock-ratings? symbol= Stock Rating Summary"),100, 2)
>
- 8a.
-
Some Element Numbers Not Working
Posted by: "ro.valen" ro.valen@yahoo.com ro.valen
Sat Jun 9, 2012 11:28 pm (PDT)
Good Evening All,
For the last couple weeks I have noticed that a few Element Numbers have been producing error results. Below is a list of the elements with their corresponding numbers. They used to work, but perhaps they have changed. Has anyone else had similar issues? If so, can you please suggest a fix?
Field Name Element Number
"Last Price" 25
"200 Day Moving Average" 36
"52 Week Low" 33
"52 Week High" 34
"Dividend Rate" 46
Thanks in advance for your help.
Ro
- 8b.
-
Re: Some Element Numbers Not Working
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 9, 2012 11:31 pm (PDT)
It was a big topic of discussion about a month ago. See:
http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
On Sat, Jun 9, 2012 at 11:28 PM, ro.valen <ro.valen@yahoo.com > wrote:
>
> For the last couple weeks I have noticed that a few Element Numbers have
> been producing error results. Below is a list of the elements with their
> corresponding numbers. They used to work, but perhaps they have changed.
> Has anyone else had similar issues? If so, can you please suggest a fix?
>
> Field Name Element Number
> "Last Price" 25
> "200 Day Moving Average" 36
> "52 Week Low" 33
> "52 Week High" 34
> "Dividend Rate" 46
>
>
> Thanks in advance for your help.
>
> Ro
>
>
>
> --------------------- --------- ------
>
> Yahoo! Groups Links
>
>
>
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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
Tidak ada komentar:
Posting Komentar