Rabu, 29 Februari 2012

[smf_addin] Digest Number 2132

Messages In This Digest (10 Messages)

1a.
10 Year Summary MSN - only a few elements work From: briansaxo@rocketmail.com
1b.
Re: 10 Year Summary MSN - only a few elements work From: Randy Harmelink
2a.
Help needed on Excel 2010 and Add ins From: James Shirley
2b.
Re: Help needed on Excel 2010 and Add ins From: Randy Harmelink
3a.
Retrieved Value Doesn't Match Webpage From: xavierviper
3b.
Re: Retrieved Value Doesn't Match Webpage From: Randy Harmelink
4a.
market open/ close From: jurgen.conrad
4b.
Re: market open/ close From: Randy Harmelink
5a.
Excel Not Responding From: jmkoeck
5b.
Re: Excel Not Responding From: Randy Harmelink

Messages

1a.

10 Year Summary MSN - only a few elements work

Posted by: "briansaxo@rocketmail.com" briansaxo@rocketmail.com   briansaxo@rocketmail.com

Tue Feb 28, 2012 6:31 am (PST)



Hi Randy,
First - thanks for the add-in, it makes life a whole lot easier.
I've been using the 10 year summary on MSN and get very few elements to
return data whether I use the function in my own sheet or the sample
"SMF-Template-MSN-10-Year-Summaries.xls". The elements that return data
are the ones in bold below and it doesn't seem to matter which ticker I
use. Any idea why this is the case?
Cheers
Brian
Price/Earnings = ErrorPrice/Sales = ErrorPrice/Book = ErrorBook
Value/Share% Net Profit Margin = #VALUE% Return on Equity% Return on
AssetsDebt/EquityInterest CoverageCurrent Assets = ErrorCurrent
Liabilities = ErrorLong Term Debt = ErrorShares Outstanding = ErrorSales
= ErrorEBIT = ErrorDepreciation = ErrorTotal Net Income = ErrorEarnings
Per Share = Error% Tax Rate = #VALUE

1b.

Re: 10 Year Summary MSN - only a few elements work

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

Tue Feb 28, 2012 7:13 am (PST)



I just download the template from the files area and tried ticker MMM.
Everything is working here. What version of the add-in are you using? You
may need the most current element definitions.

On Tue, Feb 28, 2012 at 6:36 AM, briansaxo@rocketmail.com <
briansaxo@rocketmail.com> wrote:

>
> I've been using the 10 year summary on MSN and get very few elements to
> return data whether I use the function in my own sheet or the sample
> "SMF-Template-MSN-10-Year-Summaries.xls". The elements that return data are
> the ones in bold below and it doesn't seem to matter which ticker I use.
> Any idea why this is the case?
>
> Price/Earnings = Error
> Price/Sales = Error
> Price/Book = Error
> *Book Value/Share*
> % Net Profit Margin = #VALUE
> *% Return on Equity*
> *% Return on Assets*
> *Debt/Equity*
> *Interest Coverage*
> Current Assets = Error
> Current Liabilities = Error
> Long Term Debt = Error
> Shares Outstanding = Error
> Sales = Error
> EBIT = Error
> Depreciation = Error
> Total Net Income = Error
> Earnings Per Share = Error
> % Tax Rate = #VALUE
>
2a.

Help needed on Excel 2010 and Add ins

Posted by: "James Shirley" jimbo91363@yahoo.com   jimbo91363

Tue Feb 28, 2012 11:28 am (PST)



Summary: Problem with getting (1) excel to delete permanently the old "Add in" directory; (2) excel not recognizing the functions once the "Add in" directory is correctly readded. I am having to redue this every time excel starts.

I originally set up the Directory in "SMF Add_ins" then realized it should have been SMF Add_in. Installed as instucted to the Add ins via a blank Excel workbook. Problem: Excel realizes that it the files can not be found because I (deleted, rename, moved). So I have since re-added the SMF Add_in to the Add ins list of which Excel asks me to delete the prior that it cannot find "SMF Add_ins". I do. So, now it finds the functions but they do not calulate. I get the NAME error. I see the functions are in the formulas list. I am using the =smfGetOptionsQuotes() function. In the cell I can remove the "s" off =smfGetOptionsQuotes() to get =smfGetOptionsQuote(), save to cell, recalculates gives VALUE error. I add the "s" back to the function =smfGetOptionsQuotes() it produces a value. This function performs as expected..

I feel like I should be able to delete forever in excel the old Add_in directory. Readd properly. Then when the spreadsheet come up it should calcuate based of the current data being read. Neither is happening. I need some guidance.

2b.

Re: Help needed on Excel 2010 and Add ins

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

Tue Feb 28, 2012 11:38 am (PST)



Take a look in the "Links" area of the group -- there is an item on
location errors and the #NAME? problem.

When you move the add-in to a new location, ALL workbooks that used the old
location are going to have to be *manually* fixed. Because of how EXCEL
handles add-ins, your formulas will NOT automatically change to the new
location you have the add-in in. As far as EXCEL is concerned, that is a
different add-in, because it's in a different location.

You can try running the smfFixLinks macro -- I use it to fix location
errors when I have them.

On Tue, Feb 28, 2012 at 9:40 AM, James Shirley <jimbo91363@yahoo.com> wrote:

