Rabu, 07 Maret 2012

[smf_addin] Digest Number 2139

Messages In This Digest (25 Messages)

Messages

1a.

Re: Trend Values for http://www.masterdata.com/

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

Tue Mar 6, 2012 2:37 am (PST)



Hmmm. " " (with the semi-colon) is an HTML code for a non-breaking
space, but the add-in changes it to a regular space before extracting data,
but it looks like they are coding it incorrectly when putting in the "new
position" image by coding it without the semi-colon.

You could always use the SUBSTITUTE() function and replace it with a null
string.

On Tue, Mar 6, 2012 at 3:07 AM, smithjhhic <smithjhhic@yahoo.com> wrote:

>
> Thank you very much for your help. I notice for some symbols (ie. EWZ)
> data returned is "Down&nbsp" vs. "Down". Is that something I'm doing wrong
> part of the web data? Is there a way to remove the &nbsp?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1b.

Re: Trend Values for http://www.masterdata.com/

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

Tue Mar 6, 2012 3:34 pm (PST)



Randy,
Thank you for your help. I'm an Excel novice. How do I add the substitute function into the two formulas below?

=RCHGetTableCell("http://www.masterdata.com/ComponentFrames/"&LEFT(B8,1)&"/"&B8&".htm",2,">Current Trend")

=RCHGetElementNumber($C2,702)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. "&nbsp;" (with the semi-colon) is an HTML code for a non-breaking
> space, but the add-in changes it to a regular space before extracting data,
> but it looks like they are coding it incorrectly when putting in the "new
> position" image by coding it without the semi-colon.
>
> You could always use the SUBSTITUTE() function and replace it with a null
> string.
>
> On Tue, Mar 6, 2012 at 3:07 AM, smithjhhic <smithjhhic@...> wrote:
>
> >
> > Thank you very much for your help. I notice for some symbols (ie. EWZ)
> > data returned is "Down&nbsp" vs. "Down". Is that something I'm doing wrong
> > part of the web data? Is there a way to remove the &nbsp?
> >
>

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

Re: Trend Values for http://www.masterdata.com/

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

Tue Mar 6, 2012 3:38 pm (PST)



Just do:

=SUBSTITUTE(...formula...,"&nbsp","")

On Tue, Mar 6, 2012 at 4:34 PM, smithjhhic <smithjhhic@yahoo.com> wrote:

