Jumat, 13 Juli 2012

[smf_addin] Digest Number 2276

15 New Messages

Digest #2276
1a
Re: Is there an update for smf-elements-3 by "Randy Harmelink" rharmelink
1b
Re: Is there an update for smf-elements-3 by "christianilson79" christianilson79
1c
Re: Is there an update for smf-elements-3 by "Randy Harmelink" rharmelink
2a
Re: Getting currency from Google and MSN by "Randy Harmelink" rharmelink
4
Just a Thank You! by "tldavidson1" tldavidson1
5a
Only Getting Partial Data by "khajado" khajado
5b
Re: Only Getting Partial Data by "Randy Harmelink" rharmelink

Messages

Fri Jul 13, 2012 6:26 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You do have the current definition of the element.

However, if the "request could not be processed" for the web page, I think
you have your answer right there. If your browser can't access the web
page, the add-in is probably running into the same problem.

Firewall of some kind, maybe? Can you use Google Finance at all? What
happens if you try to look at the company financials for NVS on Google
Finance? What web page do you end up on?

On Fri, Jul 13, 2012 at 2:19 AM, christianilson79 <
christian.weitert@googlemail.com> wrote:

> I get the google finance page with: your request could not be processed.
>
> =smfGetAParms(3380) now gives me:
>
> Google;Annual Income Statement -- Operating Income -- FY1;
> http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCANNUALDIV;OperatingIncome; ; ;0;</TABLE;0;0
>

Fri Jul 13, 2012 6:51 am (PDT) . Posted by:

"christianilson79" christianilson79

When I lookup NVS it refers me to:
http://www.google.com/finance?q=NYSE:NVS&fstype=ii

Dont think its a firewall issue, since it works for other symbols...;)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You do have the current definition of the element.
>
> However, if the "request could not be processed" for the web page, I think
> you have your answer right there. If your browser can't access the web
> page, the add-in is probably running into the same problem.
>
> Firewall of some kind, maybe? Can you use Google Finance at all? What
> happens if you try to look at the company financials for NVS on Google
> Finance? What web page do you end up on?
>
> On Fri, Jul 13, 2012 at 2:19 AM, christianilson79 <
> christian.weitert@...> wrote:
>
> > I get the google finance page with: your request could not be processed.
> >
> > =smfGetAParms(3380) now gives me:
> >
> > Google;Annual Income Statement -- Operating Income -- FY1;
> > http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCANNUALDIV;OperatingIncome; ; ;0;</TABLE;0;0
> >
>

Fri Jul 13, 2012 7:42 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Do you need the "NYSE:" prefix because of your location?

On Fri, Jul 13, 2012 at 6:51 AM, christianilson79 <
christian.weitert@googlemail.com> wrote:

> When I lookup NVS it refers me to:
> http://www.google.com/finance?q=NYSE:NVS&fstype=ii
>
> Dont think its a firewall issue, since it works for other symbols...;)
>

Fri Jul 13, 2012 6:32 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Actually, I just updated the add-in to make that easier. With version
2.1.2012.7.19, you can now do:

