[smf_addin] Digest Number 2216[1 Attachment]

EXCEL Stock Market Functions Add-in

Messages In This Digest (25 Messages)

1a.

Re: Correlation Data From: Jay Leavitt

1b.

Re: Correlation Data From: Ron Spruell

2a.

SEDOL From: Brent

2b.

Re: SEDOL From: Randy Harmelink

3.1.

Re: RCHGetYahooQuotes() From: Subu S

3.2.

Re: RCHGetYahooQuotes() From: Randy H

3.3.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply From: Subu S

3.4.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply From: Subu S

3.5.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply From: Subu S

3.6.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply From: Randy Harmelink

3.7.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply From: Subu S

3.8.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply From: Subu S

3.9.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply From: Subu S

3.10.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply From: Randy Harmelink

3.11.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply From: Subu S

3.12.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply From: Randy Harmelink

4a.

smf-element 1 From: Jason

4b.

Re: smf-element 1 From: Randy Harmelink

4c.

Re: smf-element 1 From: Jason Strauss

4d.

Re: smf-element 1 From: Randy Harmelink

4e.

Re: smf-element 1 From: Jason Strauss

5a.

Download the add-in for excel 2011 From: eddieo34ob

5b.

Re: Download the add-in for excel 2011 From: Randy Harmelink

6a.

Rchgetelement errors From: broberts1745

6b.

Re: Rchgetelement errors From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.

Re: Correlation Data

Posted by: "Jay Leavitt" drjay001@gmail.com   grabthecashanddash

Fri May 18, 2012 6:42 am (PDT)

There is a function, CORREL, in the Excel Statistical Group.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)

1b.

Re: Correlation Data

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

Fri May 18, 2012 11:51 am (PDT)

[Attachment(s) from Ron Spruell included below]

Here is a 3-month correlation table that I wrote.  It may help you.  Enter the ticker symbols in A5 through A17.  You can change the length of time if you want.

Ron Spruell

>________________________________
> From: oyz79 <oyz79@yahoo.com>
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, May 16, 2012 10:25 PM
>Subject: [smf_addin] Re: Correlation Data
>
>
> 
>That probably explains it. However, that seems to be the standard method most sites use. Any idea how to write a formula to match the daily percent change method for correlations?
>
>--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>>
>> It looks like they are correlating the daily percent change in price, but
>> I'm not sure that's right. Daily percent changes don't have
>> additive/subtractive properties, so looking at multiple days would
>> misrepresent the data that would need to be compounded to get the
>> cumulative return.
>>
>> On Wed, May 16, 2012 at 7:57 PM, oyz79 <oyz79@...> wrote:
>>
>> > ETF Replay shows -.64 as does Assetcorrelation.com. ETF Replay uses
>> > adjusted data, not sure about assetcorrelation.com
>> >
>>
>
>
>
>
>

Attachment(s) from Ron Spruell

1 of 1 File(s)

3 Month Correlation.xls

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)

2a.

SEDOL

Posted by: "Brent" brent@carolopolis.com   bebentrim

Fri May 18, 2012 10:52 am (PDT)

Any idea where to go to use the SEDOL for a stock (non US) instead of ticker or cusip?

Back to top

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

2b.

Re: SEDOL

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

Fri May 18, 2012 11:55 am (PDT)

Clueless here.

On Fri, May 18, 2012 at 10:52 AM, Brent <brent@carolopolis.com> wrote:

> Any idea where to go to use the SEDOL for a stock (non US) instead of
> ticker or cusip?
>

Back to top

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

3.1.

Re: RCHGetYahooQuotes()

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Fri May 18, 2012 11:34 am (PDT)

Hi Randy

Thanks a ton for ALL your contribution to us

Following your advise couple of days ago, I've used "getyahooquotes" as mentioned in http://finance.groups.yahoo.com/group/smf_addin/message/124

However it isn't working since some hours ago today (say since morning today - US Eastern Time)

I have the ticker symbols on A2 , A3, A4 etc. typical MMM, GIS, MSFT etc. I have o, h, l1 on B1, C1, D1

I have highlighted B2 to M100 AND array entered =RCHGetYahooQuotes(A2:A100,B1:M1) on those cells

I see only blanks

What am I missing or what am I doing wrong ?

TIA
&
regards

Subu

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> No numbers -- Yahoo codes. "l1" is what to use for last price. Check the
> documentation for other available Yahoo codes.
>
> On Thu, May 17, 2012 at 1:19 PM, ricky.parikh <ricky.parikh@
> <mailto:ricky.parikh@...> > wrote:
>
> Thanks so much for your work. You mentioned people should use
> getyahooquotes() instead of getelementnumber(__, 25) for last price.
> What number besides my cell number corresponding to the ticker should I
> use for yahoo, i.e. to replace the 25? Thanks for your help.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.2.

Re: RCHGetYahooQuotes()

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

Fri May 18, 2012 12:00 pm (PDT)

Don't know what to tell you -- it's working fine here. I just created
this from scratch:

o h l1 MMM $84.78 $84.78 $83.60 GIS $39.34 $39.35 $38.99 MSFT
$29.77 $29.81 $29.32

On Fri, May 18, 2012 at 11:34 AM, Subu S <mail_to_subu@yahoo.com
<mailto:mail_to_subu@yahoo.com> > wrote:

Hi Randy