>
> Thank you for your help. I'm an Excel novice. How do I add the
> substitute function into the two formulas below?
>
> =RCHGetTableCell("http://www.masterdata.com/ComponentFrames/"&LEFT(B8,1)&"/"&B8&".htm",2,">Current
> Trend")
>
> =RCHGetElementNumber($C2,702)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

smfGetCSVFile()

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

Tue Mar 6, 2012 7:32 am (PST)



Randy -

I am trying to get the CSV file associated with the link with the Excel Icon and marked Download on this page:

http://www.invescopowershares.com/products/holdings.aspx?ticker=PID

All I get is #VALUE.

Equations tried

=smfGetCSVFile("http://www.invescopowershares.com/PIDHoldings.csv")

=smfGetCSVFile("http://www.invescopowershares.com/products/holdings.aspx?ticker=PID/PIDHoldings.csv")

I know from the documentation that I need a PDelimiter, PDim1, and PDim2. I also know that this file uses Java script to load the file.

Can you help?

Ron Spruell

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

Re: smfGetCSVFile()

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

Tue Mar 6, 2012 12:52 pm (PST)



I don't see any way to come up with the CSV name -- how did you decide to
create yours?

On Tue, Mar 6, 2012 at 8:32 AM, hashky <hashky@yahoo.com> wrote:

>
> I am trying to get the CSV file associated with the link with the Excel
> Icon and marked Download on this page:
>
> http://www.invescopowershares.com/products/holdings.aspx?ticker=PID
>
> All I get is #VALUE.
>
> Equations tried
>
> =smfGetCSVFile("http://www.invescopowershares.com/PIDHoldings.csv")
>
> =smfGetCSVFile("
> http://www.invescopowershares.com/products/holdings.aspx?ticker=PID/PIDHoldings.csv
> ")
>
> I know from the documentation that I need a PDelimiter, PDim1, and PDim2.
> I also know that this file uses Java script to load the file.
>
> Can you help?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2c.

Re: smfGetCSVFile()

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Tue Mar 6, 2012 1:41 pm (PST)



When I clicked on Download the dialog box came up"You have chosen to open PIDHoldings.csv ... from http://www.invescopowershares.com."

So, I assumed that was the link, but obviously it was not.

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, March 6, 2012 2:52 PM
>Subject: Re: [smf_addin] smfGetCSVFile()
>
>
> 
>I don't see any way to come up with the CSV name -- how did you decide to create yours?
>
>
>On Tue, Mar 6, 2012 at 8:32 AM, hashky <hashky@yahoo.com> wrote:
>
>
>>I am trying to get the CSV file associated with the link with the Excel Icon and marked Download on this page:
>>
>>http://www.invescopowershares.com/products/holdings.aspx?ticker=PID
>>
>>All I get is #VALUE.
>>
>>Equations tried
>>
>>=smfGetCSVFile("http://www.invescopowershares.com/PIDHoldings.csv")
>>
>>=smfGetCSVFile("http://www.invescopowershares.com/products/holdings.aspx?ticker=PID/PIDHoldings.csv")
>>
>>I know from the documentation that I need a PDelimiter, PDim1, and PDim2.  I also know that this file uses Java script to load the file.
>>
>>Can you help?
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2d.

Re: smfGetCSVFile()

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

Tue Mar 6, 2012 1:50 pm (PST)



No. At that point, it could have been a file they generated and then sent
to you. There may be no file sitting on the server to be downloaded -- it
may only be available through a process that generates it.

On Tue, Mar 6, 2012 at 2:41 PM, Ron Spruell <hashky@yahoo.com> wrote:

>
> When I clicked on Download the dialog box came up "You have chosen to open
> PIDHoldings.csv ... from http://www.invescopowershares.com."
>
> So, I assumed that was the link, but obviously it was not.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2e.

Re: smfGetCSVFile()

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Tue Mar 6, 2012 2:44 pm (PST)



I guess I will have to look elsewhere for this kind of a list.  Any suggestions?

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, March 6, 2012 3:50 PM
>Subject: Re: [smf_addin] smfGetCSVFile()
>
>
> 
>No. At that point, it could have been a file they generated and then sent to you. There may be no file sitting on the server to be downloaded -- it may only be available through a process that generates it.
>
>
>On Tue, Mar 6, 2012 at 2:41 PM, Ron Spruell <hashky@yahoo.com> wrote:
>
>
>>
>>When I clicked on Download the dialog box came up "You have chosen to open PIDHoldings.csv ... from http://www.invescopowershares.com."
>>
>>
>>So, I assumed that was the link, but obviously it was not.
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2f.

Re: smfGetCSVFile()

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

Tue Mar 6, 2012 3:05 pm (PST)



If you just need a list, how about:

http://www.masterdatacsv.com/ConstituentsReports/PID_D.csv

Or, possibly:

https://www.marketgrader.com/MGMainWeb/etfgrader/components.jsp?id=PID

On Tue, Mar 6, 2012 at 3:44 PM, Ron Spruell <hashky@yahoo.com> wrote:

>
> I guess I will have to look elsewhere for this kind of a list. Any
> suggestions?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2g.

Re: smfGetCSVFile()

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Tue Mar 6, 2012 4:41 pm (PST)



Thanks.  This gets me exactly what I wanted.

=smfGetCSVFile("http://www.masterdatacsv.com/ConstituentsReports/PID_D.csv")

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, March 6, 2012 5:05 PM
>Subject: Re: [smf_addin] smfGetCSVFile()
>
>
> 
>If  you just need a list, how about:
>
>http://www.masterdatacsv.com/ConstituentsReports/PID_D.csv
>
>Or, possibly:
>
>https://www.marketgrader.com/MGMainWeb/etfgrader/components.jsp?id=PID
>
>
>On Tue, Mar 6, 2012 at 3:44 PM, Ron Spruell <hashky@yahoo.com> wrote:
>
>
>>
>>I guess I will have to look elsewhere for this kind of a list.  Any suggestions?
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
3a.

Re: Help with Morningstar Premium - Portfolio Manager

Posted by: "b.kopacz" bkopacz@gmail.com   b.kopacz

Tue Mar 6, 2012 7:50 am (PST)



Thanks so much for the help Randy. I was able to get the data loaded however a single field is being duplicated across the board. Per your note, I would need a counter for both rows and columns.

Can this be accomplished using a macro? Can I use the smfWord function in a macro that would include a counter?

It sounds like I need to load each field independently as the counters would indicate. I am hoping a macro can solve this.

BK

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The table is dynamically generated, so the add-in won't be able to extract
> data from an HTML table -- it doesn't exist when the source code is
> delivered.
>
> HOWEVER, the data used to create the table *is* in JavaScript code, so you
> could extract the data there.
>
> For example, if I do:
>
> =RCHGetWebData("
> http://portfolio.morningstar.com/Rtport/Reg/MyView.aspx?ViewPage=5","var
> allData")
>
> ...I see this:
>
> var allData = {"B":{"DVS":"[['3M
> Co','MMM',86.77,-0.75,-0.86,'','',1000,86770,10.46,,'02-09-2012',0,4],['Consolidated
> Edison,
> Inc.','ED',58.38,0.07,0.12,'','',1000,58380,7.03,,'01-20-2012',0,2],...
>
> So there is the data for my MMM and ED lines of the portfolio. Something
> like this extracts the raw data fairly well for me:
>
> =smfWord(smfWord(RCHGetWebData(…URL...,"var
> allData"),…Line...,"["),…Column...,",")
>
> ...where "...URL..." is the URL for the M* portfolio page, "...Line..."
> varies from 3 to n, and "...Column..." varies from 1 to n:
>
> 1 2 3 4 5 6 7 8 9 10 11 12 13 14 *3* ’3M Co’ ’MMM’ 86.77 -0.75 -0.86 ’’
> ’’ 1000 86770 10.46 ’02-09-2012’ 0 4]
>
> On Mon, Mar 5, 2012 at 12:18 PM, b.kopacz <bkopacz@...> wrote:
>
> > I manage a few portfolios using Morningstar's Portfolio Manager. This is
> > both a free and pay-for service that Morningstar offers.
> > I would like to be able to pull in the portfolio contents into an excel
> > spreadsheet for manipulation.
> > The site is: https://portfolio.morningstar.com
> >
> > I am trying to use the GetTable function but am having trouble. Also,
> > when I view the source for the page it does not appear that the portfolio
> > is nested in a table, but my noobieness might be showing there.
> >
> > Any thoughts on what function I cna use to get my portfolio information
> > into excel?
> >
>

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

Re: Help with Morningstar Premium - Portfolio Manager

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

Tue Mar 6, 2012 12:54 pm (PST)



You could use smfWord() in a macro, but the VBA equivalent would be the
SPLIT() function -- it's what the smfWord() function uses.

One issue I ran into -- if the company name contains a comma, it throws off
the column pointers.

On Tue, Mar 6, 2012 at 8:50 AM, b.kopacz <bkopacz@gmail.com> wrote:

> Thanks so much for the help Randy. I was able to get the data loaded
> however a single field is being duplicated across the board. Per your
> note, I would need a counter for both rows and columns.
>
> Can this be accomplished using a macro? Can I use the smfWord function in
> a macro that would include a counter?
>
> It sounds like I need to load each field independently as the counters
> would indicate. I am hoping a macro can solve this.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4.

Luano Cesar deixou uma mensagem para você...

Posted by: "Badoo" luanocesar@gmail.com   luanocesar

Tue Mar 6, 2012 9:18 am (PST)



Luano Cesar deixou uma mensagem para você...

Só você pode ler o conteúdo desta mensagem e ver quem a enviou. Delete a qualquer momento ou responda imediatamente com o sistema de troca de mensagens. Para descobrir o que diz a mensagem, siga este link.
http://us1.badoo.com/01118096819/in/FTdITsqCZ3s/?lang_id=61&m=63&mid=4f5646cb00000000003d0000a079657a

Mais gente dessa região que está no Badoo
Pardo (Manaus, Brasil)
Marlene (Cambará, Brasil)
Milleni (Manaus, Brasil)

http://us1.badoo.com/01118096819/in/FTdITsqCZ3s/?lang_id=61&m=63&mid=4f5646cb00000000003d0000a079657a

Se o link desta mensagem não funcionar, copie e cole-o em seu navegador.

Este email faz parte de nosso sistema de entrega para a mensagem enviada por Luano Cesar. Se recebeu este email por engano, por favor ignore-o. A mensagem será deletada em breve.

Divirta-se!
A Equipe Badoo

Você recebeu este email, porque um membro do Badoo deixou uma mensagem para você no Badoo. Esta é uma mensagem de somente envio.
Respostas a esta mensagem não são monitoradas ou respondidas.
Se você não quer receber mais mensagens do Badoo,
por favor nos notifique:
http://us1.badoo.com/impersonation.phtml?lang_id=61&mail_code=63&email=smf_addin%40yahoogroups.com&secret=&action=block&block_code=b1e7b0&m=63&mid=4f5646cb00000000003d0000a079657a
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
5a.

Holdings lookup

Posted by: "Brett" bpeven@yahoo.com   bpeven

Tue Mar 6, 2012 10:20 am (PST)



I just uploaded the file Holdings lookup.

I can't figure out why any companies with only one page of holdings, Shamrock for example, does not show up as having any holdings.

Thanks

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

Re: Holdings lookup

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

Tue Mar 6, 2012 1:09 pm (PST)



I have no idea how to look for Shamrock -- a symbol search on the name
gives me nothing.

What is the one page of holdings you're looking at, and why wouldn't you
use that URL?

On Tue, Mar 6, 2012 at 11:20 AM, Brett <bpeven@yahoo.com> wrote:

> I just uploaded the file Holdings lookup.
>
> I can't figure out why any companies with only one page of holdings,
> Shamrock for example, does not show up as having any holdings.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

Re: SMF-Morningstar-Holding-Style-Example.xls

Posted by: "kurt boesche" kurtboesche@att.net   kurtboesche@att.net

Tue Mar 6, 2012 1:29 pm (PST)



Randy,

The 3 step approach works,
B1:
=smfGetTagContent("http://portfolios.morningstar.com/fund/summary?t=VFINX","script",1,">Holdings
Style")
B2: =smfStrExtr(B1,"Order\"":1","}")
B3: =smfStrExtr(B2,"Label\"":\""","\")

but when I go to nest the 3 formulas (carefully cutting and pasting) I still get
a #value! return. Here are the formulas I'm trying to use.

=smfGetTagContent("http://portfolios.morningstar.com/fund/summary?t="&Ticker,"script",1,">Holdings
Style") This works and returns the following:
var
HoldingStyle_Box="{\"Type\":0,\"Labels\":{\"HLabels\":{\"Names\":[\"Value\",\"Blend\",\"Growth\"]},

\"VLabels\":{\"Names\":[\"Large\",\"Mid\",\"Small\"]}},\"Grids\":[{\"Order\":1,\"BColor\":\"#7c87a7\",
\"FColor\":\"#FFFFFF\",\"Label\":\"44\"},{\"Order\":2,\"BColor\":\"#c8cbd9\",
\"FColor\":\"\",\"Label\":\"19\"},{\"Order\":3,\"BColor\":\"#7c87a7\",\"FColor\":\"#FFFFFF\",\"Label\":\"30\"},{\"Order\":4,\"BColor\":\"#ffffff\",\"FColor\":\"\",\"Label\":\"2\"},{\"Order\":5,\"BColor\":\"#ffffff\",\"FColor\":\"\",\"Label\":\"2\"},{\"Order\":6,\"BColor\":\"#ffffff\",\"FColor\":\"\",\"Label\":\"2\"},{\"Order\":7,\"BColor\":\"#ffffff\",\"FColor\":\"\",\"Label\":\"0\"},{\"Order\":8,\"BColor\":\"#ffffff\",\"FColor\":\"\",\"Label\":\"0\"},{\"Order\":9,\"BColor\":\"#ffffff\",\"FColor\":\"\",\"Label\":\"1\"}]}";
function getHoldingStleChart(){ var stylebox=new
Chart.StyleBox($("#oPanelMain1"),0);
stylebox.setCulture("en_us");
stylebox.setData(HoldingStyle_Box);
stylebox.draw(); }

Next I try this
formula: =smfStrExtr(smfGetTagContent("http://portfolios.morningstar.com/fund/summary?t="&Ticker,"script",1,">Holdings
Style"),"Order\"":1","}") This returns
#VALUE!

Finally this:
=smfStrExtr(smfStrExtr(smfGetTagContent("http://portfolios.morningstar.com/fund/summary?t="&Ticker,"script",1,">Holdings
Style"),"Order\"":1","}"),"Label\"":\""","\") This also returns
#VALUE!

And yet when I use the 3 formula approach and replace the smfGetTagContent()
function with a literal cell reference the same formulas work
G1:=smfGetTagContent("http://portfolios.morningstar.com/fund/summary?t="&Ticker,"script",1,">Holdings
Style")
G2:=smfStrExtr(G1,"Order\"":1","}")
G3:=smfStrExtr(G2,"Label\"":\""","\")

It's not as elegant as your nested one-line formulas because I can't easily
transfer my grid from worksheet to worksheet without the supporting formulas,
but I'll keep working it.

>From: Randy H <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Tue, March 6, 2012 2:28:13 AM
>Subject: [smf_addin] Re: SMF-Morningstar-Holding-Style-Example.xls
>
>
>Hmmm. Does this function work:
>
>=smfStrExtr("""FColor\"":\""#FFFFFF\"",\""Label\"":\""29\""}","Label\"":\""","\")
>
>
>It should return 29.
>
>The only thing I can think of is that you're not pairing up your double-quotes
>properly. You need one at the start, one at the end, and a pair of them for each
>one that is actually within the searched-for string.
>
>Otherwise, breaking it out should be:
>
>B1:
>=smfGetTagContent("http://portfolios.morningstar.com/fund/summary?t=VFINX","script",1,">Holdings
> Style")
>B2: =smfStrExtr(B1,"Order\"":1","}")
>B3: =smfStrExtr(B2,"Label\"":\""","\")
>
>All of the double-quotes are the same character -- you're not using something
>that displays them as a left double-quote and a right double-quote, right? EXCEL
>doesn't allow the left and right double-quotes to be used as string delimiters.
>
>
>On Tue, Mar 6, 2012 at 12:58 AM, kurt boesche <kurtboesche@att.net> wrote:
>
>
>>
>>I used the ticker you provided and several other well known funds such as FAIRX,
>>SEQUX and DODFX and as I said, when I break out the smfGetTagContent() function
>>on it's own I get valid return data.
>>
>>
>>When I was troubleshooting this I inserted the smfStrExtr() using the Excel
>>function wizard and no matter what I tried to enter for the PStart argument it
>>would give me "invalid" or else wouldn't return any data. I also tried
>>inserting the smfStrExtr() function manually and typing in the arguments exactly
>>as you have them but still no go.
>>
>
>
>Reply to sender | Reply to group | Reply via web post | Start a New Topic
>Messages in this topic (12)
>
>Recent Activity: * New Members 105 * New Files 1
>Visit Your Group
>
>Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use
>.
>
>__,_._,__
>_
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
6b.

Re: SMF-Morningstar-Holding-Style-Example.xls

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

Tue Mar 6, 2012 1:48 pm (PST)



When I cut and paste that formula, it returns what I expect. I only get
#VALUE! if there is no named "Ticker" cell. I get a null string if there is
to ticker symbol in the referred cell.

Hmmm. I think I may know the problem -- you have EXCEL 2003. I've gotten
#VALUE! errors in some cases when an internal function returns a string
length that is too long and exceeds the EXCEL specifications. EXCEL 2003
may have lower limits than what I have in EXCEL 2007, which would explain
why it works for me and not for you. In this case, the string length is
about 1100 characters, so I'll assume the EXCEL 2003 limit may be 255
characters?

If that is the issue, try this, which limits the returned string to 250
bytes:

=smfStrExtr(RCHGetWebData("http://portfolios.morningstar.com/fund/summary?t=
"&C4,"Order\"":1",250),"Label\"":\""","\")

On Tue, Mar 6, 2012 at 2:29 PM, kurt boesche <kurtboesche@att.net> wrote:

>
> Next I try this formula: =smfStrExtr(smfGetTagContent("
> http://portfolios.morningstar.com/fund/summary?t="&Ticker,"script",1,">HoldingsStyle"),"Order\"":1","}") This returns
> #VALUE!
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
6c.

Re: SMF-Morningstar-Holding-Style-Example.xls

Posted by: "kurt boesche" kurtboesche@att.net   kurtboesche@att.net

Tue Mar 6, 2012 2:16 pm (PST)



Randy,

That worked brilliantly for me, thank you so much. Not only is my M* Style grid
working but now I know I'm not crazy...yet. I never would have figured that out
on my
own. Thank you once again.

>
>From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Tue, March 6, 2012 3:48:46 PM
>Subject: Re: [smf_addin] Re: SMF-Morningstar-Holding-Style-Example.xls
>
>
>When I cut and paste that formula, it returns what I expect. I only get #VALUE!

>if there is no named "Ticker" cell. I get a null string if there is to ticker
>symbol in the referred cell.
>
>Hmmm. I think I may know the problem -- you have EXCEL 2003. I've gotten #VALUE!
>
>errors in some cases when an internal function returns a string length that is
>too long and exceeds the EXCEL specifications. EXCEL 2003 may have lower limits

>than what I have in EXCEL 2007, which would explain why it works for me and not

>for you. In this case, the string length is about 1100 characters, so I'll
>assume the EXCEL 2003 limit may be 255 characters?
>
>If that is the issue, try this, which limits the returned string to 250 bytes:
>
>=smfStrExtr(RCHGetWebData("http://portfolios.morningstar.com/fund/summary?t="&C4,"Order\"":1",250),"Label\"":\""","\";)
>
>
>
>
>On Tue, Mar 6, 2012 at 2:29 PM, kurt boesche <kurtboesche@att.net> wrote:
>
>
>>
>>Next I try this
>>formula: =smfStrExtr(smfGetTagContent("http://portfolios.morningstar.com/fund/summary?t=%22&Ticker,%22script%22,1,%22%3EHoldings
>>
>> Style"),"Order\"":1","}") This returns
>>#VALUE!
>>
>>
>>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
7a.

Is there a function to obtain the "Probability of Expiration" for an

Posted by: "tlw4033" tlw4033@gmail.com   tlw4033

Tue Mar 6, 2012 4:26 pm (PST)




For an option, is there a function call to get:

Probability of Expire?

(Which typically means the probability for the option to expire 1 cent or more ITM. Another related probability is the probability of touching the strike price between now and expiration. I am interested in the first.)

Thanks,

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

Re: Is there a function to obtain the "Probability of Expiration" fo

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

Tue Mar 6, 2012 8:12 pm (PST)



Which function to use, or if one can even be used, would depend on how the
data is presented. What source did you have in mind?

On Tue, Mar 6, 2012 at 4:56 PM, tlw4033 <tlw4033@gmail.com> wrote:

>
> For an option, is there a function call to get:
>
> Probability of Expire?
>
> (Which typically means the probability for the option to expire 1 cent or
> more ITM. Another related probability is the probability of touching the
> strike price between now and expiration. I am interested in the first.)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
8a.

Problem In Earnings.com

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

Wed Mar 7, 2012 1:14 am (PST)



Is there any site replacement for the earnings.com???

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

Re: Problem In Earnings.com

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

Wed Mar 7, 2012 1:15 am (PST)



Why? What's the problem?

On Wed, Mar 7, 2012 at 2:12 AM, bleushin19 <bleushin19@yahoo.com> wrote:

> Is there any site replacement for the earnings.com???
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
8c.

Re: Problem In Earnings.com

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

Wed Mar 7, 2012 1:23 am (PST)



Earnings.com could not load up here in Philippines...

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Why? What's the problem?
>
> On Wed, Mar 7, 2012 at 2:12 AM, bleushin19 <bleushin19@...> wrote:
>
> > Is there any site replacement for the earnings.com???
> >
>

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

Re: Problem In Earnings.com

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

Wed Mar 7, 2012 1:26 am (PST)



Its ok now..haha..only used proxy server... thanks

--- In smf_addin@yahoogroups.com, "bleushin19" <bleushin19@...> wrote:
>
> Earnings.com could not load up here in Philippines...
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Why? What's the problem?
> >
> > On Wed, Mar 7, 2012 at 2:12 AM, bleushin19 <bleushin19@> wrote:
> >
> > > Is there any site replacement for the earnings.com???
> > >
> >
>

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

Question...

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

Wed Mar 7, 2012 1:55 am (PST)




Are there any other site except www.reuters.com that displays Valuation Ratios,Dividends,Growth Rates,Financial Strength,Profitability Ratios,
Efficiency,Management Effectiveness?

because some TICKER symbol (for example: PSEC) don't show any values, its because there is no data for it in the reuters website..

Can anybody tell me?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
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

Fashion News

What's the word on

fashion and style?

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 01.55

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)