=smfStrExtr(smfGetTagContent("http://www.google.com/finance?q="&"KO","div",-1,"Currency
in"),"in ","~")

...because the "~" value as the ending character says to go to the end of
the input string for the extraction. I did that because I ran into a number
of situations where I had to create a "dummy" character to start or end the
input string so I could extract from the start or to the end. For example,
with prior versions of the add-in, I would have needed to do this:

=smfStrExtr(smfGetTagContent("http://www.google.com/finance?q="&"KO","div",-1,"Currency
in")&"|","in ","|")

Note that I concatenated the "|" character so I could use it as my ending
extraction character.

Another way to skin the cat:

=SUBSTITUTE(smfGetTagContent("http://www.google.com/finance?q="&"KO","div",-1,"Currency
in"),"Currency in ","")

On Fri, Jul 13, 2012 at 3:52 AM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

> Randy need your help again.
>
> for currency from google i use another line now.
> like this:
> =smfStrExtr(smfGetTagContent("http://www.google.com/finance?q="&"KO";"div";-1;"Currency
> in");"in ";"D")
>
> But you see i get now "US" insteed of "USD" i know because i give for end
> parameter "D" but i don't know how i could name the end for this source
> code:
>
> <div>Currency in USD</div>
>

Fri Jul 13, 2012 7:40 am (PDT) . Posted by:

"antonvanas1989" antonvanas1989

Randy i still have the same problems with the lines of msn..

Stock Market Functions add-in, Version 2.1.2012.02.02
Updates hole addin with this version.

Most lines i changed to Yahoo already but some line i use but never retreive data for are:
#1
#7-11
#442
#447
#452

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Are you using an older version of the add-in? That element definition
> requires the 2.1.2012.02.02 version or later.
>
> On Wed, Jul 11, 2012 at 11:06 AM, ts63033 <mdlarson5@...> wrote:
>
> >
> > I saw a prior post about how to correct an MSN data retrieval problem by
> > using the updated elements definitions files. I replaced all of the old
> > files with the new files but still am not able to retrieve the MSN Company
> > Name using =RCHGetElementNumber(Ticker,13862). Any idea why this is not
> > working?
> >
>

Fri Jul 13, 2012 7:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Except that 2.1.2012.02.02 has the old version of the MSN element
definitions.

What do you get for:

=RCHGetElementNumber("MMM",1)
=smfGetAParms(1)

On Fri, Jul 13, 2012 at 7:40 AM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

> Randy i still have the same problems with the lines of msn..
>
> Stock Market Functions add-in, Version 2.1.2012.02.02
> Updates hole addin with this version.
>
> Most lines i changed to Yahoo already but some line i use but never
> retreive data for are:
> #1
> #7-11
> #442
> #447
> #452
>

Fri Jul 13, 2012 9:41 am (PDT) . Posted by:

"antonvanas1989" antonvanas1989

Copyright © 2012 Microsoft. All rights reserved.

MSN;Company
Description;http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;?;;;;;;;;0

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Except that 2.1.2012.02.02 has the old version of the MSN element
> definitions.
>
> What do you get for:
>
> =RCHGetElementNumber("MMM",1)
> =smfGetAParms(1)
>
> On Fri, Jul 13, 2012 at 7:40 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > Randy i still have the same problems with the lines of msn..
> >
> > Stock Market Functions add-in, Version 2.1.2012.02.02
> > Updates hole addin with this version.
> >
> > Most lines i changed to Yahoo already but some line i use but never
> > retreive data for are:
> > #1
> > #7-11
> > #442
> > #447
> > #452
> >
>

Fri Jul 13, 2012 9:46 am (PDT) . Posted by:

"antonvanas1989" antonvanas1989

I see. i install the newer one and its working.

But why don't you put the new text file 1 in the 2012 version??

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You have the old definition of the element...
>
> On Fri, Jul 13, 2012 at 9:41 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> >
> > MSN;Company
> > Description;
> > http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;?;;;;;;;;0
> >
>

Fri Jul 13, 2012 9:50 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It is in the 2.1.2012.07.19 version.

The whole point of moving the element definitions to external files is so
their updates wouldn't need to force an update of the entire add-in module.
That they could be updated individually, as needed.

On Fri, Jul 13, 2012 at 9:46 AM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

> I see. i install the newer one and its working.
>
> But why don't you put the new text file 1 in the 2012 version??
>

Fri Jul 13, 2012 10:10 am (PDT) . Posted by:

"antonvanas1989" antonvanas1989

alright. I installed not the latest version but the stable verion the problem was i forget the txt file was not the newest one.

But it's a good way to update the text files so you don't need to install the whole add-in.

After installing the new text file (close excel and smfforce) i see the #442 #447 #388/#389 gives undefined..
But the
#1, #7-#10 are working now.. Any idea how this comes?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It is in the 2.1.2012.07.19 version.
>
> The whole point of moving the element definitions to external files is so
> their updates wouldn't need to force an update of the entire add-in module.
> That they could be updated individually, as needed.
>
> On Fri, Jul 13, 2012 at 9:46 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > I see. i install the newer one and its working.
> >
> > But why don't you put the new text file 1 in the 2012 version??
> >
>

Fri Jul 13, 2012 10:15 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

They shouldn't be undefined. They are on that file. They're all working
fine here.

Undefined should mean that no element definition was loaded from the
external files for that element number.

On Fri, Jul 13, 2012 at 10:10 AM, antonvanas1989
<antonvanas1989@yahoo.com>wrote:

> alright. I installed not the latest version but the stable verion the
> problem was i forget the txt file was not the newest one.
>
> But it's a good way to update the text files so you don't need to install
> the whole add-in.
>
> After installing the new text file (close excel and smfforce) i see the
> #442 #447 #388/#389 gives undefined..
> But the
> #1, #7-#10 are working now.. Any idea how this comes?
>

Fri Jul 13, 2012 7:41 am (PDT) . Posted by:

"tldavidson1" tldavidson1

I am new to the group and still getting up to speed, but I want to that you for the hard work you are doing both making and maintaining this add-in. I will be developing some smart spreadsheets and this tool is greatly appreciated!

Fri Jul 13, 2012 10:16 am (PDT) . Posted by:

"khajado" khajado

Hello,

I have created my own template to pull data from Yahoo (using the latest 2012 files) but I am only getting some of the data for certain tickers, others are showing up as "Error" though I know the data exists from looking at the Yahoo pages. I can send you the template to look at if need be.

Thanks.

John

Fri Jul 13, 2012 10:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'd be more interested in the exact formulas -- including parameters and
ticker symbols -- that are returning "Error". You didn't even indicate what
functions you are using.

On Fri, Jul 13, 2012 at 10:12 AM, khajado <khajado@yahoo.com> wrote:

>
> I have created my own template to pull data from Yahoo (using the latest
> 2012 files) but I am only getting some of the data for certain tickers,
> others are showing up as "Error" though I know the data exists from looking
> at the Yahoo pages. I can send you the template to look at if need be.
>
Diposting oleh EXCEL FEED LEARNING di 10.18

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)