Thanks a ton for ALL your contribution to us

Following your advise couple of days ago, I've used "getyahooquotes" as
mentioned in http://finance.groups.yahoo.com/group/smf_addin/message/124
<http://finance.groups.yahoo.com/group/smf_addin/message/124>

However it isn't working since some hours ago today (say since morning
today - US Eastern Time)

I have the ticker symbols on A2 , A3, A4 etc. typical MMM, GIS, MSFT
etc. I have o, h, l1 on B1, C1, D1

I have highlighted B2 to M100 AND array entered
=RCHGetYahooQuotes(A2:A100,B1:M1) on those cells

I see only blanks

What am I missing or what am I doing wrong ?

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.3.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Fri May 18, 2012 1:17 pm (PDT)

Thanks Randy. Don't want to trouble you any more ...

To : Digsuppy :
Hi . I saw your sp sheet at http://bit.ly/M28gYl. Thanks. Quite an interesting sp sheet. Also, that will more than meet my basic need of quotes for a few *hundred* tickers (ref thread below). just one question does this sp sheet refresh data when I load it or do I have to necessarily click on the refresh button ? I use win XP and XL 2003 (at least till date). Also what VBA codes do I run to get results (similar ) to the other buttons ?

regards
Subu

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> Don't know what to tell you -- it's working fine here. I just created
> this from scratch:
>
> o h l1 MMM $84.78 $84.78 $83.60 GIS $39.34 $39.35 $38.99 MSFT
> $29.77 $29.81 $29.32
>
> On Fri, May 18, 2012 at 11:34 AM, Subu S <mail_to_subu@...
> <mailto:mail_to_subu@...> > wrote:
>
> Hi Randy
>
> Thanks a ton for ALL your contribution to us
>
> Following your advise couple of days ago, I've used "getyahooquotes" as
> mentioned in http://finance.groups.yahoo.com/group/smf_addin/message/124
> <http://finance.groups.yahoo.com/group/smf_addin/message/124>
>
> However it isn't working since some hours ago today (say since morning
> today - US Eastern Time)
>
> I have the ticker symbols on A2 , A3, A4 etc. typical MMM, GIS, MSFT
> etc. I have o, h, l1 on B1, C1, D1
>
> I have highlighted B2 to M100 AND array entered
> =RCHGetYahooQuotes(A2:A100,B1:M1) on those cells
>
> I see only blanks
>
> What am I missing or what am I doing wrong ?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.4.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Fri May 18, 2012 1:22 pm (PDT)

Dear All

Just noticed that sp sheet at http://bit.ly/M28gYl does NOT update auto ...even IF I try to update, I get the same problem as with GetYahooquotes ...

....so ......so .. stumped and back to sq 1 !!

Let me try re installing the whole add in again

regards
Subu

--- In smf_addin@yahoogroups.com, "Subu S" <mail_to_subu@...> wrote:
>
> Thanks Randy. Don't want to trouble you any more ...
>
> To : Digsuppy :
> Hi . I saw your sp sheet at http://bit.ly/M28gYl. Thanks. Quite an interesting sp sheet. Also, that will more than meet my basic need of quotes for a few *hundred* tickers (ref thread below). just one question does this sp sheet refresh data when I load it or do I have to necessarily click on the refresh button ? I use win XP and XL 2003 (at least till date). Also what VBA codes do I run to get results (similar ) to the other buttons ?
>
> regards
> Subu
>
>
>
>
> --- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@> wrote:
> >
> > Don't know what to tell you -- it's working fine here. I just created
> > this from scratch:
> >
> > o h l1 MMM $84.78 $84.78 $83.60 GIS $39.34 $39.35 $38.99 MSFT
> > $29.77 $29.81 $29.32
> >
> > On Fri, May 18, 2012 at 11:34 AM, Subu S <mail_to_subu@
> > <mailto:mail_to_subu@> > wrote:
> >
> > Hi Randy
> >
> > Thanks a ton for ALL your contribution to us
> >
> > Following your advise couple of days ago, I've used "getyahooquotes" as
> > mentioned in http://finance.groups.yahoo.com/group/smf_addin/message/124
> > <http://finance.groups.yahoo.com/group/smf_addin/message/124>
> >
> > However it isn't working since some hours ago today (say since morning
> > today - US Eastern Time)
> >
> > I have the ticker symbols on A2 , A3, A4 etc. typical MMM, GIS, MSFT
> > etc. I have o, h, l1 on B1, C1, D1
> >
> > I have highlighted B2 to M100 AND array entered
> > =RCHGetYahooQuotes(A2:A100,B1:M1) on those cells
> >
> > I see only blanks
> >
> > What am I missing or what am I doing wrong ?
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.5.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Fri May 18, 2012 2:06 pm (PDT)

Dear Randy

Hate to trouble you, Still posting as I see no other way out
1. GetYahooQuotes is not working since the last 7 .. 8 hours

2. I suspect yahoo may have changed my "location" yesterday / today etc
;

3. I live in the middle east

4. When I try to get quotes for MMM from finance.yahoo.com, I am sent /
redirected to http://finance.yahoo.com/q?s=MMM [do NOT know IF this was
the case a few days ago, but this is what it is now]

5. When I click on download data (delayed) bottom right hand corner of
above page, I get to
http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1d1t1c1ohgv&e=.\
csv which is shortened would be http://bit.ly/MsRGnc

