Sabtu, 05 Mei 2012

[smf_addin] Digest Number 2201

Messages In This Digest (14 Messages)

Messages

1a.

Re: MSN Data Element (1)

Posted by: "samuelmtaylor" samuelmtaylor@earthlink.net   samuelmtaylor

Fri May 4, 2012 1:51 pm (PDT)



Wow; that's a fast response.
I've loaded the new smf-elements-1.txt file and it fixed all my errors except this one. Perhaps the coding for element 1 needs to be updated or corrected?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You need the new element definitions in smf-elements-1.txt from the "Works
> in Progress" folder of the group's Files area. Exit EXCEL before updating
> the file in your add-in folder.
>
> On Fri, May 4, 2012 at 1:39 PM, samuelmtaylor
> <samuelmtaylor@...>wrote:
>
> > The company description pulled by =RCHGetElementNumber (XX,1)does not seem
> > to be working properly. Have I missed an update?
> >
>

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

Re: MSN Data Element (1)

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

Fri May 4, 2012 2:11 pm (PDT)



What do you get with:

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

What version of EXCEL do you have?

On Fri, May 4, 2012 at 1:51 PM, samuelmtaylor
<samuelmtaylor@earthlink.net>wrote:

>
> I've loaded the new smf-elements-1.txt file and it fixed all my errors
> except this one. Perhaps the coding for element 1 needs to be updated or
> corrected?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1c.

Re: MSN Data Element (1)

Posted by: "samuelmtaylor" samuelmtaylor@earthlink.net   samuelmtaylor

Fri May 4, 2012 4:07 pm (PDT)



Thanks.

=smfGetAParms(1):
MSN;Company Description;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=~~~~~;?;;;;;;;;0

=RCHGetElementNumber("MMM",1):
Financial data in <span> USD</span> <br /> Values in Millions (Except for per share items)

Excel 2007.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> What do you get with:
>
> =smfGetAParms(1)
> =RCHGetElementNumber("MMM",1)
>
> What version of EXCEL do you have?
>
> On Fri, May 4, 2012 at 1:51 PM, samuelmtaylor
> <samuelmtaylor@...>wrote:
>
> >
> > I've loaded the new smf-elements-1.txt file and it fixed all my errors
> > except this one. Perhaps the coding for element 1 needs to be updated or
> > corrected?
> >
>

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

Re: MSN Data Element (1)

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

Fri May 4, 2012 4:56 pm (PDT)



That's the old definition of the element, so you're not using the new
file...

On Fri, May 4, 2012 at 4:06 PM, samuelmtaylor
<samuelmtaylor@earthlink.net>wrote:

>
> =smfGetAParms(1):
> MSN;Company Description;
> 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=~~~~~;?;;;;;;;;0
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1e.

Re: MSN Data Element (1)

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

Fri May 4, 2012 5:01 pm (PDT)



My apologies. It turns out I never uploaded the new file after I changed
the definition of element #1, because I was still looking for other
elements that might need to be changed. No other elements needed updating,
so it's only element #1 that wouldn't be working.

I just uploaded my current file.

On Fri, May 4, 2012 at 4:06 PM, samuelmtaylor
<samuelmtaylor@earthlink.net>wrote:

>
> =smfGetAParms(1):
> MSN;Company Description;
> 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=~~~~~;?;;;;;;;;0
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1f.

Re: MSN Data Element (1)

Posted by: "samuelmtaylor" samuelmtaylor@earthlink.net   samuelmtaylor

Fri May 4, 2012 5:37 pm (PDT)



Thanks. No need to apologize. This is a great group and a great set of products! Thanks for all your good work.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> My apologies. It turns out I never uploaded the new file after I changed
> the definition of element #1, because I was still looking for other
> elements that might need to be changed. No other elements needed updating,
> so it's only element #1 that wouldn't be working.
>
> I just uploaded my current file.
>
> On Fri, May 4, 2012 at 4:06 PM, samuelmtaylor
> <samuelmtaylor@...>wrote:
>
> >
> > =smfGetAParms(1):
> > MSN;Company Description;
> > 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=~~~~~;?;;;;;;;;0
> >
>

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

I'm new to the group. Forgive my ignorance.

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

Fri May 4, 2012 3:15 pm (PDT)




I presently subscribe to eSignal's QCharts which includes an Excel data feed called QLink. It's a miracle.

I need real-time Bid/Ask/Last for stocks and options.

I'm pretty proficient in Excel, but can't find an idiot-simple start-up guide to import web data into Excel (so I can cancel my $130/month QCharts subscription).

I see various programs on the web that says they'll import data from the websites (like Yahoo), but will they do what I want? What do I know?

I see lots of advanced programming language tips out there, but no start-up advice.

I would sincerely appreciate any advice anyone can give me.

Thanks for your patience.

jtbleecker

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

Re: I'm new to the group. Forgive my ignorance.

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

Fri May 4, 2012 4:00 pm (PDT)



If you need a lot of stock and option quotes, I wouldn't suggest the
add-in.

