13 New Messages
Digest #2494
Messages
Sun Feb 3, 2013 8:17 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
I suggest you start by reviewing previous messages as updating quotes is a
common issue.
Look back thru the messages and you will find a link to a great document on
the step-by-step startup using SMF-addin
You might also, review the many files in the "Files" section starting with
the doc function. Checkout the Templates folder great starting point.
What do you mean by auto-update? There is a template for pulling yahoo
quotes. You can modify it to do whatever you want.
Also, Randy left the VBA source open so you can add your own VBA routines
should you need any.
Welcome aboard.
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of hendra_raghani_2000
Sent: Sunday, February 03, 2013 7:35 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Historical Quote Auto Populate
Hey guys, firstly I am so glad I found this community because I have been
wondering how do some people keep their Excel sheets linked to the data on
the web and update on new data...
I want to ask, how do I use this auto-update function for the historical
quotes for certain tickers within a certain time range I need? Say
historical quotes from Jan 2000 to Jan 2013.
Thanks a lot!
------------------------------------
Yahoo! Groups Links
common issue.
Look back thru the messages and you will find a link to a great document on
the step-by-step startup using SMF-addin
You might also, review the many files in the "Files" section starting with
the doc function. Checkout the Templates folder great starting point.
What do you mean by auto-update? There is a template for pulling yahoo
quotes. You can modify it to do whatever you want.
Also, Randy left the VBA source open so you can add your own VBA routines
should you need any.
Welcome aboard.
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Of hendra_raghani_
Sent: Sunday, February 03, 2013 7:35 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Historical Quote Auto Populate
Hey guys, firstly I am so glad I found this community because I have been
wondering how do some people keep their Excel sheets linked to the data on
the web and update on new data...
I want to ask, how do I use this auto-update function for the historical
quotes for certain tickers within a certain time range I need? Say
historical quotes from Jan 2000 to Jan 2013.
Thanks a lot!
------------
Yahoo! Groups Links
Sun Feb 3, 2013 5:57 pm (PST) . Posted by:
"Hendra Raghani" hendra_raghani_2000
Hey Randy and Kermit,
Thanks for your replies. I actually did find the file before posting the
questions but am not as savvy in Excel to tinker withe the VBA
resources. What I meant was, I wanted to know how did some people leave
their Excel documents to auto populate as new information is available
online - instead of hopping over to the website , select, copy and paste
it in Excel.
I took a look at the RCHGetYahooHistory(), but how do you modify it such
that I don't get the daily updates. I only need the data once a month,
which is the closing price.
Thank you once again!
On 4/2/2013 12:17 AM, Kermit W. Prather wrote:
>
> I suggest you start by reviewing previous messages as updating quotes is a
> common issue.
> Look back thru the messages and you will find a link to a great
> document on
> the step-by-step startup using SMF-addin
>
> You might also, review the many files in the "Files" section starting with
> the doc function. Checkout the Templates folder great starting point.
>
> What do you mean by auto-update? There is a template for pulling yahoo
> quotes. You can modify it to do whatever you want.
>
> Also, Randy left the VBA source open so you can add your own VBA routines
> should you need any.
>
> Welcome aboard.
>
> Kermit
>
Why in the heck would you want to auto-update historical quotes? Yahoo
only changes them once per day.
Just use the RCHGetYahooHistory() as you need the quotes...
>
>
> -----Original Message-----
> From: smf_addin@yahoogroups.com
> [mailto:smf_addin@yahoogroups.com
> ] On Behalf
> Of hendra_raghani_2000
> Sent: Sunday, February 03, 2013 7:35 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Historical Quote Auto Populate
>
> Hey guys, firstly I am so glad I found this community because I have been
> wondering how do some people keep their Excel sheets linked to the data on
> the web and update on new data...
>
> I want to ask, how do I use this auto-update function for the historical
> quotes for certain tickers within a certain time range I need? Say
> historical quotes from Jan 2000 to Jan 2013.
>
> Thanks a lot!
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
Thanks for your replies. I actually did find the file before posting the
questions but am not as savvy in Excel to tinker withe the VBA
resources. What I meant was, I wanted to know how did some people leave
their Excel documents to auto populate as new information is available
online - instead of hopping over to the website , select, copy and paste
it in Excel.
I took a look at the RCHGetYahooHistory(
that I don't get the daily updates. I only need the data once a month,
which is the closing price.
Thank you once again!
On 4/2/2013 12:17 AM, Kermit W. Prather wrote:
>
> I suggest you start by reviewing previous messages as updating quotes is a
> common issue.
> Look back thru the messages and you will find a link to a great
> document on
> the step-by-step startup using SMF-addin
>
> You might also, review the many files in the "Files" section starting with
> the doc function. Checkout the Templates folder great starting point.
>
> What do you mean by auto-update? There is a template for pulling yahoo
> quotes. You can modify it to do whatever you want.
>
> Also, Randy left the VBA source open so you can add your own VBA routines
> should you need any.
>
> Welcome aboard.
>
> Kermit
>
Why in the heck would you want to auto-update historical quotes? Yahoo
only changes them once per day.
Just use the RCHGetYahooHistory(
>
>
> -----Original Message-----
> From: smf_addin@yahoogrou
> [mailto:smf_addin@yahoogrou
> ] On Behalf
> Of hendra_raghani_
> Sent: Sunday, February 03, 2013 7:35 AM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] Historical Quote Auto Populate
>
> Hey guys, firstly I am so glad I found this community because I have been
> wondering how do some people keep their Excel sheets linked to the data on
> the web and update on new data...
>
> I want to ask, how do I use this auto-update function for the historical
> quotes for certain tickers within a certain time range I need? Say
> historical quotes from Jan 2000 to Jan 2013.
>
> Thanks a lot!
>
> ------------
>
> Yahoo! Groups Links
>
>
Sun Feb 3, 2013 6:02 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
If all you need is closing quotes once a month, you'd be best off using the
RCHGetYahooQuotes() function at the end of the month. It can grab data on
up to 200 stocks at a time with a single Internet access. Very fast.
The add-in functions typically automatically recalculate when you open a
workbook.
The functions mean you don't need to do the copy and paste from the website.
On Sun, Feb 3, 2013 at 6:53 PM, Hendra Raghani
hendra_raghani@hotmail.com >wrote:
>
> Thanks for your replies. I actually did find the file before posting the
> questions but am not as savvy in Excel to tinker withe the VBA resources.
> What I meant was, I wanted to know how did some people leave their Excel
> documents to auto populate as new information is available online - instead
> of hopping over to the website , select, copy and paste it in Excel.
>
> I took a look at the RCHGetYahooHistory(), but how do you modify it such
> that I don't get the daily updates. I only need the data once a month,
> which is the closing price.
>
RCHGetYahooQuotes(
up to 200 stocks at a time with a single Internet access. Very fast.
The add-in functions typically automatically recalculate when you open a
workbook.
The functions mean you don't need to do the copy and paste from the website.
On Sun, Feb 3, 2013 at 6:53 PM, Hendra Raghani
hendra_raghani@
>
> Thanks for your replies. I actually did find the file before posting the
> questions but am not as savvy in Excel to tinker withe the VBA resources.
> What I meant was, I wanted to know how did some people leave their Excel
> documents to auto populate as new information is available online - instead
> of hopping over to the website , select, copy and paste it in Excel.
>
> I took a look at the RCHGetYahooHistory(
> that I don't get the daily updates. I only need the data once a month,
> which is the closing price.
>
Mon Feb 4, 2013 7:39 am (PST) . Posted by:
"Michael Thomas" thomas91112
Try using the "monthly" variable, =RCHGetYahooHistory(D$1,D$4,D$5,1,A$2,A$3,1,"m","A",0,0,1)
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, February 3, 2013 6:02 PM
Subject: Re: [smf_addin] Historical Quote Auto Populate
If all you need is closing quotes once a month, you'd be best off using the RCHGetYahooQuotes() function at the end of the month. It can grab data on up to 200 stocks at a time with a single Internet access. Very fast.
The add-in functions typically automatically recalculate when you open a workbook.
The functions mean you don't need to do the copy and paste from the website.
On Sun, Feb 3, 2013 at 6:53 PM, Hendra Raghani hendra_raghani@hotmail.com > wrote:
>
>Thanks for your replies. I actually did find the file before posting the questions but am not as savvy in Excel to tinker withe the VBA resources. What I meant was, I wanted to know how did some people leave their Excel documents to auto populate as new information is available online - instead of hopping over to the website , select, copy and paste it in Excel.
>
>I took a look at the RCHGetYahooHistory(), but how do you modify
it such that I don't get the daily updates. I only need the data
once a month, which is the closing price.
>
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Sunday, February 3, 2013 6:02 PM
Subject: Re: [smf_addin] Historical Quote Auto Populate
If all you need is closing quotes once a month, you'd be best off using the RCHGetYahooQuotes(
The add-in functions typically automatically recalculate when you open a workbook.
The functions mean you don't need to do the copy and paste from the website.
On Sun, Feb 3, 2013 at 6:53 PM, Hendra Raghani hendra_raghani@
>
>Thanks for your replies. I actually did find the file before posting the questions but am not as savvy in Excel to tinker withe the VBA resources. What I meant was, I wanted to know how did some people leave their Excel documents to auto populate as new information is available online - instead of hopping over to the website , select, copy and paste it in Excel.
>
>I took a look at the RCHGetYahooHistory(
it such that I don't get the daily updates. I only need the data
once a month, which is the closing price.
>
Sun Feb 3, 2013 8:31 pm (PST) . Posted by:
"gz_cp" gz_cp
Thanks, calhandon and Randy.
--- In smf_addin@yahoogrou
>
> Try ...
>
> Tools - Internet Options - General Tab, "Browsing History" section, click
> "Settings"
>
>
>
> From: smf_addin@yahoogrou
> Of gz_cp
> Sent: Friday, February 01, 2013 1:33 AM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] Internet Explorer Cache Setting
>
>
> Randy,
>
> I remembered I needed to set somewhere in IE's Options so that everytime I
> run the Add-on functions it always tries to get the latest data rather than
> reading from the cache for old data.
>
> But I couldn't find where in Option I should set in my IE9 now.
>
> Could you please remind me?
>
> Thank you.
>
> XP
>
Sun Feb 3, 2013 11:00 pm (PST) . Posted by:
"Jim Blarry" jimblarry
This isn't a specific SMF question, but rather a question about performing DCF's. You seem like the right guy to ask. Wouldn't growing out free cash flow further and further just give me a greater intrinsic value? I mean if I grew them out 20 years instead of 10 years, then my present value of future cash flows would just be greater, right? And that would give me a greater intrinsic value. Any help would be appreciated, thanks.
Jim
Jim
Sun Feb 3, 2013 11:21 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I don't do DCF. Anybody else?
On Sun, Feb 3, 2013 at 11:26 PM, Jim Blarry jimblarry@yahoo.com > wrote:
>
> This isn't a specific SMF question, but rather a question about performing
> DCF's. You seem like the right guy to ask. Wouldn't growing out free cash
> flow further and further just give me a greater intrinsic value? I mean if
> I grew them out 20 years instead of 10 years, then my present value of
> future cash flows would just be greater, right? And that would give me a
> greater intrinsic value. Any help would be appreciated, thanks.
>
>
On Sun, Feb 3, 2013 at 11:26 PM, Jim Blarry jimblarry@yahoo.
>
> This isn't a specific SMF question, but rather a question about performing
> DCF's. You seem like the right guy to ask. Wouldn't growing out free cash
> flow further and further just give me a greater intrinsic value? I mean if
> I grew them out 20 years instead of 10 years, then my present value of
> future cash flows would just be greater, right? And that would give me a
> greater intrinsic value. Any help would be appreciated, thanks.
>
>
Mon Feb 4, 2013 2:34 am (PST) . Posted by:
"Cesar Augusto Crivelli" cesarcrivelli
Hi Jim,
I dont know if I properly understand your question... Did you exposed that if you extend the number of projected years, from 10 to 20, this would provide a better estimate of the entire cash flow, or target price?
If it is your doubt, I would say that in my opinion, more years of projection can add some extra value to the final price, but only by removing some uncertainty present in the Terminal value.
Look, you have to bring these cash flows to present value, then they will represent a small portion of the total, as they go to forward.
I made an example, which is attached to this email.
In the first part of the spreadsheet you have 10 years of cash flow (FCF), discounted at 10%. In this case the explicit period (10 years) represent 62.10% of the final value and the rest 37.90% comes from the Terminal Value
In the second part you will find 20 years of projection, discounted at the same rate - 10%. Here 59.85% of the total value is from the first 10 years of projection, then 24.84% comes from the another 10 years, as you mentioned, and only 15.31% is from the Terminal Value.
Note that the main diference between the projections is that in the second you reduced the terminal weight in the final price, as you have more years in the explicit period.
Is this good? I am not an expert on valuation, since my carrer as analyst was more focused in Technical Analysis than in Fundamental, but in my opinion, to increase the number of projected years (explicit period), you must be sure of the assumptions you are using, otherwise, use 5 or 10 years, because uncertainty is already inside of the terminal value, so you shouldnt add more in the explicit period.
Hope it helps
Best,
Cesar
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Sorry, but I don't do DCF. Anybody else?
>
> On Sun, Feb 3, 2013 at 11:26 PM, Jim Blarry wrote:
>
> >
> > This isn't a specific SMF question, but rather a question about performing
> > DCF's. You seem like the right guy to ask. Wouldn't growing out free cash
> > flow further and further just give me a greater intrinsic value? I mean if
> > I grew them out 20 years instead of 10 years, then my present value of
> > future cash flows would just be greater, right? And that would give me a
> > greater intrinsic value. Any help would be appreciated, thanks.
> >
> >
>
I dont know if I properly understand your question... Did you exposed that if you extend the number of projected years, from 10 to 20, this would provide a better estimate of the entire cash flow, or target price?
If it is your doubt, I would say that in my opinion, more years of projection can add some extra value to the final price, but only by removing some uncertainty present in the Terminal value.
Look, you have to bring these cash flows to present value, then they will represent a small portion of the total, as they go to forward.
I made an example, which is attached to this email.
In the first part of the spreadsheet you have 10 years of cash flow (FCF), discounted at 10%. In this case the explicit period (10 years) represent 62.10% of the final value and the rest 37.90% comes from the Terminal Value
In the second part you will find 20 years of projection, discounted at the same rate - 10%. Here 59.85% of the total value is from the first 10 years of projection, then 24.84% comes from the another 10 years, as you mentioned, and only 15.31% is from the Terminal Value.
Note that the main diference between the projections is that in the second you reduced the terminal weight in the final price, as you have more years in the explicit period.
Is this good? I am not an expert on valuation, since my carrer as analyst was more focused in Technical Analysis than in Fundamental, but in my opinion, to increase the number of projected years (explicit period), you must be sure of the assumptions you are using, otherwise, use 5 or 10 years, because uncertainty is already inside of the terminal value, so you shouldnt add more in the explicit period.
Hope it helps
Best,
Cesar
--- In smf_addin@yahoogrou
>
> Sorry, but I don't do DCF. Anybody else?
>
> On Sun, Feb 3, 2013 at 11:26 PM, Jim Blarry wrote:
>
> >
> > This isn't a specific SMF question, but rather a question about performing
> > DCF's. You seem like the right guy to ask. Wouldn't growing out free cash
> > flow further and further just give me a greater intrinsic value? I mean if
> > I grew them out 20 years instead of 10 years, then my present value of
> > future cash flows would just be greater, right? And that would give me a
> > greater intrinsic value. Any help would be appreciated, thanks.
> >
> >
>
Attachments with this message:
1 of 1 File(s)
Mon Feb 4, 2013 2:54 am (PST) . Posted by:
"another_investor" another_investor
Hi Randy (et al),
I have been using your excellent plugin on Windows 7 64-bit with Excel 2010 32-bit for a few years now but recently got a new i7 PC with 16-gig and was considering making the switch to 64-bit Office 2010/2013 to take advantage of the increased RAM.
Questions that spring to mind include:
1) Is this advisable please?
2) Any known limitations/issues?
3) If I generate a workbook file using the SMF plug-in on a 64-bit Excel machine, could I reuse the same workbook on my 32-bit Excel installation (desktop excel would be 64-bit while my work laptop is 32-bit excel and I would like to be able to use the same workbook on both).
Any advise or recommendations would be great. I will always take stability over performance!
Many thanks for the amazing plug-in development and for sharing knowledge so generously.
Steve
I have been using your excellent plugin on Windows 7 64-bit with Excel 2010 32-bit for a few years now but recently got a new i7 PC with 16-gig and was considering making the switch to 64-bit Office 2010/2013 to take advantage of the increased RAM.
Questions that spring to mind include:
1) Is this advisable please?
2) Any known limitations/
3) If I generate a workbook file using the SMF plug-in on a 64-bit Excel machine, could I reuse the same workbook on my 32-bit Excel installation (desktop excel would be 64-bit while my work laptop is 32-bit excel and I would like to be able to use the same workbook on both).
Any advise or recommendations would be great. I will always take stability over performance!
Many thanks for the amazing plug-in development and for sharing knowledge so generously.
Steve
Mon Feb 4, 2013 5:05 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I can't be of help there, as I have no experience in that area. Sorry.
On Mon, Feb 4, 2013 at 3:54 AM, another_investor
steviejacobs@hotmail.com >wrote:
> Hi Randy (et al),
> I have been using your excellent plugin on Windows 7 64-bit with Excel
> 2010 32-bit for a few years now but recently got a new i7 PC with 16-gig
> and was considering making the switch to 64-bit Office 2010/2013 to take
> advantage of the increased RAM.
>
> Questions that spring to mind include:
> 1) Is this advisable please?
> 2) Any known limitations/issues?
> 3) If I generate a workbook file using the SMF plug-in on a 64-bit Excel
> machine, could I reuse the same workbook on my 32-bit Excel installation
> (desktop excel would be 64-bit while my work laptop is 32-bit excel and I
> would like to be able to use the same workbook on both).
>
> Any advise or recommendations would be great. I will always take stability
> over performance!
>
On Mon, Feb 4, 2013 at 3:54 AM, another_investor
steviejacobs@
> Hi Randy (et al),
> I have been using your excellent plugin on Windows 7 64-bit with Excel
> 2010 32-bit for a few years now but recently got a new i7 PC with 16-gig
> and was considering making the switch to 64-bit Office 2010/2013 to take
> advantage of the increased RAM.
>
> Questions that spring to mind include:
> 1) Is this advisable please?
> 2) Any known limitations/
> 3) If I generate a workbook file using the SMF plug-in on a 64-bit Excel
> machine, could I reuse the same workbook on my 32-bit Excel installation
> (desktop excel would be 64-bit while my work laptop is 32-bit excel and I
> would like to be able to use the same workbook on both).
>
> Any advise or recommendations would be great. I will always take stability
> over performance!
>
Mon Feb 4, 2013 6:52 am (PST) . Posted by:
"Douglas Husemann" eldoen
1). Is a matter of debate,
2) you can make workbooks that may be to large to open in 32 bit excel. Although I doubt that will be an issue with the data being used.
3). Been switching between 32 bit and 64 bit office 2010 &2013 (365) without any issues,
Sent from my Windows Phone
________________________________
From: Randy Harmelinkrharmelink@gmail.com >
Sent: 2/4/2013 7:05 AM
To: smf_addin@yahoogroups.com smf_addin@yahoogroups.com >
Subject: Re: [smf_addin] Excel 32bit vs 64bit
I can't be of help there, as I have no experience in that area. Sorry.
On Mon, Feb 4, 2013 at 3:54 AM, another_investor
steviejacobs@hotmail.com >wrote:
> Hi Randy (et al),
> I have been using your excellent plugin on Windows 7 64-bit with Excel
> 2010 32-bit for a few years now but recently got a new i7 PC with 16-gig
> and was considering making the switch to 64-bit Office 2010/2013 to take
> advantage of the increased RAM.
>
> Questions that spring to mind include:
> 1) Is this advisable please?
> 2) Any known limitations/issues?
> 3) If I generate a workbook file using the SMF plug-in on a 64-bit Excel
> machine, could I reuse the same workbook on my 32-bit Excel installation
> (desktop excel would be 64-bit while my work laptop is 32-bit excel and I
> would like to be able to use the same workbook on both).
>
> Any advise or recommendations would be great. I will always take stability
> over performance!
>
2) you can make workbooks that may be to large to open in 32 bit excel. Although I doubt that will be an issue with the data being used.
3). Been switching between 32 bit and 64 bit office 2010 &2013 (365) without any issues,
Sent from my Windows Phone
____________
From: Randy Harmelinkrharmelink@gmail.
Sent: 2/4/2013 7:05 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Excel 32bit vs 64bit
I can't be of help there, as I have no experience in that area. Sorry.
On Mon, Feb 4, 2013 at 3:54 AM, another_investor
steviejacobs@
> Hi Randy (et al),
> I have been using your excellent plugin on Windows 7 64-bit with Excel
> 2010 32-bit for a few years now but recently got a new i7 PC with 16-gig
> and was considering making the switch to 64-bit Office 2010/2013 to take
> advantage of the increased RAM.
>
> Questions that spring to mind include:
> 1) Is this advisable please?
> 2) Any known limitations/
> 3) If I generate a workbook file using the SMF plug-in on a 64-bit Excel
> machine, could I reuse the same workbook on my 32-bit Excel installation
> (desktop excel would be 64-bit while my work laptop is 32-bit excel and I
> would like to be able to use the same workbook on both).
>
> Any advise or recommendations would be great. I will always take stability
> over performance!
>
Mon Feb 4, 2013 7:19 am (PST) . Posted by:
"fythras" fythras
This isn't really a problem, but I'm more just confused. I created an add-in of a bunch of programs I made. Some using the smf addin and some not. When I load my add-in, I just saw that it loads the smf-addin as well. This even happens when I bring it to a new computer and start up the my add-in. Does it attach to my add-in bc I reference it?
Thanks in advance,
Justin
Thanks in advance,
Justin
Mon Feb 4, 2013 7:27 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I think when you reference it, it tells the VBA environment to load it.
On Mon, Feb 4, 2013 at 8:19 AM, fythras fythras@yahoo.com > wrote:
> This isn't really a problem, but I'm more just confused. I created an
> add-in of a bunch of programs I made. Some using the smf addin and some
> not. When I load my add-in, I just saw that it loads the smf-addin as
> well. This even happens when I bring it to a new computer and start up the
> my add-in. Does it attach to my add-in bc I reference it?
>
On Mon, Feb 4, 2013 at 8:19 AM, fythras fythras@yahoo.
> This isn't really a problem, but I'm more just confused. I created an
> add-in of a bunch of programs I made. Some using the smf addin and some
> not. When I load my add-in, I just saw that it loads the smf-addin as
> well. This even happens when I bring it to a new computer and start up the
> my add-in. Does it attach to my add-in bc I reference it?
>
Tidak ada komentar:
Posting Komentar