The shortened link was given to avoid yahoo breaking long links
..nothing else

The csv file looks like this

MMM

83.51

5/18/2012

4:01pm

-0.83

84.78

84.78

83.27

3597584

6. I am NOT sure IF the portion of VBA handling "...'------------------>
Set the quotes delimiter based on server prefix.." considers my location
/ yahoo server etc

hence this post

7 . If getyahooquotes is going to be a problem what the next best
alternative for
- last price,
- 52 week high ,
- 52 week low,
- PE and
- market cap ?

thanks in advance
B regards

Subu

--- In smf_addin@yahoogroups.com, "Subu S" <mail_to_subu@...> wrote:
>
> Dear All
>
> Just noticed that sp sheet at http://bit.ly/M28gYl does NOT update
auto ...even IF I try to update, I get the same problem as with
GetYahooquotes ...
>
> ....so ......so .. stumped and back to sq 1 !!
>
> Let me try re installing the whole add in again
>
>
> regards
> Subu
>
>
>
>
> --- In smf_addin@yahoogroups.com, "Subu S" mail_to_subu@ wrote:
> >
> > Thanks Randy. Don't want to trouble you any more ...
> >
> > To : Digsuppy :
> > Hi . I saw your sp sheet at http://bit.ly/M28gYl. Thanks. Quite an
interesting sp sheet. Also, that will more than meet my basic need of
quotes for a few *hundred* tickers (ref thread below). just one question
does this sp sheet refresh data when I load it or do I have to
necessarily click on the refresh button ? I use win XP and XL 2003 (at
least till date). Also what VBA codes do I run to get results (similar )
to the other buttons ?
> >
> > regards
> > Subu
> >
> >
> >
> >
> > --- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@> wrote:
> > >
> > > Don't know what to tell you -- it's working fine here. I just
created
> > > this from scratch:
> > >
> > > o h l1 MMM $84.78 $84.78 $83.60 GIS $39.34 $39.35 $38.99
MSFT
> > > $29.77 $29.81 $29.32
> > >
> > > On Fri, May 18, 2012 at 11:34 AM, Subu S <mail_to_subu@
> > > <mailto:mail_to_subu@> > wrote:
> > >
> > > Hi Randy
> > >
> > > Thanks a ton for ALL your contribution to us
> > >
> > > Following your advise couple of days ago, I've used
"getyahooquotes" as
> > > mentioned in
http://finance.groups.yahoo.com/group/smf_addin/message/124
> > > <http://finance.groups.yahoo.com/group/smf_addin/message/124>
> > >
> > > However it isn't working since some hours ago today (say since
morning
> > > today - US Eastern Time)
> > >
> > > I have the ticker symbols on A2 , A3, A4 etc. typical MMM, GIS,
MSFT
> > > etc. I have o, h, l1 on B1, C1, D1
> > >
> > > I have highlighted B2 to M100 AND array entered
> > > =RCHGetYahooQuotes(A2:A100,B1:M1) on those cells
> > >
> > > I see only blanks
> > >
> > > What am I missing or what am I doing wrong ?
> > >
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.6.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

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

Fri May 18, 2012 2:11 pm (PDT)

What do you get with:

=RCHGetElementNumber("Version")
=RCHGetYahooQuotes("MMM","l1")
=RCHGetYahooQuotes("MMM","t1")
=RCHGetWebData("
http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.csv",1)

For alternative sources of the items you mention, take a look at the FinViz
entry in the "Links" area of the group.

On Fri, May 18, 2012 at 2:06 PM, Subu S <mail_to_subu@yahoo.com> wrote:

>
> Hate to trouble you, Still posting as I see no other way out
> 1. GetYahooQuotes is not working since the last 7 .. 8 hours
>
> 2. I suspect yahoo may have changed my "location" yesterday / today etc ;
>
> 3. I live in the middle east
>
> 4. When I try to get quotes for MMM from finance.yahoo.com, I am sent /
> redirected to http://finance.yahoo.com/q?s=MMM [do NOT know IF this was
> the case a few days ago, but this is what it is now]
>
> 5. When I click on download data (delayed) bottom right hand corner of
> above page, I get to
> http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1d1t1c1ohgv&e=.csvwhich is shortened would be
> http://bit.ly/MsRGnc
>
> The shortened link was given to avoid yahoo breaking long links ..nothing
> else
>
> The csv file looks like this
>
> MMM
>
> 83.51
>
> 5/18/2012
>
> 4:01pm
>
> -0.83
>
> 84.78
>
> 84.78
>
> 83.27
>
> 3597584
>
> 6. I am NOT sure IF the portion of VBA handling "...'------------------>
> Set the quotes delimiter based on server prefix.." considers my location /
> yahoo server etc
>
> hence this post
>
> 7 . If getyahooquotes is going to be a problem what the next best
> alternative for
> - last price,
> - 52 week high ,
> - 52 week low,
> - PE and
> - market cap ?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.7.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Fri May 18, 2012 2:18 pm (PDT)

Also ... If I chose to see quotes for a hundred or so tickers, this is the page I am sent to

SCREENVIEW URL
----------------------

