Minggu, 22 Januari 2012

[smf_addin] Digest Number 2085

Messages In This Digest (14 Messages)

Messages

1a.

Can't get the Add-in to install or work

Posted by: "srthwaytes" spencer.thwaytes@gmail.com   srthwaytes

Sat Jan 21, 2012 7:13 am (PST)



Hi guys. I am trying to get the Add-in to work on my computer in Excel...but I am having trouble getting it to start in Excel. I know I must be doing something wrong. I've downloaded the files into a folder on my hard-drive. I can bring up the Definitions document...but that's it. Can someone send me directions on how to install/initiate the program in Excel? Thanks!

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

Re: Can't get the Add-in to install or work

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

Sat Jan 21, 2012 7:14 am (PST)



Check the "Documentation" folder in the files area, or the "Links" area of
the group.

On Sat, Jan 21, 2012 at 7:23 AM, srthwaytes <spencer.thwaytes@gmail.com>wrote:

> Hi guys. I am trying to get the Add-in to work on my computer in
> Excel...but I am having trouble getting it to start in Excel. I know I must
> be doing something wrong. I've downloaded the files into a folder on my
> hard-drive. I can bring up the Definitions document...but that's it. Can
> someone send me directions on how to install/initiate the program in Excel?
> Thanks!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
1c.

Re: Can't get the Add-in to install or work

Posted by: "srthwaytes" spencer.thwaytes@gmail.com   srthwaytes

Sat Jan 21, 2012 9:08 am (PST)



Thanks...that worked. I've extracted files to the folder correctly and managed the Add-In options in Excel to include Stock Market Functions Add-In. All good here.

But now I'm testing the via the instructions with the following formula... =RCHGetYahooHistory(“MSFT”) ...not by pressing enter but by pressing CTRL-SHFT-ENT. Unfortunately, I only get #VALUE! as a result.

Any idea what I'm doing incorrectly? I didn't see a tutorial about this issue under Links...

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Check the "Documentation" folder in the files area, or the "Links" area of
> the group.
>
> On Sat, Jan 21, 2012 at 7:23 AM, srthwaytes <spencer.thwaytes@...>wrote:
>
> > Hi guys. I am trying to get the Add-in to work on my computer in
> > Excel...but I am having trouble getting it to start in Excel. I know I must
> > be doing something wrong. I've downloaded the files into a folder on my
> > hard-drive. I can bring up the Definitions document...but that's it. Can
> > someone send me directions on how to install/initiate the program in Excel?
> > Thanks!
> >
>

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

Re: Can't get the Add-in to install or work

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

Sat Jan 21, 2012 12:24 pm (PST)



Based on the garbage characters I'm seeing around MSFT, I would suspect
you're not using proper double-quotes symbols to indicate it is a string
literal. Since the function expects a string, that would cause a #VALUE!
error.

On Sat, Jan 21, 2012 at 10:08 AM, srthwaytes <spencer.thwaytes@gmail.com>wrote:

