Messages In This Digest (11 Messages)
- 1a.
- Data from CBOE for weekly options From: Peter
- 1b.
- Re: Data from CBOE for weekly options From: Randy Harmelink
- 2a.
- Re: Spreadsheet Auto-Update From: Mark
- 3a.
- Re: curious From: paul messerschmidt
- 3b.
- Re: curious From: Randy Harmelink
- 4a.
- Re: Refresh Button From: D
- 4b.
- Re: Refresh Button From: Randy Harmelink
- 5a.
- Pulling Competitors off of Yahoo! Finance From: scott jackson
- 5b.
- Re: Pulling Competitors off of Yahoo! Finance [1 Attachment] From: Randy Harmelink
- 6a.
- RCHGetElementNumber problem with ADVFN template From: mutantcar
- 6b.
- Re: RCHGetElementNumber problem with ADVFN template From: Randy Harmelink
Messages
- 1a.
-
Data from CBOE for weekly options
Posted by: "Peter" go_archi@yahoo.com go_archi
Fri Sep 9, 2011 3:51 am (PDT)
Is there a worksheet available to retrieve data from CBOE for weekly options? or is't possible to get data from that site?
http://www.cboe.com/DelayedQuote /quotetable. aspx
Thanks
Peter
- 1b.
-
Re: Data from CBOE for weekly options
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Sep 9, 2011 8:04 am (PDT)
I've not had any luck getting data from the site. I can't create a
bookmarkable URL.
On Fri, Sep 9, 2011 at 3:51 AM, Peter <go_archi@yahoo.com > wrote:
> Is there a worksheet available to retrieve data from CBOE for weekly
> options? or is't possible to get data from that site?
>
> http://www.cboe.com/DelayedQuote /quotetable. aspx
>
- 2a.
-
Re: Spreadsheet Auto-Update
Posted by: "Mark" drklein01@gmail.com drmark27
Fri Sep 9, 2011 9:01 am (PDT)
Yup that does work. Opening the spreadsheet today
shows yesterday's closing data at the bottom.
Thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> No reason to auto-update at the end of each day, or maintain a database.
> When you open the workbook, the formulas will get the currently available
> data from the Internet. There should be no reason for you to be re-entering
> the formulas -- perhaps you have calculation set to manual?
>
> On Thu, Sep 8, 2011 at 11:47 AM, Mark <drklein01@...> wrote:
>
> > I'm new here so let me first give thanks to you, Randy, for sharing your
> > work with us and continuing to offer your time in monitoring and responding
> > to this group.
> >
> > What I want to do is maintain an historical Excel database that I can
> > easily auto-update at the end of each day. I have a starting date in mind
> > so what I have done thus far is size the 3-column array accordingly so as to
> > have the starting date at the top and the most recent date at the bottom.
> >
> > I suspect this is not the best setup for auto-updating the database,
> > however. I actually have several ticker symbols that I wish to update every
> > day in the same size array. The formula I have been using is
> > =RCHGetYahooHistory("XYZ",,, ,,,,,"TDA" ,,,1) since all I care about is the
> > ticker, date, and adjusted close and I want the desired starting date to be
> > at the top. Tomorrow morning if I wish to add today's close, though, it
> > appears I will have to click on the upper-left cell, highlight the entire
> > array plus one additional row, and ctrl-shift-enter . That will be
> > relatively cumbersome to do with several tickers in non-consecutive columns
> > of one spreadsheet.
> >
> > Is there a way I can have the arrays automatically fill from the desired
> > start date through the most recent day's quote upon every opening of the
> > spreadsheet?
> >
>
- 3a.
-
Re: curious
Posted by: "paul messerschmidt" financepaul@gmail.com fuelspotpaul
Fri Sep 9, 2011 9:08 am (PDT)
here's a bit more on randy (from spokeo)
http://www.spokeo.com/search? q=Randy%20Harmel ink#:3626274111
<http://www.spokeo.com/search? >and fromq=Randy%20Harmel ink#:3626274111
classmates
http://www.classmates.com/directory /public/memberpr ofile/list. htm?regId= 50269411
<http://www.classmates.com/directory >/public/memberpr ofile/list. htm?regId= 50269411
On Wed, Sep 7, 2011 at 9:51 PM, james morlock <JimMorlock@optonline.net >wrote:
> **
>
>
>
> I would tell your friend that Randy is just a highly skilled and gifted man
> who is incredably helpful and generous in sharing what he knows.
>
> Thank you Randy.
>
> On Wed, Sep 7, 2011 at 8:44 PM, Randy Harmelink wrote:
>
> No "about me" link. Not that much to tell.
>
> I lived in Minnesota (St. Paul) most of my life, from the ages of 4-49,
> except for the 3 years I attended Iowa State University -- but moved to
> Phoenix when I "retired" in 2006.
>
> On Wed, Sep 7, 2011 at 5:30 PM, wu_ming_sg < *nghongchong@hotmail.com *>
> wrote:
> Do you have a "about me" link?
>
> I like to mail my friend and let him understand more what kind of a great
> person is behind this amazing plugin!
>
> I am guessing you are in the East side of USA?
>
> <http://docs.yahoo.com/ >info/terms/
>
>
>
--
--------------------- --------- --------- --
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
- 3b.
-
Re: curious
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Sep 9, 2011 9:23 am (PDT)
Hmmm. I never joined spokeo. I wonder where they got their information? It's
only 5 years out of date. :)
My nephew lives in my St. Paul condo now.
On Fri, Sep 9, 2011 at 9:08 AM, paul messerschmidt <financepaul@gmail.com >wrote:
>
> here's a bit more on randy (from spokeo)
>
> http://www.spokeo.com/search? q=Randy%20Harmel ink#:3626274111
>
> <http://www.spokeo.com/search? >and fromq=Randy%20Harmel ink#:3626274111
> classmates
>
>
> http://www.classmates.com/directory /public/memberpr ofile/list. htm?regId= 50269411
>
>
- 4a.
-
Re: Refresh Button
Posted by: "D" n1144n@comcast.net n1144n
Fri Sep 9, 2011 12:55 pm (PDT)
Hi Randy,
On the EXCEL 2007 Data tab there is an icon named "Refresh All". Does this do the same update as your "refresh button"?
thanks, --N
--- In smf_addin@yahoogroups.com , "thtabe" <thtabe@...> wrote:
>
> Hello all,
>
> How do I build a refresh button into my spread sheet? I have read the FAQ for the "smfforcerecalculation macro and how to use it" and cannot get it to work for me.
>
> Thanks
> Tarry
>
- 4b.
-
Re: Refresh Button
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Sep 9, 2011 12:56 pm (PDT)
No. EXCEL "Refresh all" is an EXCEL process that just applies to EXCEL data
queries. It will not update add-in functions.
On Fri, Sep 9, 2011 at 11:58 AM, D <n1144n@comcast.net > wrote:
>
> On the EXCEL 2007 Data tab there is an icon named "Refresh All". Does this
> do the same update as your "refresh button"?
> thanks, --N
>
- 5a.
-
Pulling Competitors off of Yahoo! Finance
Posted by: "scott jackson" scottandrewjackson@yahoo.com scottandrewjackson
Fri Sep 9, 2011 1:09 pm (PDT)
[Attachment(s) from scott jackson included below]
Randy,
Using the RCHgettablecell function I am trying to pull the competitors ticker symbols off of yahoo finance http://finance.yahoo.com/ There is no title in the row labled "tickers" and there is no column header. Do you have any suggestions?q/co?s=SIGM+ Competitors.
I included a screen shot that I've attached to this email.
Cheers,
- Scott Jackson
Attachment(s) from scott jackson
1 of 1 Photo(s)
- 5b.
-
Re: Pulling Competitors off of Yahoo! Finance [1 Attachment]
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Sep 9, 2011 1:33 pm (PDT)
Just go backwards, as in:
=RCHGetTableCell("http://finance. yahoo.com/ ",column,"Marketq/co?s=SIGM
Cap:",,,,-2)
...varying "column" from 2 to 6.
On Fri, Sep 9, 2011 at 1:09 PM, scott jackson
<scottandrewjackson@yahoo.com >wrote:
>
> Using the RCHgettablecell function I am trying to pull the competitors
> ticker symbols off of yahoo finance
> http://finance.yahoo.com/ There is no title inq/co?s=SIGM+ Competitors.
> the row labled "tickers" and there is no column header. Do you have any
> suggestions?
>
>
- 6a.
-
RCHGetElementNumber problem with ADVFN template
Posted by: "mutantcar" mutant.car@virgin.net mutantcar
Fri Sep 9, 2011 1:24 pm (PDT)
Hi,
I'm getting 'error' for every RCHGetElementNumber in the RCHGetElementNumber-Template- AdvFN-Financial- Statements.
I'm trying to get UK Stocks initially. I've tried 'LLOY', 'LSE:LLOY', 'LLOY.L' in the Ticker field, to no avail. I've also tried 'IBM'.
I've tried with both Excel 2010 & 2007, both on Vista
'Version' parameter returns: 'Stock Market Functions add-in, Version 2.1.2010.08.02' - the latest I believe?
The template is otherwise 'Out of the box'.
Any ideas?
Thanks,
Joe.
- 6b.
-
Re: RCHGetElementNumber problem with ADVFN template
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Sep 9, 2011 3:26 pm (PDT)
I don't see any financial statements data for LSE:LLOY on AdvFN, so you
*would* get "Error" returned for any attempted data retrievals there.
However, IBM is currently working for me. Check the "Links" area of the
group for an AdvFN item there that may help.
On Fri, Sep 9, 2011 at 1:24 PM, mutantcar <mutant.car@virgin.net > wrote:
>
> I'm getting 'error' for every RCHGetElementNumber in the
> RCHGetElementNumber-Template- AdvFN-Financial- Statements.
>
> I'm trying to get UK Stocks initially. I've tried 'LLOY', 'LSE:LLOY',
> 'LLOY.L' in the Ticker field, to no avail. I've also tried 'IBM'.
>
> I've tried with both Excel 2010 & 2007, both on Vista
>
> 'Version' parameter returns: 'Stock Market Functions add-in, Version
> 2.1.2010.08.02' - the latest I believe?
>
> The template is otherwise 'Out of the box'.
>
> Any ideas?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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
Tidak ada komentar:
Posting Komentar