http://finance.yahoo.com/quotes/tin,mt,ufs,iag,etr,swy,clf,fte,deg,fcx,nee,ndaq,pgh,gpn,gme,ntt,gci,lll,teo,rkt,vlo,skm,ftr,aee,stm,abx,pbi,hpq,xrx,ocr,cop,tsu,tsu,vale,cha,nxy,erf,ccj,gg,tds,apa,tap,wag,dds,chk,tnh,wpo,azn,unp,hrs,ip,fis,spls,cat,dhi,glw,nvs,aap,mro,rsg,noc,bhp,yzc,low,tm,hmc,cbi,aa,tef,egn,ctl,btu,ge,dcm,f,ivz,nyx,sig,teg,e,crh,rio,alv,ggb,ggb,aep,twx,caj,ach,snn,abc,sny,si,kyo,avy,man,kt,viv,bg,tsn,dte,sm,rs,bms,leg,csco,dd,do,luv,irm,auy,kss,stj,petm,hfc,tw,hes,dow,cvx,zmh,ipg,txt,orcl,lnt,vod,altr,nue,teva,oxy,fl,uhs,tot,swk,kub,wcn,eca,grmn,esv,mwv,lly,ne,nwsa,coo,msft,mur,see,whr,mktay,su,pll,sap,gxp,bcr,mdt,bp,cmcsa,eni,eni,pt,ame,klac,sjm,tlm,tgt,str,m,wm,dgx,amgn,atvi,atvi,pfe,exc,intc,tup,tss,utx,iaci,bt,omc,spil,amat,amat,dhr,wppgy,wab,bmy,ctas,nov,mck,mck,peg,jkhy,igt,fdo,flir,t,cyt,dov,lmt,abt,adm,gpc,mhp,qcom,len,gdi,hd,xlnx,cnq,flr

short : http://yhoo.it/KwAMQh

Download URL for basic view of the same list as above
----------------------------------------------------------
http://download.finance.yahoo.com/d/quotes.csv?s=TIN,MT,UFS,IAG,ETR,SWY,CLF,FTE,DEG,FCX,NEE,NDAQ,PGH,GPN,GME,NTT,GCI,LLL,TEO,RKT,VLO,SKM,FTR,AEE,STM,ABX,PBI,HPQ,XRX,OCR,COP,TSU,TSU,VALE,CHA,NXY,ERF,CCJ,GG,TDS,APA,TAP,WAG,DDS,CHK,TNH,WPO,AZN,UNP,HRS,IP,FIS,SPLS,CAT,DHI,GLW,NVS,AAP,MRO,RSG,NOC,BHP,YZC,LOW,TM,HMC,CBI,AA,TEF,EGN,CTL,BTU,GE,DCM,F,IVZ,NYX,SIG,TEG,E,CRH,RIO,ALV,GGB,GGB,AEP,TWX,CAJ,ACH,SNN,ABC,SNY,SI,KYO,AVY,MAN,KT,VIV,BG,TSN,DTE,SM,RS,BMS,LEG,CSCO,DD,DO,LUV,IRM,AUY,KSS,STJ,PETM,HFC,TW,HES,DOW,CVX,ZMH,IPG,TXT,ORCL,LNT,VOD,ALTR,NUE,TEVA,OXY,FL,UHS,TOT,SWK,KUB,WCN,ECA,GRMN,ESV,MWV,LLY,NE,NWSA,COO,MSFT,MUR,SEE,WHR,MKTAY,SU,PLL,SAP,GXP,BCR,MDT,BP,CMCSA,ENI,ENI,PT,AME,KLAC,SJM,TLM,TGT,STR,M,WM,DGX,AMGN,ATVI,ATVI,PFE,EXC,INTC,TUP,TSS,UTX,IACI,BT,OMC,SPIL,AMAT,AMAT,DHR,WPPGY,WAB,BMY,CTAS,NOV,MCK,MCK,PEG,JKHY,IGT,FDO,FLIR,T,CYT,DOV,LMT,ABT,ADM,GPC,MHP,QCOM,LEN,GDI,HD,XLNX,CNQ,FLR&f=sl1d1t1c1ohgv&e=.csv

short : http://bit.ly/J7uXbK

regards
Subu