> Summary: Problem with getting (1) excel to delete permanently the old
> "Add in" directory; (2) excel not recognizing the functions once the "Add
> in" directory is correctly readded. I am having to redue this every time
> excel starts.
>
> I originally set up the Directory in "SMF Add_ins" then realized it should
> have been SMF Add_in. Installed as instucted to the Add ins via a blank
> Excel workbook. Problem: Excel realizes that it the files can not be found
> because I (deleted, rename, moved). So I have since re-added the SMF
> Add_in to the Add ins list of which Excel asks me to delete the prior that
> it cannot find "SMF Add_ins". I do. So, now it finds the functions but
> they do not calulate. I get the NAME error. I see the functions are in the
> formulas list. I am using the =smfGetOptionsQuotes() function. In the
> cell I can remove the "s" off =smfGetOptionsQuotes() to get
> =smfGetOptionsQuote(), save to cell, recalculates gives VALUE error. I add
> the "s" back to the function =smfGetOptionsQuotes() it produces a value.
> This function performs as expected..
>
> I feel like I should be able to delete forever in excel the old Add_in
> directory. Readd properly. Then when the spreadsheet come up it should
> calcuate based of the current data being read. Neither is happening. I
> need some guidance.
>
3a.

Retrieved Value Doesn't Match Webpage

Posted by: "xavierviper" allen.brian@xiostech.com   xavierviper

Tue Feb 28, 2012 2:14 pm (PST)



Example:

=RCHGetYahooQuotes("IBM","r") ---> 15.12

Web page http://finance.yahoo.com/q?s=ibm&ql=1 shows ---> 15.16

And it's not just IBM, as I tried a few other tickers as well.

Thx,
Xavier

3b.

Re: Retrieved Value Doesn't Match Webpage

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

Tue Feb 28, 2012 2:20 pm (PST)



I see 15.12 on the CSV file that Yahoo generates, which is where that
function gets the data:

http://download.finance.yahoo.com/d/quotes.csv?s=IBM&f=sr&e=.csv

You can ask Yahoo why the values are different. I suspect it just has to do
with when it's calculated, since the price can change during the day.

The ratio of 15.16 to 15.12 is about the same as the ratio of the closing
price today to the closing price yesterday. So, possibly the CSV file they
create contains the ratio calculated as of the end of the previous day.

On Tue, Feb 28, 2012 at 2:53 PM, xavierviper <allen.brian@xiostech.com>wrote:

> Example:
>
> =RCHGetYahooQuotes("IBM","r") ---> 15.12
>
> Web page http://finance.yahoo.com/q?s=ibm&ql=1 shows ---> 15.16
>
> And it's not just IBM, as I tried a few other tickers as well.
>
4a.

market open/ close

Posted by: "jurgen.conrad" jurgen.conrad@gmail.com   jurgen.conrad

Tue Feb 28, 2012 2:40 pm (PST)



hi all - is the market open/ close information obtainable???

i.e. it would be great to know if the AU market (or other markets) is currently open or closed.

i can do it by other means, however it would be more ease (i believe).

thanks in advance for your help & time - regards...

...jurgen

4b.

Re: market open/ close

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

Tue Feb 28, 2012 3:04 pm (PST)



You can try:

=smfGetTagContent("http://au.finance.yahoo.com/q?s=AAC.AX
","span",-1,"yfs_market_time")

I'm not sure what it will look like after the market is closed, but here's
what I got just prior to the market open, and after the market opened:

Wed 29 Feb 2012 09:50 - Australia Markets open in 10 mins.
Wed 29 Feb 2012 10:00 - Australia Markets close in 6 hrs.

If they follow the same structure as the U.S. web pages, it should say
"Australia Markets closed" when the market closes for the day.

On Tue, Feb 28, 2012 at 3:38 PM, jurgen.conrad <jurgen.conrad@gmail.com>wrote:

> hi all - is the market open/ close information obtainable???
>
> i.e. it would be great to know if the AU market (or other markets) is
> currently open or closed.
>
> i can do it by other means, however it would be more ease (i believe).
>
> thanks in advance for your help & time - regards...
>
5a.

Excel Not Responding

Posted by: "jmkoeck" jmkoeck@hotmail.com   jmkoeck

Tue Feb 28, 2012 3:20 pm (PST)



Has anyone encountered this issue? I've been using the add-in for months now and all of a sudden a workbook with the add-in enabled will not respond when I attempt to open it. I have not downloaded any new programs or have written any new macros.

Any thoughts?

Thanks.

5b.

Re: Excel Not Responding

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

Tue Feb 28, 2012 3:24 pm (PST)



I've had that a few times in the past. In those cases, it was because one
of the websites I was getting data from was down. That means that each
formula that gets data from a new web page on that website has to "time
out" before it can go on to the next formula...

On Tue, Feb 28, 2012 at 4:13 PM, jmkoeck <jmkoeck@hotmail.com> wrote:

> Has anyone encountered this issue? I've been using the add-in for months
> now and all of a sudden a workbook with the add-in enabled will not respond
> when I attempt to open it. I have not downloaded any new programs or have
> written any new macros.
>
> Any thoughts?
>
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need traffic?

Drive customers

With search ads

on Yahoo!

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

Tidak ada komentar:

Posting Komentar