> Thanks...that worked. I've extracted files to the folder correctly and
> managed the Add-In options in Excel to include Stock Market Functions
> Add-In. All good here.
>
> But now I'm testing the via the instructions with the following formula...
> =RCHGetYahooHistory(â€Å"MSFT†) ...not by pressing enter but by pressing
> CTRL-SHFT-ENT. Unfortunately, I only get #VALUE! as a result.
>
> Any idea what I'm doing incorrectly? I didn't see a tutorial about this
> issue under Links...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2a.

Re: SMF-Template-MSN-10-Year-Summaries.xls errors

Posted by: "Paulo" palminha@yahoo.com   palminha

Sat Jan 21, 2012 7:17 am (PST)



Ok Randy, thank you for solving the problem so soon, and sorry to send the @mail directly!

But now I have a problem with new way figures are presented :-((
My excel sheet was working only with figures, and now I have the following:
Current Assets 87.10 Bil
Current Liabilities 39.87 Bil
Long Term Debt 16.23 Bil
Shares Outstanding 5.44 Bil
Sales 43.22 Bil
EBIT 7.83 Bil
Depreciation 2.49 Bil
Total Net Income 6.49 Bil

Any sugestions to remove or ignor " Bil" from my formulas?

Best Regards
Paulo Palminha

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> MSN has changed the web page addresses and content on the 10-year
> summaries for Income Statement and Balance sheet. I just updated the
> element definition file, smf-elements-1.txt, and uploaded it to the
> "Works in Progress" folder of the files area.
>
> You'll need to replace your version of that file in the SMF folder to
> pick up those new definitions. Best practice is to exit EXCEL before
> updating that file.
>
> PS: In the future, please direct such issues directly to the Yahoo group
> and not to my email address. They too easily end up in my SPAM bucket if
> sent to me directly. Thanks.
>
> On Fri, Jan 20, 2012 at 4:59 PM, P Palminha <palminha@> wrote:
> In this template now I have some error as follows: 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! So, are there any changes in progress for this template? Thank
> you in advanced Best RegardsPaulo Palminha
>

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

Re: SMF-Template-MSN-10-Year-Summaries.xls errors

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

Sat Jan 21, 2012 7:30 am (PST)



Easiest thing to do is install version 2.1.2012.01.21 of the add-in from
the "Works in Progress" folder. I just uploaded it. I did have a routine
that converted amounts to billions if they ended in " Bil". However, MSN
added a bunch of trailing blanks. I just added a trim function so that the
current " Bil" processing will work.

Otherwise, you could use the SUBSTITUTE() or IF() functions to manually
remove them. But you'll probably also have to account for " Mil".

On Sat, Jan 21, 2012 at 8:17 AM, Paulo <palminha@yahoo.com> wrote:

> Ok Randy, thank you for solving the problem so soon, and sorry to send the
> @mail directly!
>
> But now I have a problem with new way figures are presented :-((
> My excel sheet was working only with figures, and now I have the following:
> Current Assets 87.10 Bil
> Current Liabilities 39.87 Bil
> Long Term Debt 16.23 Bil
> Shares Outstanding 5.44 Bil
> Sales 43.22 Bil
> EBIT 7.83 Bil
> Depreciation 2.49 Bil
> Total Net Income 6.49 Bil
>
> Any sugestions to remove or ignor " Bil" from my formulas?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3a.

Just getting started and need some help

Posted by: "Mike" fs26mdm@yahoo.com   fs26mdm

Sat Jan 21, 2012 7:26 am (PST)



I just downloaded the rch add in. Is that what I need or should i get the smf add in? Also are there any tutorials on these add ins?

Anything else i should know just getting started with these add ins?

Thanks.

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

Re: Just getting started and need some help

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

Sat Jan 21, 2012 7:32 am (PST)



As noted on the home page of the group, and in the email welcoming you to
the group -- documentation is in the "Files" area of the group, and some
tips and FAQs are in the "Links" area of the group.

On Sat, Jan 21, 2012 at 8:25 AM, Mike <fs26mdm@yahoo.com> wrote:

> I just downloaded the rch add in. Is that what I need or should i get the
> smf add in? Also are there any tutorials on these add ins?
>
> Anything else i should know just getting started with these add ins?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

MSN-10-Year-Summaries Google Visualization API

Posted by: "ronmac17" ronmac17@yahoo.com   ronmac17

Sat Jan 21, 2012 9:34 am (PST)



Here is an example of using the Google Visualization API to plot data from the MSN-10-Year-Summaries workbook. Adjust the variables as desired. https://dl.dropbox.com/u/5568647/msnfinan_ge.html

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

Re: MSN-10-Year-Summaries Google Visualization API

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

Sat Jan 21, 2012 12:25 pm (PST)



Very nice. Thanks for sharing.

On Sat, Jan 21, 2012 at 10:34 AM, ronmac17 <ronmac17@yahoo.com> wrote:

> Here is an example of using the Google Visualization API to plot data from
> the MSN-10-Year-Summaries workbook. Adjust the variables as desired.
> https://dl.dropbox.com/u/5568647/msnfinan_ge.html
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
5a.

Grab info from Boursorama.com

Posted by: "nicodemus_65" nicodemus_65@yahoo.fr   nicodemus_65

Sat Jan 21, 2012 11:07 am (PST)



Hello,

I'm using with success
=RCHGetTableCell("http://www.boursorama.com/cours.phtml?symbole=FF11-EVS\
";2;">Cotations";;;;1)
to retrieve, among other info, the last price of the the stock EVS.
Further to these info, I'd like now to grab its name (EVS
BROADC.EQUIPM), its symbol (EVS) and its isin code (BE0003820371) but
can't manage to find the correct syntax.
I've tried
=RCHGetWebData("http://www.boursorama.com/cours.phtml?symbole=FF11-EVS")
to get the whole html code to help me manipulate RCHGetTableCell(), but
it didn't helped me.

Could someone give some hints ?
thx in advance
Nico

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

Re: Grab info from Boursorama.com

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

Sat Jan 21, 2012 12:33 pm (PST)



Try:

=TRIM(smfStrExtr("|"&smfGetTagContent($C$3,"title",1),"|","|"))
=TRIM(smfStrExtr(smfGetTagContent($C$3,"title",1)&"|","|","|"))
=smfGetTagContent($C$3,"span",-1,"fv-isin")

None of them were in tables, so the next choice is usually the
smfGetTagContent() function.

On Sat, Jan 21, 2012 at 9:32 AM, nicodemus_65 <nicodemus_65@yahoo.fr> wrote:

>
> I'm using with success
> =RCHGetTableCell("http://www.boursorama.com/cours.phtml?symbole=FF11-EVS
> ";2;">Cotations";;;;1)
> to retrieve, among other info, the last price of the the stock EVS.
> Further to these info, I'd like now to grab its name (EVS BROADC.EQUIPM),
> its symbol (EVS) and its isin code (BE0003820371) but can't manage to find
> the correct syntax.
> I've tried =RCHGetWebData("http://www.boursorama.com/cours.phtml?symbole=
> FF11-EVS") to get the whole html code to help me manipulate RCHGetTableCell(),
> but it didn't helped me.
>
> Could someone give some hints ?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

YAHOO Latest Price access

Posted by: "PLA" optionzz@gmail.com   option2z

Sat Jan 21, 2012 11:54 pm (PST)



We've discussed the change Yahoo made to the summary page where they changed
"Latest Price." But I can't find a good solution looking back.

Here's a fragment of the new page's html:
<span class="time_rtq_ticker"><span id="yfs_l84_ibm">188.52</span>

And a picture of the page from whence it came:

Used to use: RCHGetTableCell("http://finance.yahoo.com/q?s="&B5,1,">Last
Trade:") embedded with some other formulas so was very convenient.

Some formulas, including the one you suggested for the two day RSI need this
data. I can't figure out how to get the number 188.52. The tag before it
changes with the _TICKER (_ibm"> in this case. Can you help?

Thanks!
Pete A

Amateurs practice until they get it right, experts practice until they can't
get it wrong
(Faith Duck)

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

Re: YAHOO Latest Price access

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

Sun Jan 22, 2012 12:01 am (PST)



See: http://finance.groups.yahoo.com/group/smf_addin/message/17013

Although I don't understand why RCHGetYahooQuotes() isn't just used...

On Sun, Jan 22, 2012 at 12:54 AM, PLA <optionzz@gmail.com> wrote:
We've discussed the change Yahoo made to the summary page where they
changed "Latest Price." But I can't find a good solution
looking back.
Here's a fragment of the new page's html:

<span class="time_rtq_ticker"><span id="yfs_l84_ibm">188.52</span>

And a picture of the page from whence it came:

Used to use: RCHGetTableCell("http://finance.yahoo.com/q?s=
<http://finance.yahoo.com/q?s=> "&B5,1,">Last Trade:") embedded with
some other formulas so was very convenient.

Some formulas, including the one you suggested for the two day RSI need
this data. I can't figure out how to get the number 188.52. The
tag before it changes with the _TICKER (_ibm"> in this case. Can
you help?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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)