But the two functions you would be using would be RCHGetYahooQuotes() and
smfGetOptionQuotes(). Documentation for each function can be found in the
"Documentation" folder of the files area.

An example of setting up and RCHGetYahooQuotes() table:

http://finance.groups.yahoo.com/group/smf_addin/message/124

An smfGetOptionQuotes() table would be similar, but data retrieval would be
slower because Yahoo provides stock quotes as a CSV file, but option quotes
must be retrieved via web pages.

The functions would return delayed quotes unless you sign up for Yahoo's
real time quotes. If you're using weekly options, note that Yahoo doesn't
get the new listings right away. I usually get my option quotes from
OptionsXPress, but they aren't real-time.

On Fri, May 4, 2012 at 2:59 PM, jtbleecker <jtbleecker@yahoo.com> wrote:

>
> I presently subscribe to eSignal's QCharts which includes an Excel data
> feed called QLink. It's a miracle.
>
> I need real-time Bid/Ask/Last for stocks and options.
>
> I'm pretty proficient in Excel, but can't find an idiot-simple start-up
> guide to import web data into Excel (so I can cancel my $130/month QCharts
> subscription).
>
> I see various programs on the web that says they'll import data from the
> websites (like Yahoo), but will they do what I want? What do I know?
>
> I see lots of advanced programming language tips out there, but no
> start-up advice.
>
> I would sincerely appreciate any advice anyone can give me.
>
> Thanks for your patience.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3.1.

New file uploaded to smf_addin

Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com

Fri May 4, 2012 4:59 pm (PDT)




Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Works-In-Progress/smf-elements-1.txt
Uploaded by : rharmelink <rharmelink@gmail.com>
Description : Contains updates to MSN data element definitions, which had to be redefined because of URL and page layout changes made by MSN. These definitions are used by the RCHGetElementNumber() function.

You can access this file at the URL:
http://groups.yahoo.com/group/smf_addin/files/Works-In-Progress/smf-elements-1.txt

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

rharmelink <rharmelink@gmail.com>


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

Randy...HELP!!..how do i use smf under windows 7  64 bit on my  new

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

Fri May 4, 2012 7:29 pm (PDT)



Hello Randy,
This will probably be the 1st of several questions I will have.
I recently bought a new lenovo thinkpad laptop 64 bit, that operates under Windows 7. My old Dell desktop (about 8-10 yrs old) runs under
Windows XP. I have been using your smf files successfully on my old computer. I am now slowing moving everything to my new computer and am experiencing difficulty.

1. My new computer has 2 c:\program files folders... one of which has an (x86) in the name...which i believe is for 32 bit programs. I believe the other is for 64 bit programs..not sure at this point.

Which of these folders should I move the smf add in to?

2. Note, at this time, I have moved it to what I believe is the 64 bit folder, which does not have the (x86) in the folder name.

I also put my older excel programs in there to try them.

They aren't working (they were done under 32 bit excel).

Do I have to put these excel spreadsheets elsewhere but keep your
add in and associated files in the 64 bit folder..I ask this because I remember reading a similar question at your group here and think you said to put your add in in the 64 bit folder because of the title being the same you use in your software?

In and case...when I currently pull up one of my old spreadsheet..some things come up too fast for me to read them..then go away..and I see a message that says something like excel couldn't read or retrieve the file.

Pls advise..how do i use spreadsheets i created with windwows 2002 with smf under 64 bit windows 7?

thx.

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

Addendum..HELP!!..how do i use smf under windows 7  64 bit on my  ne

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

Fri May 4, 2012 7:34 pm (PDT)



The message I am getting in Excel 2010 when I click a worksheet is "There was a problem sending the command to the program"..help !!!

--- In smf_addin@yahoogroups.com, "investor952" <investor952@...> wrote:
>
> Hello Randy,
> This will probably be the 1st of several questions I will have.
> I recently bought a new lenovo thinkpad laptop 64 bit, that operates under Windows 7. My old Dell desktop (about 8-10 yrs old) runs under
> Windows XP. I have been using your smf files successfully on my old computer. I am now slowing moving everything to my new computer and am experiencing difficulty.
>
> 1. My new computer has 2 c:\program files folders... one of which has an (x86) in the name...which i believe is for 32 bit programs. I believe the other is for 64 bit programs..not sure at this point.
>
> Which of these folders should I move the smf add in to?
>
> 2. Note, at this time, I have moved it to what I believe is the 64 bit folder, which does not have the (x86) in the folder name.
>
> I also put my older excel programs in there to try them.
>
> They aren't working (they were done under 32 bit excel).
>
> Do I have to put these excel spreadsheets elsewhere but keep your
> add in and associated files in the 64 bit folder..I ask this because I remember reading a similar question at your group here and think you said to put your add in in the 64 bit folder because of the title being the same you use in your software?
>
> In and case...when I currently pull up one of my old spreadsheet..some things come up too fast for me to read them..then go away..and I see a message that says something like excel couldn't read or retrieve the file.
>
> Pls advise..how do i use spreadsheets i created with windwows 2002 with smf under 64 bit windows 7?
>
> thx.
>

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

