8 New Messages
Digest #2287
Messages
Sun Jul 22, 2012 4:39 am (PDT) . Posted by:
"jhfrazer@ymail.com" jhfrazer@ymail.com
Randy,
You know your functions better than anyone. If the goal is to output data for perhaps fifty different stocks (vertical axis). With the data (horiontal axis) being "total return" values for one week, one month, three months, six months, and one year. Which Function or collection of functions would you use to generate the data with a minimum amount of "collection lag time".
I have created the worksheet using GetYahooHistory but it is painfully slow. My thought was to impliment the "bydates" function to individually populate each row but I do not see a switch to use Yahoo "Adjusted" prices which would make the Total Return calculation more straightforward.
I therefore look forward to your suggestions and enligthenment.
Finially, how might we compensate you for your ongoing efforts? You have created and continue to maintain a valuable tool and it seems right that you should benefit from it.
John
You know your functions better than anyone. If the goal is to output data for perhaps fifty different stocks (vertical axis). With the data (horiontal axis) being "total return" values for one week, one month, three months, six months, and one year. Which Function or collection of functions would you use to generate the data with a minimum amount of "collection lag time".
I have created the worksheet using GetYahooHistory but it is painfully slow. My thought was to impliment the "bydates" function to individually populate each row but I do not see a switch to use Yahoo "Adjusted" prices which would make the Total Return calculation more straightforward.
I therefore look forward to your suggestions and enligthenment.
Finially, how might we compensate you for your ongoing efforts? You have created and continue to maintain a valuable tool and it seems right that you should benefit from it.
John
Sun Jul 22, 2012 8:31 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your best bet would be the smfPricesByDates() function, one for each
equity. It only uses adjusted closing prices.
As far as compensation, I just ask that people "pay it forward" by giving a
donation to a worthy charity.
On Sun, Jul 22, 2012 at 4:39 AM, jhfrazer@ymail.com <jhfrazer@ymail.com >wrote:
>
> You know your functions better than anyone. If the goal is to output data
> for perhaps fifty different stocks (vertical axis). With the data
> (horiontal axis) being "total return" values for one week, one month, three
> months, six months, and one year. Which Function or collection of
> functions would you use to generate the data with a minimum amount of
> "collection lag time".
>
> I have created the worksheet using GetYahooHistory but it is painfully
> slow. My thought was to impliment the "bydates" function to individually
> populate each row but I do not see a switch to use Yahoo "Adjusted" prices
> which would make the Total Return calculation more straightforward.
>
> I therefore look forward to your suggestions and enligthenment.
>
> Finially, how might we compensate you for your ongoing efforts? You have
> created and continue to maintain a valuable tool and it seems right that
> you should benefit from it.
>
equity. It only uses adjusted closing prices.
As far as compensation, I just ask that people "pay it forward" by giving a
donation to a worthy charity.
On Sun, Jul 22, 2012 at 4:39 AM, jhfrazer@ymail.
>
> You know your functions better than anyone. If the goal is to output data
> for perhaps fifty different stocks (vertical axis). With the data
> (horiontal axis) being "total return" values for one week, one month, three
> months, six months, and one year. Which Function or collection of
> functions would you use to generate the data with a minimum amount of
> "collection lag time".
>
> I have created the worksheet using GetYahooHistory but it is painfully
> slow. My thought was to impliment the "bydates" function to individually
> populate each row but I do not see a switch to use Yahoo "Adjusted" prices
> which would make the Total Return calculation more straightforward.
>
> I therefore look forward to your suggestions and enligthenment.
>
> Finially, how might we compensate you for your ongoing efforts? You have
> created and continue to maintain a valuable tool and it seems right that
> you should benefit from it.
>
Sun Jul 22, 2012 10:06 am (PDT) . Posted by:
"jhfrazer@ymail.com" jhfrazer@ymail.com
Thank you for the insight. It is greatly appreciated. And I WILL "pay it forward"!
John
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Your best bet would be the smfPricesByDates() function, one for each
> equity. It only uses adjusted closing prices.
>
> As far as compensation, I just ask that people "pay it forward" by giving a
> donation to a worthy charity.
>
> On Sun, Jul 22, 2012 at 4:39 AM, jhfrazer@... <jhfrazer@...>wrote:
>
> >
> > You know your functions better than anyone. If the goal is to output data
> > for perhaps fifty different stocks (vertical axis). With the data
> > (horiontal axis) being "total return" values for one week, one month, three
> > months, six months, and one year. Which Function or collection of
> > functions would you use to generate the data with a minimum amount of
> > "collection lag time".
> >
> > I have created the worksheet using GetYahooHistory but it is painfully
> > slow. My thought was to impliment the "bydates" function to individually
> > populate each row but I do not see a switch to use Yahoo "Adjusted" prices
> > which would make the Total Return calculation more straightforward.
> >
> > I therefore look forward to your suggestions and enligthenment.
> >
> > Finially, how might we compensate you for your ongoing efforts? You have
> > created and continue to maintain a valuable tool and it seems right that
> > you should benefit from it.
> >
>
John
--- In smf_addin@yahoogrou
>
> Your best bet would be the smfPricesByDates(
> equity. It only uses adjusted closing prices.
>
> As far as compensation, I just ask that people "pay it forward" by giving a
> donation to a worthy charity.
>
> On Sun, Jul 22, 2012 at 4:39 AM, jhfrazer@... <jhfrazer@..
>
> >
> > You know your functions better than anyone. If the goal is to output data
> > for perhaps fifty different stocks (vertical axis). With the data
> > (horiontal axis) being "total return" values for one week, one month, three
> > months, six months, and one year. Which Function or collection of
> > functions would you use to generate the data with a minimum amount of
> > "collection lag time".
> >
> > I have created the worksheet using GetYahooHistory but it is painfully
> > slow. My thought was to impliment the "bydates" function to individually
> > populate each row but I do not see a switch to use Yahoo "Adjusted" prices
> > which would make the Total Return calculation more straightforward.
> >
> > I therefore look forward to your suggestions and enligthenment.
> >
> > Finially, how might we compensate you for your ongoing efforts? You have
> > created and continue to maintain a valuable tool and it seems right that
> > you should benefit from it.
> >
>
Sun Jul 22, 2012 10:36 am (PDT) . Posted by:
"jhfrazer@ymail.com" jhfrazer@ymail.com
Randy,
To calculate total return for the past year for example the formula would be (Price today - Adjusted Price one year ago)/Unadjusted one year go.
Is there no way to grab adjusted and/or unadjusted data using the ByDates function?
john
--- In smf_addin@yahoogroups.com , "jhfrazer@..." <jhfrazer@...> wrote:
>
> Randy,
>
> You know your functions better than anyone. If the goal is to output data for perhaps fifty different stocks (vertical axis). With the data (horiontal axis) being "total return" values for one week, one month, three months, six months, and one year. Which Function or collection of functions would you use to generate the data with a minimum amount of "collection lag time".
>
> I have created the worksheet using GetYahooHistory but it is painfully slow. My thought was to impliment the "bydates" function to individually populate each row but I do not see a switch to use Yahoo "Adjusted" prices which would make the Total Return calculation more straightforward.
>
> I therefore look forward to your suggestions and enligthenment.
>
> Finially, how might we compensate you for your ongoing efforts? You have created and continue to maintain a valuable tool and it seems right that you should benefit from it.
>
> John
>
To calculate total return for the past year for example the formula would be (Price today - Adjusted Price one year ago)/Unadjusted one year go.
Is there no way to grab adjusted and/or unadjusted data using the ByDates function?
john
--- In smf_addin@yahoogrou
>
> Randy,
>
> You know your functions better than anyone. If the goal is to output data for perhaps fifty different stocks (vertical axis). With the data (horiontal axis) being "total return" values for one week, one month, three months, six months, and one year. Which Function or collection of functions would you use to generate the data with a minimum amount of "collection lag time".
>
> I have created the worksheet using GetYahooHistory but it is painfully slow. My thought was to impliment the "bydates" function to individually populate each row but I do not see a switch to use Yahoo "Adjusted" prices which would make the Total Return calculation more straightforward.
>
> I therefore look forward to your suggestions and enligthenment.
>
> Finially, how might we compensate you for your ongoing efforts? You have created and continue to maintain a valuable tool and it seems right that you should benefit from it.
>
> John
>
Sun Jul 22, 2012 1:38 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
No.
Total return would be today's adjusted price divided by the year ago
adjusted price. And the adjusted prices are all that smfPricesByDates()
returns.
On Sun, Jul 22, 2012 at 10:36 AM, jhfrazer@ymail.com <jhfrazer@ymail.com >wrote:
>
> To calculate total return for the past year for example the formula would
> be (Price today - Adjusted Price one year ago)/Unadjusted one year go.
>
> Is there no way to grab adjusted and/or unadjusted data using the ByDates
> function?
>
Total return would be today's adjusted price divided by the year ago
adjusted price. And the adjusted prices are all that smfPricesByDates(
returns.
On Sun, Jul 22, 2012 at 10:36 AM, jhfrazer@ymail.
>
> To calculate total return for the past year for example the formula would
> be (Price today - Adjusted Price one year ago)/Unadjusted one year go.
>
> Is there no way to grab adjusted and/or unadjusted data using the ByDates
> function?
>
Mon Jul 23, 2012 2:37 am (PDT) . Posted by:
"Chirag Vyas" vyas.chirag
I need the value of Dividend Yield for several tickers in Excel. This value is mentioned in Google finance as DIV/YIELD.
Mon Jul 23, 2012 2:52 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetTableCell("http://www.google.com/finance?q=MMM ",1,"Div/Yield")
On Mon, Jul 23, 2012 at 2:37 AM, Chirag Vyas <vyas.chirag@yahoo.in > wrote:
> I need the value of Dividend Yield for several tickers in Excel. This
> value is mentioned in Google finance as DIV/YIELD.
>
=RCHGetTableCell(
On Mon, Jul 23, 2012 at 2:37 AM, Chirag Vyas <vyas.chirag@
> I need the value of Dividend Yield for several tickers in Excel. This
> value is mentioned in Google finance as DIV/YIELD.
>
Mon Jul 23, 2012 3:25 am (PDT) . Posted by:
"Chirag Vyas" vyas.chirag
Hi, thanks. Is it possible to get only "Yield" value instead of "Div/Yield"?
Regards,
Chirag Vyas,
(+91)9833630022
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Monday, 23 July 2012 3:22 PM
Subject: Re: [smf_addin] Dividend Yield for tickers from Google Finance
Try:
=RCHGetTableCell("http://www.google.com/finance?q=MMM ",1,"Div/Yield")
On Mon, Jul 23, 2012 at 2:37 AM, Chirag Vyas <vyas.chirag@yahoo.in > wrote:
I need the value of Dividend Yield for several tickers in Excel. This value is mentioned in Google finance as DIV/YIELD.
>
Regards,
Chirag Vyas,
(+91)9833630022
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Monday, 23 July 2012 3:22 PM
Subject: Re: [smf_addin] Dividend Yield for tickers from Google Finance
Try:
=RCHGetTableCell(
On Mon, Jul 23, 2012 at 2:37 AM, Chirag Vyas <vyas.chirag@
I need the value of Dividend Yield for several tickers in Excel. This value is mentioned in Google finance as DIV/YIELD.
>
Tidak ada komentar:
Posting Komentar