--- In smf_addin@yahoogroups.com, "Subu S" <mail_to_subu@...> wrote:
>
> Dear Randy
>
> Hate to trouble you, Still posting as I see no other way out
> 1. GetYahooQuotes is not working since the last 7 .. 8 hours
>
> 2. I suspect yahoo may have changed my "location" yesterday / today etc
> ;
>
> 3. I live in the middle east
>
> 4. When I try to get quotes for MMM from finance.yahoo.com, I am sent /
> redirected to http://finance.yahoo.com/q?s=MMM [do NOT know IF this was
> the case a few days ago, but this is what it is now]
>
> 5. When I click on download data (delayed) bottom right hand corner of
> above page, I get to
> http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1d1t1c1ohgv&e=.\
> csv which is shortened would be http://bit.ly/MsRGnc
>
> The shortened link was given to avoid yahoo breaking long links
> ..nothing else
>
> The csv file looks like this
>
> MMM
>
> 83.51
>
> 5/18/2012
>
> 4:01pm
>
> -0.83
>
> 84.78
>
> 84.78
>
> 83.27
>
> 3597584
>
> 6. I am NOT sure IF the portion of VBA handling "...'------------------>
> Set the quotes delimiter based on server prefix.." considers my location
> / yahoo server etc
>
> hence this post
>
> 7 . If getyahooquotes is going to be a problem what the next best
> alternative for
> - last price,
> - 52 week high ,
> - 52 week low,
> - PE and
> - market cap ?
>
>
>
> thanks in advance
> B regards
>
>
> Subu
>
> --- In smf_addin@yahoogroups.com, "Subu S" <mail_to_subu@> wrote:
> >
> > Dear All
> >
> > Just noticed that sp sheet at http://bit.ly/M28gYl does NOT update
> auto ...even IF I try to update, I get the same problem as with
> GetYahooquotes ...
> >
> > ....so ......so .. stumped and back to sq 1 !!
> >
> > Let me try re installing the whole add in again
> >
> >
> > regards
> > Subu
> >
> >
> >
> >
> > --- In smf_addin@yahoogroups.com, "Subu S" mail_to_subu@ wrote:
> > >
> > > Thanks Randy. Don't want to trouble you any more ...
> > >
> > > To : Digsuppy :
> > > Hi . I saw your sp sheet at http://bit.ly/M28gYl. Thanks. Quite an
> interesting sp sheet. Also, that will more than meet my basic need of
> quotes for a few *hundred* tickers (ref thread below). just one question
> does this sp sheet refresh data when I load it or do I have to
> necessarily click on the refresh button ? I use win XP and XL 2003 (at
> least till date). Also what VBA codes do I run to get results (similar )
> to the other buttons ?
> > >
> > > regards
> > > Subu
> > >
> > >
> > >
> > >
> > > --- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@> wrote:
> > > >
> > > > Don't know what to tell you -- it's working fine here. I just
> created
> > > > this from scratch:
> > > >
> > > > o h l1 MMM $84.78 $84.78 $83.60 GIS $39.34 $39.35 $38.99
> MSFT
> > > > $29.77 $29.81 $29.32
> > > >
> > > > On Fri, May 18, 2012 at 11:34 AM, Subu S <mail_to_subu@
> > > > <mailto:mail_to_subu@> > wrote:
> > > >
> > > > Hi Randy
> > > >
> > > > Thanks a ton for ALL your contribution to us
> > > >
> > > > Following your advise couple of days ago, I've used
> "getyahooquotes" as
> > > > mentioned in
> http://finance.groups.yahoo.com/group/smf_addin/message/124
> > > > <http://finance.groups.yahoo.com/group/smf_addin/message/124>
> > > >
> > > > However it isn't working since some hours ago today (say since
> morning
> > > > today - US Eastern Time)
> > > >
> > > > I have the ticker symbols on A2 , A3, A4 etc. typical MMM, GIS,
> MSFT
> > > > etc. I have o, h, l1 on B1, C1, D1
> > > >
> > > > I have highlighted B2 to M100 AND array entered
> > > > =RCHGetYahooQuotes(A2:A100,B1:M1) on those cells
> > > >
> > > > I see only blanks
> > > >
> > > > What am I missing or what am I doing wrong ?
> > > >
> > >
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.8.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Fri May 18, 2012 2:25 pm (PDT)

Thanks Randy !!

This is what I get

RCHGetElementNumber("Version")

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

RCHGetYahooQuotes("MMM","l1")

Error

RCHGetYahooQuotes("MMM","t1")

Error

RCHGetWebData("http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl\
1&e=.csv",1)

Error
<http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.csv>

regards

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...>
wrote:
>
> What do you get with:
>
> =RCHGetElementNumber("Version")
> =RCHGetYahooQuotes("MMM","l1")
> =RCHGetYahooQuotes("MMM","t1")
> =RCHGetWebData("
> http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.csv",1)
>
> For alternative sources of the items you mention, take a look at the
FinViz
> entry in the "Links" area of the group.
>
> On Fri, May 18, 2012 at 2:06 PM, Subu S mail_to_subu@... wrote:
>
> >
> > Hate to trouble you, Still posting as I see no other way out
> > 1. GetYahooQuotes is not working since the last 7 .. 8 hours
> >
> > 2. I suspect yahoo may have changed my "location" yesterday / today
etc ;
> >
> > 3. I live in the middle east
> >
> > 4. When I try to get quotes for MMM from finance.yahoo.com, I am
sent /
> > redirected to http://finance.yahoo.com/q?s=MMM [do NOT know IF this
was
> > the case a few days ago, but this is what it is now]
> >
> > 5. When I click on download data (delayed) bottom right hand corner
of
> > above page, I get to
> >
http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1d1t1c1ohgv&e=.\
csvwhich is shortened would be
> > http://bit.ly/MsRGnc
> >
> > The shortened link was given to avoid yahoo breaking long links
..nothing
> > else
> >
> > The csv file looks like this
> >
> > MMM
> >
> > 83.51
> >
> > 5/18/2012
> >
> > 4:01pm
> >
> > -0.83
> >
> > 84.78
> >
> > 84.78
> >
> > 83.27
> >
> > 3597584
> >
> > 6. I am NOT sure IF the portion of VBA handling
"...'------------------>
> > Set the quotes delimiter based on server prefix.." considers my
location /
> > yahoo server etc
> >
> > hence this post
> >
> > 7 . If getyahooquotes is going to be a problem what the next best
> > alternative for
> > - last price,
> > - 52 week high ,
> > - 52 week low,
> > - PE and
> > - market cap ?
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.9.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Fri May 18, 2012 2:28 pm (PDT)

I have to log off ... so pl. bear with me IF I don't answer the next few hours ... THANKS !!