Re: Addendum..HELP!!..how do i use smf under windows 7 64 bit on my

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

Fri May 4, 2012 8:16 pm (PDT)



Google the error message and you should find a solution. I've never seen
the message before.

On Fri, May 4, 2012 at 7:34 PM, investor952 <investor952@yahoo.com> wrote:

> The message I am getting in Excel 2010 when I click a worksheet is "There
> was a problem sending the command to the program"..help !!!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4d.

Re: Randy...HELP!!..how do i use smf under windows 7 64 bit on my ne

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

Fri May 4, 2012 8:20 pm (PDT)



The add-in can be located almost anywhere. The only issue with the location
is in sharing files with other computers. If the add-in isn't in the same
location when the workbook is saved and when the workbook is open, you'll
need to manually edit unresolved links (or run the smfFixLinks macro).

I currently have my add-in located here, because of issues I had with the
Program Files folder when I moved from XP to Vista:

C:/SMF Add-in

Your EXCEL files should be in your "Documentation" folder, where all of
your personal files are.

On Fri, May 4, 2012 at 7:29 PM, investor952 <investor952@yahoo.com> wrote:

> This will probably be the 1st of several questions I will have.
> I recently bought a new lenovo thinkpad laptop 64 bit, that operates under
> Windows 7. My old Dell desktop (about 8-10 yrs old) runs under
> Windows XP. I have been using your smf files successfully on my old
> computer. I am now slowing moving everything to my new computer and am
> experiencing difficulty.
>
> 1. My new computer has 2 c:\program files folders... one of which has an
> (x86) in the name...which i believe is for 32 bit programs. I believe the
> other is for 64 bit programs..not sure at this point.
>
> Which of these folders should I move the smf add in to?
>
> 2. Note, at this time, I have moved it to what I believe is the 64 bit
> folder, which does not have the (x86) in the folder name.
>
> I also put my older excel programs in there to try them.
>
> They aren't working (they were done under 32 bit excel).
>
> Do I have to put these excel spreadsheets elsewhere but keep your
> add in and associated files in the 64 bit folder..I ask this because I
> remember reading a similar question at your group here and think you said
> to put your add in in the 64 bit folder because of the title being the same
> you use in your software?
>
> In and case...when I currently pull up one of my old spreadsheet..some
> things come up too fast for me to read them..then go away..and I see a
> message that says something like excel couldn't read or retrieve the file.
>
> Pls advise..how do i use spreadsheets i created with windwows 2002 with
> smf under 64 bit windows 7?
>
> thx.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5.1.

Re: Instructions for fixing the elements problem....

Posted by: "Pete A" optionzz@gmail.com   option2z

Sat May 5, 2012 1:02 am (PDT)



Hi Kermit,

"GetData" is a utility program written by Randy awhile back. It processes a single row of "codes" against a bunch of tickers, filling out the matrix with a single call to a VBA routine. I don't think he supports it, but I found it in the files section sometime or other.

Appreciate your trying it; the number still 13862 still returns nothing, even after updating with the latest elements-1.txt file. Not urgent; I'll get to analyzing why it doesn't work in the "GetData" implementation.

Pete A

--- In smf_addin@yahoogroups.com, "Kermit W. Prather" <kermitp@...> wrote:
>
> Pete, I just tried
> =RCHGetElementNumber($E1, $A20)
> Where $E1 was the symbol
> And $A20 was the element
>
> And it worked just fine.
>
> What is GETDATA? It is not part of the add-in
>
>
> Kermit
>
>
> -----Original Message-----
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of Pete A
> Sent: Thursday, May 03, 2012 6:27 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: Instructions for fixing the elements problem....
>
> Thanks Mike. I had been following that MSM thing, and had downloaded the
> elements-1.txt file...still doesn't work. Most of the fixes do.
>
> Appreciate the quick response! Save Randy a few minutes...
>
> Pete A
>
> --- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@> wrote:
> >
> > Pete, 13862 comes from MSN. See all the messages recently about the
> > changes at MSN. In short, you need the new elements-1.txt file in the
> > Works in Progress folder.
> >
> > _____
> >
> > From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On
> > Behalf Of Pete A
> > Sent: Thursday, May 03, 2012 5:41 PM
> > To: smf_addin@yahoogroups.com
> > Subject: [smf_addin] Re: Instructions for fixing the elements problem....
> >
> >
> >
> >
> > 13862 (company name) doesn't work at all when using the utility "GetData"
> > It's been down for several days now; I haven't delved into it because
> > it isn't critical. Is there something differenct about how GetData does
> it?
> > Thanks Randy!
> > Pete A
> >
> > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> > , Randy Harmelink <rharmelink@> wrote:
> > >
> > > All of those element numbers are working fine for me right now:
> > >
> > > Element #
> > > MMM NFLX Element Description
> > > 13862 3M Co Netflix Inc Company Name 55 15.1 23.8 % Growth Rate --
> > <snip> 13862.... When do you think the errors of those elements are
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (32)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

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.19

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)