Sabtu, 26 November 2011

[smf_addin] Digest Number 2027[2 Attachments]

Messages In This Digest (15 Messages)

Messages

1a.

Re: Happy Thanksgiving, Randy!

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Fri Nov 25, 2011 6:01 am (PST)



I'll echo that!!

Though, I may not post often I do read every entry and have gained a great
deal from everyone's input.

Many THANKS to Randy for a great program.

Kermit

-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of timdbui
Sent: Thursday, November 24, 2011 8:00 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Happy Thanksgiving, Randy!

Happy Thanksgiving and thank you for your work in updating the add-in
program for all of us, Randy! Much appreciation for your contributions.

Tim

------------------------------------

Yahoo! Groups Links

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

Re: Insert "Trends in Twitter" chart in BATS Template

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

Fri Nov 25, 2011 6:17 am (PST)




Thanks, I tried to do a web query and I couldn't get the chart that way either.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try the URL you're using in your browser:
>
> http://trendistic.indextank.com/_embed-745/ge/_24-hours
>
> I don't see an image. I get the text of a script. When I visit the web page
> that has the chart on it, my browser doesn't identify the chart as an
> image. I don't see a picture there that EXCEL can import.
>
> On Thu, Nov 24, 2011 at 12:40 PM, ronmac17 <ronmac17@...> wrote:
>
> > Randy, I wanted to add a chart from Trendistic
> > http://trendistic.indextank.com/ to the BATS realtime template. I used
> > this URL from the site
> > http://trendistic.indextank.com/_embed-745/ge/_24-hours. My Comment
> > inputs were
> > =RCHCreateComment("http://trendistic.indextank.com/_embed-745/ge/_24-hours
> > ",99,400,190,1)
> > No chart shows up. Not sure where I made a mistake. Could you tell what I
> > did wrong here.
> >
>

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

Add in for Excel is not working for some reason !!!!!

Posted by: "Ashish" ashishkm@yahoo.com   ashishkm

Fri Nov 25, 2011 7:32 am (PST)



I am a newbie and i just joined this group because from what I read elsewhere the RCH add-in should be able to get me the data I need from Yahoo to my excel sheet.

I just downloaded RCH_Stock_Market_Functions-2.1.2010.08.02.zip file to my VISTA OS desktop and then unzipped it to SMF Add-in folder in the Program File. I then dbl clicked RCH_Stock_Market_Functions and, to the best of my knowledge nothing happened on any of my excel files. My excel files do have Add-ins Menu Item and the Excel add-ins do include couple other add-ins but I don't see anything in that list that seems to indicate this add-in - as of yet.

What did I do wrong? What should be my next steps in order to use this add-in to download needed data from YAHOO?

Thanks.

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

Re: Add in for Excel is not working for some reason !!!!!

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

Fri Nov 25, 2011 7:36 am (PST)



Check the "Documentation" folder in the files area.

On Fri, Nov 25, 2011 at 8:28 AM, Ashish <ashishkm@yahoo.com> wrote:

> I am a newbie and i just joined this group because from what I read
> elsewhere the RCH add-in should be able to get me the data I need from
> Yahoo to my excel sheet.
>
> I just downloaded RCH_Stock_Market_Functions-2.1.2010.08.02.zip file to my
> VISTA OS desktop and then unzipped it to SMF Add-in folder in the Program
> File. I then dbl clicked RCH_Stock_Market_Functions and, to the best of my
> knowledge nothing happened on any of my excel files. My excel files do have
> Add-ins Menu Item and the Excel add-ins do include couple other add-ins but
> I don't see anything in that list that seems to indicate this add-in - as
> of yet.
>
> What did I do wrong? What should be my next steps in order to use this
> add-in to download needed data from YAHOO?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3c.

Re: Add in for Excel is not working for some reason !!!!!

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Fri Nov 25, 2011 10:06 am (PST)

[Attachment(s) from Ashish Mukerji included below]

Hello .... I am sorry if I am troubling you .... Based upon your suggestion, I did check in the documentation area and picked up pointers that led me thru the process of adding-in and as you can see from the attached image the add-in window now does indicate the proper add-in (stock market functions)  is available to Excel .... But then, what do I need to do download the necessary information from Yahoo? ... I tried everything I could think of ... any and all help is welcome ... Thx..... 
 
Ashish         

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, November 25, 2011 10:36 AM
>Subject: Re: [smf_addin] Add in for Excel is not working for some reason !!!!!
>
>
> 
>Check the "Documentation" folder in the files area.
>
>
>On Fri, Nov 25, 2011 at 8:28 AM, Ashish <ashishkm@yahoo.com> wrote:
>
>I am a newbie and i just joined this group because from what I read elsewhere the RCH add-in should be able to get me the data I need from Yahoo to my excel sheet.
>>
>>I just downloaded RCH_Stock_Market_Functions-2.1.2010.08.02.zip file to my VISTA OS desktop and then unzipped it to SMF Add-in folder in the Program File. I then dbl clicked RCH_Stock_Market_Functions and, to the best of my knowledge nothing happened on any of my excel files. My excel files do have Add-ins Menu Item and the Excel add-ins do include couple other add-ins but I don't see anything in that list that seems to indicate this add-in - as of yet.
>>
>>What did I do wrong? What should be my next steps in order to use this add-in to download needed data from YAHOO?
>>
>
>
>
>

Attachment(s) from Ashish Mukerji

1 of 1 File(s)

Add-in Window Image.doc
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3d.

Re: Add in for Excel is not working for some reason !!!!! [1 Attachm

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

Fri Nov 25, 2011 10:17 am (PST)



Just try some of the function examples that are in the documentation...

On Fri, Nov 25, 2011 at 11:06 AM, Ashish Mukerji <ashishkm@yahoo.com> wrote:

>
> Hello .... I am sorry if I am troubling you .... Based upon your
> suggestion, I did check in the documentation area and picked up pointers
> that led me thru the process of adding-in and as you can see from the
> attached image the add-in window now does indicate the proper add-in (stock
> market functions) is available to Excel .... But then, what do I need to
> do download the necessary information from Yahoo? ... I tried everything I
> could think of ... any and all help is welcome ... Thx.....
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3e.

Re: Add in for Excel is not working for some reason !!!!!

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Fri Nov 25, 2011 1:40 pm (PST)



Hi Randy .... 

Slowly but surely I am getting there and I am now able to use your template for stocks .... Previously I had missed the "array" feature of excel that you do mention in the documentation area .... 

I have now gone over Message 2281 discussions for options - calls and puts ... I do need to figure this one out for my needs ... In your response to the Calls/Puts option the example of IBM is fine except that I need the same information (just as I do as for stocks) in a similar array format for a select group of Call and Put options however, I do not need columns N thru R for the selected group of options .... 

In that vein, It seems to me that understanding the format and code parameters for this call - http://finance.yahoo.com/q/op?s="&$B3&"&k="&$C3,1,">Expires",,,,1 - is essential .... is this documented somewhere? .... 

Finally, I do not also understand how does {RCHGetYahooQuotes(B4:B203,C2:V2)} figure out what "data elements" (in Columns C thru R) are to be grabbed? ... 

I am sure a little bit more of your hand holding would get me there ... I appreciate your help very very much .... 
 
Ashish         

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, November 25, 2011 1:17 PM
>Subject: Re: [smf_addin] Add in for Excel is not working for some reason !!!!!
>
>
> 
>Just try some of the function examples that are in the documentation...
>
>
>On Fri, Nov 25, 2011 at 11:06 AM, Ashish Mukerji <ashishkm@yahoo.com> wrote:
>
>
>>
>>Hello .... I am sorry if I am troubling you .... Based upon your suggestion, I did check in the documentation area and picked up pointers that led me thru the process of adding-in and as you can see from the attached image the add-in window now does indicate the proper add-in (stock market functions)  is available to Excel .... But then, what do I need to do download the necessary information from Yahoo? ... I tried everything I could think of ... any and all help is welcome ... Thx.....
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3f.

Re: Add in for Excel is not working for some reason !!!!!

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

Fri Nov 25, 2011 2:05 pm (PST)



On Fri, Nov 25, 2011 at 2:40 PM, Ashish Mukerji <ashishkm@yahoo.com> wrote:

>
> I have now gone over Message 2281 discussions for options - calls and puts
> ... I do need to figure this one out for my needs ... In your response to
> the Calls/Puts option the example of IBM is fine except that I need the
> same information (just as I do as for stocks) in a similar array format for
> a select group of Call and Put options however, I do not need columns N
> thru R for the selected group of options ....
>

If you need option quotes, use the new smfGetOptionQuotes() (and related)
functions. I had to write it when Yahoo stopped providing option quotes
through their CSV interface -- which is what RCHGetYahooQuotes() uses.

> In that vein, It seems to me that understanding the *format* and *code
> parameters* for this call - http://finance.yahoo.com/q/op?s="&$B3&"&k="&$C3,1,">Expires",,,,1
> - is essential .... is this documented somewhere? ....
>

In the documentation for the function. Except for the URL coding of course
-- that's standard URL coding, unrelated to the add-in.

Finally, I do not also understand how does
> {RCHGetYahooQuotes(B4:B203,C2:V2)} figure out *what* "data elements" (in
> Columns C thru R) are to be grabbed? ...
>

Whatever it finds in columns C thru R. It uses the Yahoo codes that are
shown in the documentation of the function.

Also, be sure to check out the "Links" area of the group for tips and FAQs.
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3g.

Re: smfGetOptionQuotes()

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Fri Nov 25, 2011 3:06 pm (PST)



Randy .. Thanks once again ... most of my questions have been answered and the link and faqs did help ....thank you so very much for doing this ... you mentioned "new smfGetOptionQuotes()" as a solution for my need for option quotes .... when i went to this file - http://finance.groups.yahoo.com/group/smf_addin/files/Add-In%20Files/smf%20add-in/     ....  it says the folder is empty .... i did find documentation of some related material in "work in progress" folder, but not the executable code for the add-in etc ... may be that's the way it is .. ie, you are still working at it and I wish you all the very best and am thankful for all your efforts ... plz. let me know if I am on the right track .. Thx ... 

Ashish         

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, November 25, 2011 5:05 PM
>Subject: Re: [smf_addin] Add in for Excel is not working for some reason !!!!!
>
>
> 
>On Fri, Nov 25, 2011 at 2:40 PM, Ashish Mukerji <ashishkm@yahoo.com> wrote:
>
>
>>
>>I have now gone over Message 2281 discussions for options - calls and puts ... I do need to figure this one out for my needs ... In your response to the Calls/Puts option the example of IBM is fine except that I need the same information (just as I do as for stocks) in a similar array format for a select group of Call and Put options however, I do not need columns N thru R for the selected group of options .... 
>
>If you need option quotes, use the new smfGetOptionQuotes() (and
related) functions. I had to write it when Yahoo stopped providing
option quotes through their CSV interface -- which is what
RCHGetYahooQuotes() uses.
> 
>In that vein, It seems to me that understanding the format and code parameters for this call - http://finance.yahoo.com/q/op?s="&$B3&"&k="&$C3,1,">Expires",,,,1 - is essential .... is this documented somewhere? .... 
>
>In the documentation for the function. Except for the URL coding of course -- that's standard URL coding, unrelated to the add-in.
>
>
>Finally, I do not also understand how does {RCHGetYahooQuotes(B4:B203,C2:V2)} figure out what "data elements" (in Columns C thru R) are to be grabbed? ... 
>
>Whatever it finds in columns C thru R. It uses the Yahoo codes that are shown in the documentation of the function.
>
>Also, be sure to check out the "Links" area of the group for tips and FAQs.
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3h.

Re: smfGetOptionQuotes()

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

Fri Nov 25, 2011 3:37 pm (PST)



That folder was created by someone else -- I just deleted it.

The "Documentation" folder is a main folder on the "Files" page:

http://finance.groups.yahoo.com/group/smf_addin/files/Documentation/

If you want to view the VBA code, just go to the VBA project in EXCEL. It's
all open source.

The documentation in the "Works in Progress" folder is for new functions
that are in the beta version of the add-in that is available in that
folder. In fact, you'll probably want all of the updated *.txt files from
that folder -- I've had to redefine a number of data element this year due
to web site changes. Or, if you want the new functions, just use the new
zip file there and you'll get all new updated files. You can check the
change log in that folder to see if there are changes that are of interest.

On Fri, Nov 25, 2011 at 4:06 PM, Ashish Mukerji <ashishkm@yahoo.com> wrote:

>
> Randy .. Thanks once again ... most of my questions have been answered and
> the link and faqs did help ....thank you so very much for doing this ...
> you mentioned "new smfGetOptionQuotes()" as a solution for my need for
> option quotes .... when i went to this file -
> http://finance.groups.yahoo.com/group/smf_addin/files/Add-In%20Files/smf%20add-in/
> .... it says the folder is empty .... i did find documentation of
> some related material in "work in progress" folder, but not the executable
> code for the add-in etc ... may be that's the way it is .. ie, you are
> still working at it and I wish you all the very best and am thankful for
> all your efforts ... plz. let me know if I am on the right track .. Thx ...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3i.

Re: smfGetOptionQuotes()

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Fri Nov 25, 2011 5:45 pm (PST)

[Attachment(s) from Ashish Mukerji included below]

Hi Randy ... VBA is way beyond me .. I am not a programmer at all ... I can barely manage with Excel .... Attached is the Picture Image of the success so far by using  {=smfGetOptionQuotes(B5:B203,c2:h2,1)} .... your help and wonderful documentation has taken me this far .... so now,  does there exist an equivalent version of  SMF Template-RCHGet YahooQoutes()  for a selected group of quotes using smfGetOptionQuotes()? ... if not then, is there a future possibility? .... Thanks a million  for all your help so far ....
 
Ashish         

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, November 25, 2011 6:37 PM
>Subject: Re: [smf_addin] smfGetOptionQuotes()
>
>
> 
>That folder was created by someone else -- I just deleted it.
>
>The "Documentation" folder is a main folder on the "Files" page:
>
>http://finance.groups.yahoo.com/group/smf_addin/files/Documentation/
>
>If you want to view the VBA code, just go to the VBA project in EXCEL. It's all open source.
>
>The documentation in the "Works in Progress" folder is for new functions that are in the beta version of the add-in that is available in that folder. In fact, you'll probably want all of the updated *.txt files from that folder -- I've had to redefine a number of data element this year due to web site changes. Or, if you want the new functions, just use the new zip file there and you'll get all new updated files. You can check the change log in that folder to see if there are changes that are of interest.
>
>
>On Fri, Nov 25, 2011 at 4:06 PM, Ashish Mukerji <ashishkm@yahoo.com> wrote:
>
>
>>
>>Randy .. Thanks once again ... most of my questions have been answered and the link and faqs did help ....thank you so very much for doing this ... you mentioned "new smfGetOptionQuotes()" as a solution for my need for option quotes .... when i went to this file - http://finance.groups.yahoo.com/group/smf_addin/files/Add-In%20Files/smf%20add-in/     ....  it says the folder is empty .... i did find documentation of some related material in "work in progress" folder, but not the executable code for the add-in etc ... may be that's the way it is .. ie, you are still working at it and I wish you all the very best and am thankful for all your efforts ... plz. let me know if I am on the right track .. Thx ...
>>
>
>
>
>

Attachment(s) from Ashish Mukerji

1 of 1 File(s)

Add-in Window Image.doc
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3j.

Re: smfGetOptionQuotes() [1 Attachment]

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

Fri Nov 25, 2011 6:06 pm (PST)



Your two errors on the image are from:

1. The "%" data code item is only valid if you are using MSN as your
data source. The default is Yahoo, so it's not a recognized data code in
your usage.

2. I mixed up the documentation at one point -- the "u" data code is
something I added after the official release, so it's in the documentation,
but only available in the Beta version of the add-in from the "Works in
Progress" folder. There also are more updated to that documentation in the
"Works in Progress" folder, for additional changes in the Beta version.

I haven't uploaded any templates for smfGetOptionQuotes(), sorry. There are
so many different permutations, it would be difficult to have one. It's one
reason the documentation for the function has a lot of examples. Also,
there are some additional options functions in the Beta version of the
add-in, as well as having Google added as a data source. Information on two
of the new functions:

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

Also, I do have a few options templates in the files area of this Yahoo
group:

http://finance.groups.yahoo.com/group/justcoveredcalls

Another thing you can look at is using another function to grab data. For
example, array-entered over a range:

=RCHGetHTMLTable("http://finance.yahoo.com/q/op?s=MMM&m=2012-07
","Expiration:",1,"Highlighted",-1)

...will get you both the call and put tables from Yahoo for ticker MMM for
the July expiration in 2012.

On Fri, Nov 25, 2011 at 6:45 PM, Ashish Mukerji <ashishkm@yahoo.com> wrote:

>
> Hi Randy ... VBA is way beyond me .. I am not a programmer at all ... I
> can barely manage with Excel .... Attached is the Picture Image of the
> success so far by using {=smfGetOptionQuotes(B5:B203,c2:h2,1)} .... your
> help and wonderful documentation has taken me this far .... so now, does
> there exist an equivalent version of SMF Template-RCHGet YahooQoutes()
> for a selected group of quotes using smfGetOptionQuotes()? ... if not
> then, is there a future possibility? .... Thanks a million for all your
> help so far ....
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3k.

Re: smfGetOptionQuotes()

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Fri Nov 25, 2011 6:39 pm (PST)



Thx. to you Randy, I am so far ahead now (at the end of this day) from ground zero where I started ... In my previous email, the intention was not to dwell on the errors as much as to show how much I was able to accomplish with your support .... I believ I am getting the feel for it and hopefully, this will continue to grow .... Thx. also for a wealth of information you provided related to this pursuit ... 
 
Ashish         

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, November 25, 2011 9:06 PM
>Subject: Re: [smf_addin] smfGetOptionQuotes()
>
>
> 
>Your two errors on the image are from:
>
> 1. The "%" data code item is only valid if you are using MSN as your data source. The default is Yahoo, so it's not a recognized data code in your usage.
>
>
> 2. I mixed up the documentation at one point -- the "u" data code is something I added after the official release, so it's in the documentation, but only available in the Beta version of the add-in from the "Works in Progress" folder. There also are more updated to that documentation in the "Works in Progress" folder, for additional changes in the Beta version.
>I haven't uploaded any templates for smfGetOptionQuotes(), sorry. There are so many different permutations, it would be difficult to have one. It's one reason the documentation for the function has a lot of examples. Also, there are some additional options functions in the Beta version of the add-in, as well as having Google added as a data source. Information on two of the new functions:
>
>http://finance.groups.yahoo.com/group/smf_addin/message/14130
>
>Also, I do have a few options templates in the files area of this Yahoo group:
>
>http://finance.groups.yahoo.com/group/justcoveredcalls
>
>Another thing you can look at is using another function to grab data. For example, array-entered over a range:
>
>=RCHGetHTMLTable("http://finance.yahoo.com/q/op?s=MMM&m=2012-07","Expiration:",1,"Highlighted",-1)
>
>...will get you both the call and put tables from Yahoo for ticker MMM for the July expiration in 2012.
>
>
>On Fri, Nov 25, 2011 at 6:45 PM, Ashish Mukerji <ashishkm@yahoo.com> wrote:
>
>
>>
>>Hi Randy ... VBA is way beyond me .. I am not a programmer at all ... I can barely manage with Excel .... Attached is the Picture Image of the success so far by using  {=smfGetOptionQuotes(B5:B203,c2:h2,1)} .... your help and wonderful documentation has taken me this far .... so now,  does there exist an equivalent version of  SMF Template-RCHGet YahooQoutes()  for a selected group of quotes using smfGetOptionQuotes()? ... if not then, is there a future possibility? .... Thanks a million  for all your help so far ....
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
4a.

Last Monthly Trading Day

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

Fri Nov 25, 2011 1:21 pm (PST)



How can I get the historical last trading day for each month?

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

Re: Last Monthly Trading Day

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

Fri Nov 25, 2011 1:30 pm (PST)



I think the easiest way would be to download the historical quotes for one
of the major indexes, then extract the last trading day of each month from
that downloaded data.

On Fri, Nov 25, 2011 at 2:21 PM, thomas91112 <thomas91112@yahoo.com> wrote:

> How can I get the historical last trading day for each month?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 02.06

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)