--- In smf_addin@yahoogroups.com, "Subu S" <mail_to_subu@...> wrote:
>
> Thanks Randy !!
>
> This is what I get
>
>
> RCHGetElementNumber("Version")
>
> Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> Files\SMF Add-in; 1)
>
> RCHGetYahooQuotes("MMM","l1")
>
> Error
>
> RCHGetYahooQuotes("MMM","t1")
>
> Error
>
>
> RCHGetWebData("http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl\
> 1&e=.csv",1)
>
> Error
> <http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.csv>
>
>
> regards
>
>
>
>
>
>
>
>
>
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@>
> wrote:
> >
> > What do you get with:
> >
> > =RCHGetElementNumber("Version")
> > =RCHGetYahooQuotes("MMM","l1")
> > =RCHGetYahooQuotes("MMM","t1")
> > =RCHGetWebData("
> > http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.csv",1)
> >
> > For alternative sources of the items you mention, take a look at the
> FinViz
> > entry in the "Links" area of the group.
> >
> > On Fri, May 18, 2012 at 2:06 PM, Subu S mail_to_subu@ wrote:
> >
> > >
> > > Hate to trouble you, Still posting as I see no other way out
> > > 1. GetYahooQuotes is not working since the last 7 .. 8 hours
> > >
> > > 2. I suspect yahoo may have changed my "location" yesterday / today
> etc ;
> > >
> > > 3. I live in the middle east
> > >
> > > 4. When I try to get quotes for MMM from finance.yahoo.com, I am
> sent /
> > > redirected to http://finance.yahoo.com/q?s=MMM [do NOT know IF this
> was
> > > the case a few days ago, but this is what it is now]
> > >
> > > 5. When I click on download data (delayed) bottom right hand corner
> of
> > > above page, I get to
> > >
> http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1d1t1c1ohgv&e=.\
> csvwhich is shortened would be
> > > http://bit.ly/MsRGnc
> > >
> > > The shortened link was given to avoid yahoo breaking long links
> ..nothing
> > > else
> > >
> > > The csv file looks like this
> > >
> > > MMM
> > >
> > > 83.51
> > >
> > > 5/18/2012
> > >
> > > 4:01pm
> > >
> > > -0.83
> > >
> > > 84.78
> > >
> > > 84.78
> > >
> > > 83.27
> > >
> > > 3597584
> > >
> > > 6. I am NOT sure IF the portion of VBA handling
> "...'------------------>
> > > Set the quotes delimiter based on server prefix.." considers my
> location /
> > > yahoo server etc
> > >
> > > hence this post
> > >
> > > 7 . If getyahooquotes is going to be a problem what the next best
> > > alternative for
> > > - last price,
> > > - 52 week high ,
> > > - 52 week low,
> > > - PE and
> > > - market cap ?
> > >
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.10.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

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

Fri May 18, 2012 2:36 pm (PDT)

Looks like EXCEL isn't letting you get to Yahoo. Can you use the EXCEL Web
Query dialog and navigate to this web page without a problem? Does it
redirect you, or do messages come up?

http://finance.yahoo.com/q?s=MMM

Can you access other web pages with EXCEL? What do you get with:

=RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")
=RCHGetWebData("http://www.google.com/finance?q=MMM",1,20)

On Fri, May 18, 2012 at 2:25 PM, Subu S <mail_to_subu@yahoo.com> wrote:

