Sabtu, 16 Juli 2011

[smf_addin] Digest Number 1888

Messages In This Digest (6 Messages)

Messages

1a.

I want to know the element numbers for Industry items

Posted by: "Amir" amir.rehman@yahoo.com   amir.rehman

Fri Jul 15, 2011 5:51 am (PDT)



Hello,

I was trying find industry values for these items;

Revenue
Earning / Share
Book Value / Share
Free Cash Flows
Average ROIC
Average ROE
Average ROA
Average Net Margin

I am trying to use RCHGetElementNumber function to get these values. Please help!

Thanks,
-Amir


Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.

Re: I want to know the element numbers for Industry items

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

Fri Jul 15, 2011 11:18 am (PDT)



Just use the filter function on the
RCHGetElementNumber-Element-Definitions.xls file distributed with the add-in
and you should find all of the "Industry" data elements.

On Fri, Jul 15, 2011 at 5:51 AM, Amir <amir.rehman@yahoo.com> wrote:

>
> I was trying find industry values for these items;
>
> Revenue
> Earning / Share
> Book Value / Share
> Free Cash Flows
> Average ROIC
> Average ROE
> Average ROA
> Average Net Margin
>
> I am trying to use RCHGetElementNumber function to get these values. Please
> help!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

Re: Need to pull the total return from a specified date range to ano

Posted by: "Bernie" bernie.sandford@gmail.com   diamondtrap

Fri Jul 15, 2011 8:09 am (PDT)



Now when I am trying to open the File smfPricesByDates file I get a message "This workbook contains one or more links that cannot be update." What do I do? Thank you.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Where are you running into problems with the documentation of the function?
>
> On Thu, Jul 14, 2011 at 1:14 PM, Bernie <bernie.sandford@...> wrote:
>
> > Hi Randy-Thanks for the prompt response. Can you break it down a little
> > more basic for me as to how to use the smfPricesByDates() function?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
2b.

Re: Need to pull the total return from a specified date range to ano

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

Fri Jul 15, 2011 8:24 am (PDT)



See item 0.2 in the "Links" area of the group...

On Fri, Jul 15, 2011 at 8:09 AM, Bernie <bernie.sandford@gmail.com> wrote:

> Now when I am trying to open the File smfPricesByDates file I get a message
> "This workbook contains one or more links that cannot be update." What do I
> do? Thank you.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
2c.

Re: Need to pull the total return from a specified date range to ano

Posted by: "paul messerschmidt" financepaul@gmail.com   fuelspotpaul

Fri Jul 15, 2011 9:54 am (PDT)



here is my earlier comment regarding 'total return' posted somewhere else,
but worth considering here

=============================================

be careful about just plugging data for a total return calculation.

there are several assumptions and calculations that may not be
representative of real-world events.

> the day a stock goes ex-div, may not be the day the dividend gets paid.
(e.g., SPY) the delay can be upwards of 30-days -- or more.

http://www.dividendinvestor.com/?chk=ecc2b1309874364&symbol=spy&submit=GO

<http://www.dividendinvestor.com/?chk=ecc2b1309874364&symbol=spy&submit=GO>SPY
ex-div = 17june; div payment = 29july

how do you treat this six week spread of price appreciation without the
dividend or dividend payment?

> when the dividend does get paid, what assumptions are made regarding the
dividend reinvestment price (open, mid, close, vwap)?

> do you include commissions on the reinvestment?

> how do you handle fractional shares? (e.g., hold in cash at 0% interest
until you can purchase and integral number of shares -- in an odd-lot)
=================================================

i'd like to see how others treat these...

cheers
'
On Thu, Jul 14, 2011 at 1:55 PM, Bernie <bernie.sandford@gmail.com> wrote:

> **
>
>
> Have been using RCHGetYahooQuotes Template which is great but need to add
> new column for "Total Return 10/12/07 to 3/6/09.
>
> Need to list historical quotes for 37 stocks, calculate the total return on
> those stocks for 10/12/07 thru 3/6/09, and pull that return # into the other
> sheet.
>
> Also, how do I add "Beta" to the drop down menu?
>
> Can anyone help with this please?
>
> Thank you.
>
> B
>
>
>

--
-----------------------------------------
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
3.

bloomberg businessweek data

Posted by: "alexander" life2539@yahoo.com   life2539

Fri Jul 15, 2011 9:20 pm (PDT)



Is it possible or has anybody tried to use the SMF addin to get data from bloomberg businessweek website. here is a link of one company's financials.

http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=PAEKY:US

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! News

Odd News

You won't believe

it, but it's true

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
Diposting oleh EXCEL FEED LEARNING di 03.22

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)