Messages In This Digest (7 Messages)

1.: Way to fix MSN problem From: Patrick

2a.: morningstar element information error From: ryanbrown@bellsouth.net
2b.: Re: morningstar element information error From: Randy Harmelink

3a.: Problems looking up MSN data From: Pi
3b.: Re: Problems looking up MSN data From: Randy Harmelink

4a.: historic data From: Stefn Rai
4b.: Re: historic data From: Randy Harmelink

View All Topics | Create New Topic

Messages

1.: Way to fix MSN problem

Posted by: "Patrick" patrick.van.beesen@perso.be patrickvb

Mon May 7, 2012 2:34 am (PDT)

For those who have problem with MSN

1) First open an Msn Money session in Internet Explorer
2) Open excel and load your sheet with MSN RCHGetElementNumber().

For me it works this way.
Patrick.

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

2a.: morningstar element information error

Posted by: "ryanbrown@bellsouth.net" ryanbrown@rlbrown.net ryanbrown@bellsouth.net

Mon May 7, 2012 4:00 pm (PDT)

I am another newbie so forgive me if I have a made an error here. I have successfully installed installed the smf_add-in and have been able to retrieve data for most items. So, I know in theory that it is "working".

I started plugging the morningstar elements into a spreadsheet and came up with different results. Specifically, elements 13962 through 13976 worked as expected and delivered results, however, 13961 (valuation 10 Year) returned a "0" for apple. I moved on to 14217 (key ratios revenue growth) and received "ERROR" for elements 14217 - 14227 (apple as well). I then tried 14261 through 14271 with apple the same results "ERROR".

I am using excel 2007 on windows 7 64 bit. smf add-in 2.1.2012.02.02.

anyone offer some advice?

Thanks,

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.: Re: morningstar element information error

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

Mon May 7, 2012 4:11 pm (PDT)

#13961 is "zero" on the MorningStar web page (or at least a "--", which the
add-in sets to zero so it's numeric).

#14217-#14227 and #14261-#14271 are working fine here for Apple, so I'm not
sure what to tell you. Did you try other ticker symbols? Maybe you timed
out on a web page retrieval from MorningStar?

On Mon, May 7, 2012 at 3:52 PM, ryanbrown@bellsouth.net <
ryanbrown@rlbrown.net> wrote:

> I am another newbie so forgive me if I have a made an error here. I have
> successfully installed installed the smf_add-in and have been able to
> retrieve data for most items. So, I know in theory that it is "working".
>
> I started plugging the morningstar elements into a spreadsheet and came up
> with different results. Specifically, elements 13962 through 13976 worked
> as expected and delivered results, however, 13961 (valuation 10 Year)
> returned a "0" for apple. I moved on to 14217 (key ratios revenue growth)
> and received "ERROR" for elements 14217 - 14227 (apple as well). I then
> tried 14261 through 14271 with apple the same results "ERROR".
>
> I am using excel 2007 on windows 7 64 bit. smf add-in 2.1.2012.02.02.
>
> anyone offer some advice?
>

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

3a.: Problems looking up MSN data

Posted by: "Pi" parisshi@yahoo.com parisshi

Mon May 7, 2012 4:46 pm (PDT)

Hello,

I have been trying to load MSN data. I have tried the following and I'm still still having a hard time:
1. Logged into Msn Money using internet explorer before opening up my template
2. Downloaded the new smf-elements 1.txt file from the wip folder (while excel was closed).

Still no luck. What am I missing?
Penny

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.: Re: Problems looking up MSN data

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

Mon May 7, 2012 5:38 pm (PDT)

What do you get with:

=RCHGetElementNumber("Version")
=smfGetAParms(1)
=smfGetAParms(13862)
=RCHGetElementNumber("MMM",13862)
=TRIM(smfStrExtr("|"&smfGetTagContent("
http://investing.money.msn.com/investments/stock-report?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=MMM
","div",-1,"class=""cn"">"),"|","<"))

Also, can you import data from here:

http://investing.money.msn.com/investments/stock-report?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=MMM

...using the EXCEL Web Query (it may take a while for the page to complete)?

On Mon, May 7, 2012 at 4:46 PM, Pi <parisshi@yahoo.com> wrote:

> Hello,
>
> I have been trying to load MSN data. I have tried the following and I'm
> still still having a hard time:
> 1. Logged into Msn Money using internet explorer before opening up my
> template
> 2. Downloaded the new smf-elements 1.txt file from the wip folder (while
> excel was closed).
>
> Still no luck. What am I missing?
>

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

4a.: historic data

Posted by: "Stefn Rai" rainerglobal@ymail.com rainerglobal@ymail.com

Mon May 7, 2012 10:18 pm (PDT)

Hi, I am trying to download the historic last,open,high,low data from http://www.forexpros.com/indices/us-30-futures-historical-data using RCHGetTableCell. However, the only value(text actually) I can retrieve is US30GetQuotesforGetQuotes. I think I am on the right track, but if someone could help me the rest of the way it would be much appreciated. I am using the tablecell as RCHGetTableCell("http://www.forexpros.com/indices/us-30-futures-historical-data",1,2,2,,2,0,"May 08, 2012"), but no luck so far.

Regards,
Steven

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.: Re: historic data

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

Mon May 7, 2012 10:37 pm (PDT)

Sorry, but there are no historical quotes to extract from the source code
of the web page. It's placed there dynamically. The add-in can only extract
data from the source code of a web page.

On Mon, May 7, 2012 at 10:18 PM, Stefn Rai <rainerglobal@ymail.com> wrote:

>
> Hi, I am trying to download the historic last,open,high,low data from
> http://www.forexpros.com/indices/us-30-futures-historical-data using *
> RCHGetTableCell*. However, the only value(text actually) I can retrieve
> is US30GetQuotesforGetQuotes. I think I am on the right track, but if
> someone could help me the rest of the way it would be much appreciated. I
> am using the tablecell as RCHGetTableCell("
> http://www.forexpros.com/indices/us-30-futures-historical-data",1,2,2,,2,0,"May08, 2012"), but no luck so far.
>

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

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

EXCEL FEED

Selasa, 08 Mei 2012

[smf_addin] Digest Number 2204

Messages In This Digest (7 Messages)

Messages

Way to fix MSN problem

Posted by: "Patrick" patrick.van.beesen@perso.be patrickvb

Mon May 7, 2012 2:34 am (PDT)

morningstar element information error

Posted by: "ryanbrown@bellsouth.net" ryanbrown@rlbrown.net ryanbrown@bellsouth.net

Mon May 7, 2012 4:00 pm (PDT)

Re: morningstar element information error

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

Mon May 7, 2012 4:11 pm (PDT)

Problems looking up MSN data

Posted by: "Pi" parisshi@yahoo.com parisshi

Mon May 7, 2012 4:46 pm (PDT)

Re: Problems looking up MSN data

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

Mon May 7, 2012 5:38 pm (PDT)

historic data

Posted by: "Stefn Rai" rainerglobal@ymail.com rainerglobal@ymail.com

Mon May 7, 2012 10:18 pm (PDT)

Re: historic data

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

Mon May 7, 2012 10:37 pm (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me