>
> This is what I get
>
> RCHGetElementNumber("Version")
>
> Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> Files\SMF Add-in; 1)
>
> RCHGetYahooQuotes("MMM","l1")
>
> Error
>
> RCHGetYahooQuotes("MMM","t1")
>
> Error
>
>
> RCHGetWebData("
> http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.csv",1)
>
> *Error <http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.csv>
> *
>
>
> regards
>
>
>
>
>
>
>
>
>
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > What do you get with:
> >
> > =RCHGetElementNumber("Version")
> > =RCHGetYahooQuotes("MMM","l1")
> > =RCHGetYahooQuotes("MMM","t1")
> > =RCHGetWebData("
> > http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.csv",1)
> >
> > For alternative sources of the items you mention, take a look at the
> FinViz
> > entry in the "Links" area of the group.
> >
> > On Fri, May 18, 2012 at 2:06 PM, Subu S mail_to_subu@... wrote:
> >
> > >
> > > Hate to trouble you, Still posting as I see no other way out
> > > 1. GetYahooQuotes is not working since the last 7 .. 8 hours
> > >
> > > 2. I suspect yahoo may have changed my "location" yesterday / today
> etc ;
> > >
> > > 3. I live in the middle east
> > >
> > > 4. When I try to get quotes for MMM from finance.yahoo.com, I am sent
> /
> > > redirected to http://finance.yahoo.com/q?s=MMM [do NOT know IF this
> was
> > > the case a few days ago, but this is what it is now]
> > >
> > > 5. When I click on download data (delayed) bottom right hand corner of
> > > above page, I get to
> > >
> http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1d1t1c1ohgv&e=.csvwhichis shortened would be
> > > http://bit.ly/MsRGnc
> > >
> > > The shortened link was given to avoid yahoo breaking long links
> ..nothing
> > > else
> > >
> > > The csv file looks like this
> > >
> > > MMM
> > >
> > > 83.51
> > >
> > > 5/18/2012
> > >
> > > 4:01pm
> > >
> > > -0.83
> > >
> > > 84.78
> > >
> > > 84.78
> > >
> > > 83.27
> > >
> > > 3597584
> > >
> > > 6. I am NOT sure IF the portion of VBA handling
> "...'------------------>
> > > Set the quotes delimiter based on server prefix.." considers my
> location /
> > > yahoo server etc
> > >
> > > hence this post
> > >
> > > 7 . If getyahooquotes is going to be a problem what the next best
> > > alternative for
> > > - last price,
> > > - 52 week high ,
> > > - 52 week low,
> > > - PE and
> > > - market cap ?
> > >
> >
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.11.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

Posted by: "Subu S" mail_to_subu@yahoo.com   mail_to_subu

Fri May 18, 2012 10:19 pm (PDT)

You are amazing Randy

> Looks like EXCEL isn't letting you get to Yahoo.

Yes. I realise that Now :-(

>Can you use the EXCEL Web
> Query dialog and navigate to this web page without a problem? Does it
> redirect you, or do messages come up?
> http://finance.yahoo.com/q?s=MMM

When I copy paste http://finance.yahoo.com/q?s=MMM to a cell in XL and
hold the control key and click on the URL (within XL) nothing happens !!

So click hyperlink and open [from XL ] is not working !

Other responses given below

Command

Result

http://finance.yahoo.com/q?s=MMM <http://finance.yahoo.com/q?s=MMM>

NO <http://finance.yahoo.com/q?s=MMM> response !!

RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")

=RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")

RCHGetWebData("http://www.google.com/finance?q=MMM",1,20)

<!DOCTYPE html><html

I've ensured that the Stock Market functions add in is running before I
tried the RCHGetTableCell / GetWebData functions & on my machine, XL ->
Tools -> Macro -> security level is set to "Low"

So the question is : Is this some "options" parameter that I have
wrongly set or accidentally changed ?

thanks and regards

Subu

>
> Can you access other web pages with EXCEL? What do you get with:
>
> =RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")
> =RCHGetWebData("http://www.google.com/finance?q=MMM",1,20)
>
> On Fri, May 18, 2012 at 2:25 PM, Subu S mail_to_subu@... wrote:

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

3.12.

Re: RCHGetYahooQuotes() - TO : Andy and digsupply

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

Fri May 18, 2012 10:30 pm (PDT)

Please don't set your macro setting to Low -- it leaves you exposed to
viruses, and won't make any difference to the add-in. The very fact that
you've added it via the Add-In Manger means it satisfies all security
checks.

I didn't want you to link to the URL from a cell, but enter the URL in the
address bar of the EXCEL Web Query dialog (keyboard shortcut alt+d+d+w). I
want to see if it redirects you or gives you some diagnostic message.

The add-in appears to be working, but accessing Yahoo is a problem.

On Fri, May 18, 2012 at 10:19 PM, Subu S <mail_to_subu@yahoo.com> wrote:

>
> You are amazing Randy
>
> > Looks like EXCEL isn't letting you get to Yahoo.
>
> Yes. I realise that Now :-(
>
> >Can you use the EXCEL Web
> > Query dialog and navigate to this web page without a problem? Does it
> > redirect you, or do messages come up?
> > http://finance.yahoo.com/q?s=MMM
>
> When I copy paste http://finance.yahoo.com/q?s=MMM to a cell in XL and
> hold the control key and click on the URL (within XL) nothing happens !!
>
> So click hyperlink and open [from XL ] is not working !
>
> Other responses given below
>
> Command
>
> Result
>
> *http://finance.yahoo.com/q?s=MMM*
>
> *NO <http://finance.yahoo.com/q?s=MMM> response !!*
>
>
> RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")
>
>
> =RCHGetTableCell("http://www.google.com/finance?q=MMM",1,">P/E")
>
> RCHGetWebData("http://www.google.com/finance?q=MMM",1,20)
>
> <!DOCTYPE html><html
>
>
> I've ensured that the Stock Market functions add in is running before I
> tried the RCHGetTableCell / GetWebData functions & on my machine, XL ->
> Tools -> Macro -> security level is set to "Low"
>
> So the question is : Is this some "options" parameter that I have wrongly
> set or accidentally changed ?
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (55)

4a.

smf-element 1

Posted by: "Jason" xxjaysonxx@aol.com   g3m1n1980

Fri May 18, 2012 12:55 pm (PDT)

Randy,

I was just reviewing the code and trying to understand why you are using the URL below which shows stock-report when most of the finding are on /stock-prices with MSN.

Obviously im not understanding the best way to get to a website to validate the source? If this is in the help section, I apologize in advance.

http://investing.money.msn.com/investments/stock-report?

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4b.

Re: smf-element 1

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

Fri May 18, 2012 1:03 pm (PDT)

Because MOST of the stuff is NOT on /stock-prices. Maybe just the most
common things you use.

The /stock-report path is a print report that contains everything. So only
one web page needs to be retrieved to get at all the different data items.

For example, none of the 100+ data elements from the 10-year summary are on
/stock-prices.

On Fri, May 18, 2012 at 12:55 PM, Jason <xxjaysonxx@aol.com> wrote:

> Randy,
>
> I was just reviewing the code and trying to understand why you are using
> the URL below which shows stock-report when most of the finding are on
> /stock-prices with MSN.
>
> Obviously im not understanding the best way to get to a website to
> validate the source? If this is in the help section, I apologize in
> advance.
>
> http://investing.money.msn.com/investments/stock-report?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4c.

Re: smf-element 1

Posted by: "Jason Strauss" xxjaysonxx@aol.com   g3m1n1980

Fri May 18, 2012 1:33 pm (PDT)

I couldn't get to the URL stock report which is what started my question.

Do you have an exact URL?

Sent from my iPhone

On May 18, 2012, at 4:03 PM, Randy Harmelink <rharmelink@gmail.com> wrote:

> Because MOST of the stuff is NOT on /stock-prices. Maybe just the most common things you use.
>
> The /stock-report path is a print report that contains everything. So only one web page needs to be retrieved to get at all the different data items.
>
> For example, none of the 100+ data elements from the 10-year summary are on /stock-prices.
>
>
> On Fri, May 18, 2012 at 12:55 PM, Jason <xxjaysonxx@aol.com> wrote:
> Randy,
>
> I was just reviewing the code and trying to understand why you are using the URL below which shows stock-report when most of the finding are on /stock-prices with MSN.
>
> Obviously im not understanding the best way to get to a website to validate the source? If this is in the help section, I apologize in advance.
>
> http://investing.money.msn.com/investments/stock-report?
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4d.

Re: smf-element 1

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

Fri May 18, 2012 1:37 pm (PDT)

Here's how to create it -- go to a stock home page:

http://investing.money.msn.com/investments/stock-price?Symbol=MMM

...and click on the printer icon near the upper right-hand corner of the
page. Click "Select All" and then "Generate Report".

That's it. In this case, with MMM:

http://investing.money.msn.com/investments/stock-report?symbol=MMM&QD=1&OP=1&Y1=1&CR=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1

Each of the "=1" values are telling the print report to create a section of
the print report.

On Fri, May 18, 2012 at 1:33 PM, Jason Strauss <xxjaysonxx@aol.com> wrote:

>
> I couldn't get to the URL stock report which is what started my question.
>
> Do you have an exact URL?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4e.

Re: smf-element 1

Posted by: "Jason Strauss" xxjaysonxx@aol.com   g3m1n1980

Fri May 18, 2012 1:44 pm (PDT)

Worked perfect. I would say your the man but you probably already know that.

Sent from my iPhone

On May 18, 2012, at 4:37 PM, Randy Harmelink <rharmelink@gmail.com> wrote:

> Here's how to create it -- go to a stock home page:
>
> http://investing.money.msn.com/investments/stock-price?Symbol=MMM
>
> ...and click on the printer icon near the upper right-hand corner of the page. Click "Select All" and then "Generate Report".
>
> That's it. In this case, with MMM:
>
> http://investing.money.msn.com/investments/stock-report?symbol=MMM&QD=1&OP=1&Y1=1&CR=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1
>
> Each of the "=1" values are telling the print report to create a section of the print report.
>
>
> On Fri, May 18, 2012 at 1:33 PM, Jason Strauss <xxjaysonxx@aol.com> wrote:
>
> I couldn't get to the URL stock report which is what started my question.
>
> Do you have an exact URL?
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

5a.

Download the add-in for excel 2011

Posted by: "eddieo34ob" eddieo34ob@gmail.com   eddieo34ob

Fri May 18, 2012 1:23 pm (PDT)

For some reason when I download the add-in, I am receiving the name error?

Any solutions/troubleshooting tips?

Back to top

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

5b.

Re: Download the add-in for excel 2011

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

Fri May 18, 2012 1:26 pm (PDT)

A very ambiguous question. I can only guess at what's happening.

If you're receiving an error when downloading, I need more details.

If you're getting #NAME? errors, check out the item on location errors in
the "Links" area of the group.

On Fri, May 18, 2012 at 1:05 PM, eddieo34ob <eddieo34ob@gmail.com> wrote:

> For some reason when I download the add-in, I am receiving the name error?
>
> Any solutions/troubleshooting tips?
>

Back to top

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

6a.

Rchgetelement errors

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

Fri May 18, 2012 10:08 pm (PDT)

Randy,

I am using SMF version Version 2.1.2012.04.07 with the smf-elements-1 that was uploaded in the works-in-progress folder

I am getting error return messages for rchgetelementnumber(s)

ex: 24,25,118,and many others

I tried rebooting the excel program with no luck.

Thanks

Back to top

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

6b.

Re: Rchgetelement errors

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

Fri May 18, 2012 10:23 pm (PDT)

What do you get for:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",3)
=smfGetAParms(3)
=smfGetAParms(25)

Have you tried visiting the MSN web site using the EXCEL Web Query dialog?
For example:

http://investing.money.msn.com/investments/stock-price?Symbol=mmm

Does it redirect you to a different web address?

On Fri, May 18, 2012 at 10:08 PM, broberts1745 <broberts1745@yahoo.com>wrote:

>
> I am using SMF version Version 2.1.2012.04.07 with the smf-elements-1 that
> was uploaded in the works-in-progress folder
>
> I am getting error return messages for rchgetelementnumber(s)
>
> ex: 24,25,118,and many others
>
> I tried rebooting the excel program with no luck.
>
> Thanks
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

Back to top

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

Recent Activity

•  84
  New Members

Visit Your Group

Yahoo! News

Fashion News

What's the word on

fashion and style?

Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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

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