11 Messages
Digest #2976
Messages
Fri Feb 21, 2014 9:31 am (PST) . Posted by:
schlange.meister
Is there an element number to get the price? It can be last price, last close price, or something like that. Just want to see the current-ish price to use in a paper trading strategy sheet I have.
Fri Feb 21, 2014 11:48 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Just use the RCHGetYahooQuotes() function for current quotes. For example,
last price would be:
=RCHGetYahooQuotes("MMM","l1")
On Fri, Feb 21, 2014 at 10:31 AM, <schlange.meister@yahoo.com> wrote:
>
> Is there an element number to get the price? It can be last price, last
> close price, or something like that. Just want to see the current-ish price
> to use in a paper trading strategy sheet I have.
>
last price would be:
=RCHGetYahooQuotes(
On Fri, Feb 21, 2014 at 10:31 AM, <schlange.meister@
>
> Is there an element number to get the price? It can be last price, last
> close price, or something like that. Just want to see the current-ish price
> to use in a paper trading strategy sheet I have.
>
Fri Feb 21, 2014 11:45 am (PST) . Posted by:
"R Manning" marshall17043
Smf_addin, RCH_Stock_Market_Functions-2.1.2012.12.29
is not working for me with Excel 2007 and Vista operating system. The add-in
works fine with Excel 2002 on both an XP and Vista operating system. When used
with Excel 2002 the entire set of example templates that I've tried work as expected.
I installed the add-in files in C:\Program Files\SMF
Add-In. I added it to the Active
Application Add-ins section in the Office add-in manager, although it shows as
a .xla file as opposed to other files that show up as .xlam files. It also shows
up on the Add-ins checklist list from the Add-ins icon. The sample workbooks show an error message in
the returned value cells of #NAME? in Excel 2007 on the Vista system.
Any assistance in getting the Smf_addin working with Excel 2007 is greatly appreciated!
is not working for me with Excel 2007 and Vista operating system. The add-in
works fine with Excel 2002 on both an XP and Vista operating system. When used
with Excel 2002 the entire set of example templates that I've tried work as expected.
I installed the add-in files in C:\Program Files\SMF
Add-In. I added it to the Active
Application Add-ins section in the Office add-in manager, although it shows as
a .xla file as opposed to other files that show up as .xlam files. It also shows
up on the Add-ins checklist list from the Add-ins icon. The sample workbooks show an error message in
the returned value cells of #NAME? in Excel 2007 on the Vista system.
Any assistance in getting the Smf_addin working with Excel 2007 is greatly appreciated!
Fri Feb 21, 2014 11:50 am (PST) . Posted by:
"Randy Harmelink" rharmelink
See the "Location Errors" item in the LINKS area of the group. If that's
not your problem, just drop another message.
On Fri, Feb 21, 2014 at 10:04 AM, R Manning <marshall17043@yahoo.com> wrote:
>
> Smf_addin, RCH_Stock_Market_Functions-2.1.2012.12.29 is not working for
> me with Excel 2007 and Vista operating system. The add-in works fine with
> Excel 2002 on both an XP and Vista operating system. When used with Excel
> 2002 the entire set of example templates that I've tried work as expected.
> I installed the add-in files in C:\Program Files\SMF Add-In. I added it
> to the Active Application Add-ins section in the Office add-in manager,
> although it shows as a .xla file as opposed to other files that show up as
> .xlam files. It also shows up on the Add-ins checklist list from the
> Add-ins icon. The sample workbooks show an error message in the returned
> value cells of #NAME? in Excel 2007 on the Vista system.
>
> Any assistance in getting the Smf_addin working with Excel 2007 is greatly
> appreciated!
>
not your problem, just drop another message.
On Fri, Feb 21, 2014 at 10:04 AM, R Manning <marshall17043@
>
> Smf_addin, RCH_Stock_Market_
> me with Excel 2007 and Vista operating system. The add-in works fine with
> Excel 2002 on both an XP and Vista operating system. When used with Excel
> 2002 the entire set of example templates that I've tried work as expected.
> I installed the add-in files in C:\Program Files\SMF Add-In. I added it
> to the Active Application Add-ins section in the Office add-in manager,
> although it shows as a .xla file as opposed to other files that show up as
> .xlam files. It also shows up on the Add-ins checklist list from the
> Add-ins icon. The sample workbooks show an error message in the returned
> value cells of #NAME? in Excel 2007 on the Vista system.
>
> Any assistance in getting the Smf_addin working with Excel 2007 is greatly
> appreciated!
>
Fri Feb 21, 2014 3:34 pm (PST) . Posted by:
alliejuice87
The Interest LTM box does not have a value in it for HPQ. I looked at the information in the cell but, I'm not sure how to fix it. Any suggestions?
Fri Feb 21, 2014 3:35 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I have no idea what you are asking. Context, please? Are you looking at a
template? What formula is being used?
On Fri, Feb 21, 2014 at 3:02 PM, <alliejuice87@yahoo.com> wrote:
>
> The Interest LTM box does not have a value in it for HPQ. I looked at the
> information in the cell but, I'm not sure how to fix it. Any suggestions?
>
template? What formula is being used?
On Fri, Feb 21, 2014 at 3:02 PM, <alliejuice87@
>
> The Interest LTM box does not have a value in it for HPQ. I looked at the
> information in the cell but, I'm not sure how to fix it. Any suggestions?
>
Fri Feb 21, 2014 9:43 pm (PST) . Posted by:
"Alechia Rocheleau" alliejuice87
I'm working on a project for my finance class. I'm having an extremely hard time figuring this out.
"Identify
and compare pre-offering EPS and total equity $ to the most current values.
Compute the firm's current WACC assuming the total debt of the firm is in the
issue that you analyzed. This means that if the company has more than one debt
issue outstanding with a total face value of $X million and your chosen issue
involves $Y million, then assume that all $X million is in your issue.
This will simplify the calculations without diminishing learning value. Discuss
at least three overall conclusions about this offering as a result of your
research. "
I'm researching HPQ and the $4.6 billion in bonds they issued during September of 2011.
I'm using
The attached Excel worksheet is what I'm using to try to do this section of the report.
Is the interest LTM cell supposed to be --?
On Friday, February 21, 2014 6:36 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
I have no idea what you are asking. Context, please? Are you looking at a template? What formula is being used?
On Fri, Feb 21, 2014 at 3:02 PM, <alliejuice87@yahoo.com> wrote:
>The Interest LTM box does not have a value in it for HPQ. I looked at the information in the cell but, I'm not sure how to fix it. Any suggestions?
>
"Identify
and compare pre-offering EPS and total equity $ to the most current values.
Compute the firm's current WACC assuming the total debt of the firm is in the
issue that you analyzed. This means that if the company has more than one debt
issue outstanding with a total face value of $X million and your chosen issue
involves $Y million, then assume that all $X million is in your issue.
This will simplify the calculations without diminishing learning value. Discuss
at least three overall conclusions about this offering as a result of your
research. "
I'm researching HPQ and the $4.6 billion in bonds they issued during September of 2011.
I'm using
The attached Excel worksheet is what I'm using to try to do this section of the report.
Is the interest LTM cell supposed to be --?
On Friday, February 21, 2014 6:36 PM, Randy Harmelink <rharmelink@gmail.
I have no idea what you are asking. Context, please? Are you looking at a template? What formula is being used?
On Fri, Feb 21, 2014 at 3:02 PM, <alliejuice87@
>The Interest LTM box does not have a value in it for HPQ. I looked at the information in the cell but, I'm not sure how to fix it. Any suggestions?
>
Attachment(s) from Alechia Rocheleau
1 of 1 File(s)
Fri Feb 21, 2014 10:05 pm (PST) . Posted by:
mikemcq802
The Interest Expense for HPQ per Yahoo is zero for each of those periods.
Which leaves the question of why the spreadsheet shows "--" instead of zero.
It's because of the cell format. It is set for "Custom" with a value of:
$#,##0;-$#,##0;"--"
Which says to use "--" when the value is zero - voila - problem solved. Correct your Custom format to a more suitable format or just use the basic Number format.
My turn for a question for you. Is SMF being taught in your Finance Class?
Which leaves the question of why the spreadsheet shows "--" instead of zero.
It's because of the cell format. It is set for "Custom" with a value of:
$#,##0;-$#,#
Which says to use "--" when the value is zero - voila - problem solved. Correct your Custom format to a more suitable format or just use the basic Number format.
My turn for a question for you. Is SMF being taught in your Finance Class?
Fri Feb 21, 2014 10:18 pm (PST) . Posted by:
"Alechia Rocheleau" alliejuice87
I attached the Bond analysis I'm doing. The class is fixed income and securities analysis. The WACC is something we learned last week I just didn't have enough time to dedicate myself to doing the practice calculations. I've tried teaching it to myself but, I just don't understand. I do online classes so it's all pretty much teaching yourself. If you look through the report and see unfinished explanations it's because I looked at the rubric and realized I missed some things that should be included. I'm going through and fine tuning it now.
On Saturday, February 22, 2014 1:05 AM, "mikemcq802@yahoo.com" <mikemcq802@yahoo.com> wrote:
The Interest Expense for HPQ per Yahoo is zero for each of those periods.
Which leaves the question of why the spreadsheet shows "--" instead of zero.
It's because of the cell format. It is set for "Custom" with a value of:
$#,##0;-$#,##0;"--"
Which says to use "--" when the value is zero - voila - problem solved. Correct your Custom format to a more suitable format or just use the basic Number format.
My turn for a question for you. Is SMF being taught in your Finance Class?
On Saturday, February 22, 2014 1:05 AM, "mikemcq802@yahoo.
The Interest Expense for HPQ per Yahoo is zero for each of those periods.
Which leaves the question of why the spreadsheet shows "--" instead of zero.
It's because of the cell format. It is set for "Custom" with a value of:
$#,##0;-$#,#
Which says to use "--" when the value is zero - voila - problem solved. Correct your Custom format to a more suitable format or just use the basic Number format.
My turn for a question for you. Is SMF being taught in your Finance Class?
Attachment(s) from Alechia Rocheleau
1 of 1 File(s)
Fri Feb 21, 2014 10:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yes. It's grabbing the last 4 quarters of interest expense from the income
statement:
http://finance.yahoo.com/q/is?s=HPQ
...which are all zeroes. That's just how the workbook is set up to display
a zero amount.
However, your market risk (cell C16) is too low, since it is using ^GSPC
prices. Those exclude the payment of dividends. So your number should be an
additional 2% or so higher.
Why does it average beta? The number from the different services are
different because they are different time frames. You should decide on a
time frame that you want. Yahoo is a 3-year and I believe the other two are
both 1-year (which is why they are so close). I think IBD uses a 5-year
time period.
Also, your "implicit taxes" section is from the annual income statement,
but the "Interest Rate" and "Weighted Average" sections are MRQ, so they
will only align in one quarter out of the year.
On Fri, Feb 21, 2014 at 10:41 PM, Alechia Rocheleau
<alliejuice87@yahoo.com>wrote:
>
> I'm working on a project for my finance class. I'm having an extremely
> hard time figuring this out.
>
> The attached Excel worksheet is what I'm using to try to do this section
> of the report.
> Is the interest LTM cell supposed to be --?
>
>
statement:
http://finance.
...which are all zeroes. That's just how the workbook is set up to display
a zero amount.
However, your market risk (cell C16) is too low, since it is using ^GSPC
prices. Those exclude the payment of dividends. So your number should be an
additional 2% or so higher.
Why does it average beta? The number from the different services are
different because they are different time frames. You should decide on a
time frame that you want. Yahoo is a 3-year and I believe the other two are
both 1-year (which is why they are so close). I think IBD uses a 5-year
time period.
Also, your "implicit taxes" section is from the annual income statement,
but the "Interest Rate" and "Weighted Average" sections are MRQ, so they
will only align in one quarter out of the year.
On Fri, Feb 21, 2014 at 10:41 PM, Alechia Rocheleau
<alliejuice87@
>
> I'm working on a project for my finance class. I'm having an extremely
> hard time figuring this out.
>
> The attached Excel worksheet is what I'm using to try to do this section
> of the report.
> Is the interest LTM cell supposed to be --?
>
>
Fri Feb 21, 2014 10:38 pm (PST) . Posted by:
"Alechia Rocheleau" alliejuice87
I wish knowledge could be downloaded. I would have you upload yours.
On Saturday, February 22, 2014 1:25 AM, Randy Harmelink <rharmelink@gmail.com> wrote:
Yes. It's grabbing the last 4 quarters of interest expense from the income statement:
http://finance.yahoo.com/q/is?s=HPQ
...which are all zeroes. That's just how the workbook is set up to display a zero amount.
However, your market risk (cell C16) is too low, since it is using ^GSPC prices. Those exclude the payment of dividends. So your number should be an additional 2% or so higher.
Why does it average beta? The number from the different services are different because they are different time frames. You should decide on a time frame that you want. Yahoo is a 3-year and I believe the other two are both 1-year (which is why they are so close). I think IBD uses a 5-year time period.
Also, your "implicit taxes" section is from the annual income statement, but the "Interest Rate" and "Weighted Average" sections are MRQ, so they will only align in one quarter out of the year.
On Fri, Feb 21, 2014 at 10:41 PM, Alechia Rocheleau <alliejuice87@yahoo.com> wrote:
>
>I'm working on a project for my finance class. I'm having an extremely hard time figuring this out.
>
>The attached Excel worksheet is what I'm using to try to do this section of the report.
>Is the interest LTM cell supposed to be --?
>
>
On Saturday, February 22, 2014 1:25 AM, Randy Harmelink <rharmelink@gmail.
Yes. It's grabbing the last 4 quarters of interest expense from the income statement:
http://finance.
...which are all zeroes. That's just how the workbook is set up to display a zero amount.
However, your market risk (cell C16) is too low, since it is using ^GSPC prices. Those exclude the payment of dividends. So your number should be an additional 2% or so higher.
Why does it average beta? The number from the different services are different because they are different time frames. You should decide on a time frame that you want. Yahoo is a 3-year and I believe the other two are both 1-year (which is why they are so close). I think IBD uses a 5-year time period.
Also, your "implicit taxes" section is from the annual income statement, but the "Interest Rate" and "Weighted Average" sections are MRQ, so they will only align in one quarter out of the year.
On Fri, Feb 21, 2014 at 10:41 PM, Alechia Rocheleau <alliejuice87@
>
>I'm working on a project for my finance class. I'm having an extremely hard time figuring this out.
>
>The attached Excel worksheet is what I'm using to try to do this section of the report.
>Is the interest LTM cell supposed to be --?
>
>
Tidak ada komentar:
Posting Komentar