Messages In This Digest (6 Messages)
- 1a.
- Re: Correlation Data From: Randy Harmelink
- 1b.
- Re: Correlation Data From: oyz79
- 1c.
- Re: Correlation Data From: Randy Harmelink
- 2a.
- Re: Hi, Japanese Tickers earning date From: Chirag Vyas
- 2b.
- Re: Hi, Japanese Tickers earning date From: Chirag Vyas
- 3a.
- Re: Info on csv download From: bagzigingahouse
Messages
- 1a.
-
Re: Correlation Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed May 16, 2012 8:17 pm (PDT)
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@yahoo.com > wrote:
> ETF Replay shows -.64 as does Assetcorrelation.com. ETF Replay uses
> adjusted data, not sure about assetcorrelation.com
>
- 1b.
-
Re: Correlation Data
Posted by: "oyz79" oyz79@yahoo.com oyz79
Wed May 16, 2012 8:25 pm (PDT)
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
> >
>
- 1c.
-
Re: Correlation Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed May 16, 2012 8:38 pm (PDT)
Just compute the daily percentage changes from the adjusted closing prices,
and run the correlations on them.
On Wed, May 16, 2012 at 8:25 PM, oyz79 <oyz79@yahoo.com > wrote:
> 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?
>
- 2a.
-
Re: Hi, Japanese Tickers earning date
Posted by: "Chirag Vyas" vyas.chirag@yahoo.in vyas.chirag
Wed May 16, 2012 11:05 pm (PDT)
Thanks, that really helped but is there anyway that I can get the most recent earnings. Like earnings about to come in May or already came last month in April. Like 60 days before Today and 60 days after today? This formula fetches earnings even for 2013.
Regards,
Chirag Vyas,
(+91)9833630022
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, 16 May 2012 11:40 PM
Subject: Re: [smf_addin] Re: Hi, Japanese Tickers earning date
If all you want is the latest date in the list from earnings.com:
=RCHGetTableCell("http://www.earnings .com/company. ",7, ">Earnings Releases","Date/asp?client= cb&ticker= 2651.t Time",,,1)
On Wed, May 16, 2012 at 5:20 AM, Chirag Vyas <vyas.chirag@yahoo.in > wrote:
>
>Hi, sorry forgot to mention that we should add .T after every ticker in earnings.com. Yahoo do not keep Japanese tickers info IMO. 2651.T does the trick.
>
- 2b.
-
Re: Hi, Japanese Tickers earning date
Posted by: "Chirag Vyas" vyas.chirag@yahoo.in vyas.chirag
Wed May 16, 2012 11:14 pm (PDT)
To be precise, I need latest quarter earnings. Mostly all companies will have March as their latest quarter or in some cases Feb but 90% are March quarter. Also means Q4 2012 earnings from earning.com.
Regards,
Chirag Vyas,
(+91)9833630022
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, 16 May 2012 11:40 PM
Subject: Re: [smf_addin] Re: Hi, Japanese Tickers earning date
If all you want is the latest date in the list from earnings.com:
=RCHGetTableCell("http://www.earnings .com/company. ",7, ">Earnings Releases","Date/asp?client= cb&ticker= 2651.t Time",,,1)
On Wed, May 16, 2012 at 5:20 AM, Chirag Vyas <vyas.chirag@yahoo.in > wrote:
>
>Hi, sorry forgot to mention that we should add .T after every ticker in earnings.com. Yahoo do not keep Japanese tickers info IMO. 2651.T does the trick.
>
- 3a.
-
Re: Info on csv download
Posted by: "bagzigingahouse" bagzigingahouse@gmail.com bagzigingahouse
Thu May 17, 2012 12:15 am (PDT)
Hmm, it seems that it is not the popup after all. Just checked on Win7 and the popup is also there. Only problem that remains on Win7 is the date format, but i guess i will have to put some effort into that to figure it out.
Thanks for helping Randy
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You don't need to use the web query option to get the csv -- it just
> creates a cookie for the web site. You can just cancel out of the web query
> after visiting the web site.
>
> On Wed, May 16, 2012 at 10:43 AM, bagzigingahouse <bagzigingahouse@...
> > wrote:
>
> > Yea, but the problem is that i dont get the popup when using smf, only
> > when clicking on the link itself.
> > And not sure how to use the web query option for getting the csv...
> >
>
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