15 New Messages
Digest #2565
Messages
Fri Mar 29, 2013 10:02 am (PDT) . Posted by:
"Subu S" mail_to_subu
--- In smf_addin@yahoogrou
>
> Does this work on your machine?
>
> smfGetTagContent(
> http://investing.
> ")
If I open a fresh sheet & type, =smfGetTagContent(
However If I have MMM in cell A4 on my smfUpdateDownloadTa
the system is looking for ticker B4 !!
...AND I don't know how to make the reference to the cell different in that formula :-(
regards
Subu
>
> On Fri, Mar 29, 2013 at 8:42 AM, Subu S <mail_to_
>
> >
> > > Do I recall that you have an older
> > > version of EXCEL?
> > > If so, it may be exceeding a string limit of that version
> > > of EXCEL.
> >
> > That's were your terrific memory got my attention and applause !! yes..I
> > use XL 2003..
> >
> > BTW, Is there something I can do to avoid the error ?
> >
>
Fri Mar 29, 2013 10:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's a column definition for smfUpdateDownloadTable....
The ~~~~~ tells the macro where to place the ticker symbol.
On Fri, Mar 29, 2013 at 10:02 AM, Subu S <mail_to_subu@yahoo.com > wrote:
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Does this work on your machine?
> >
> > smfGetTagContent("
> > http://investing.money.msn.com/investments/stock-price?Symbol=~~~~~
> ","a",1,"<h1
> > ")
>
> If I open a fresh sheet & type, =smfGetTagContent("
> http://investing.money.msn.com/investments/stock-price?Symbol=MMM ","a",1,"<h1
> ") I get 3M Co as the result
>
> However If I have MMM in cell A4 on my
> smfUpdateDownloadTable-Graham_worksheet.xls sheet and I type the following
> on cell B4 =smfGetTagContent("
> http://investing.money.msn.com/investments/stock-price?Symbol=B4 ","a",1,"<h1
> ") then obviously I get nothing because
> the system is looking for ticker B4 !!
>
> ...AND I don't know how to make the reference to the cell different in
> that formula :-(
>
The ~~~~~ tells the macro where to place the ticker symbol.
On Fri, Mar 29, 2013 at 10:02 AM, Subu S <mail_to_subu@
>
> --- In smf_addin@yahoogrou
> >
> > Does this work on your machine?
> >
> > smfGetTagContent(
> > http://investing.
> ","
> > ")
>
> If I open a fresh sheet & type, =smfGetTagContent(
> http://investing.
> ") I get 3M Co as the result
>
> However If I have MMM in cell A4 on my
> smfUpdateDownloadTa
> on cell B4 =smfGetTagContent(
> http://investing.
> ") then obviously I get nothing because
> the system is looking for ticker B4 !!
>
> ...AND I don't know how to make the reference to the cell different in
> that formula :-(
>
Fri Mar 29, 2013 10:44 am (PDT) . Posted by:
"foolishblisterbutt" foolishblisterbutt
Hi,
I have used the RCHGetElementNumber() heavily, but today it started failing at most stocks, not all of them, but most? It just shows "Error" in the field.
I use the latest version of the SMF plugin.
Anybody else having the same problem?
Best regards,
Frederik
I have used the RCHGetElementNumber
I use the latest version of the SMF plugin.
Anybody else having the same problem?
Best regards,
Frederik
Fri Mar 29, 2013 10:47 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Without examples of ticker symbols and element numbers, it's hard to help.
Could be a website is down, or has changed the format of their web page.
If AdvFN elements, you may need the fix mentioned in the LINKS area of the
group...
On Fri, Mar 29, 2013 at 10:29 AM, foolishblisterbutt <fgschack@gmail.com >wrote:
>
> I have used the RCHGetElementNumber() heavily, but today it started
> failing at most stocks, not all of them, but most? It just shows "Error" in
> the field.
>
> I use the latest version of the SMF plugin.
>
> Anybody else having the same problem?
>
>
Could be a website is down, or has changed the format of their web page.
If AdvFN elements, you may need the fix mentioned in the LINKS area of the
group...
On Fri, Mar 29, 2013 at 10:29 AM, foolishblisterbutt <fgschack@gmail.
>
> I have used the RCHGetElementNumber
> failing at most stocks, not all of them, but most? It just shows "Error" in
> the field.
>
> I use the latest version of the SMF plugin.
>
> Anybody else having the same problem?
>
>
Fri Mar 29, 2013 11:07 am (PDT) . Posted by:
"अनन्त:" ritchemie
Can you please give the link to fix this issue, I went to the links section
but could not find anything.
I would really appreciate your help
Au
On Fri, Mar 29, 2013 at 1:47 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> Without examples of ticker symbols and element numbers, it's hard to help.
> Could be a website is down, or has changed the format of their web page.
>
> If AdvFN elements, you may need the fix mentioned in the LINKS area of the
> group...
>
>
> On Fri, Mar 29, 2013 at 10:29 AM, foolishblisterbutt <fgschack@gmail.com >wrote:
>
>>
>> I have used the RCHGetElementNumber() heavily, but today it started
>> failing at most stocks, not all of them, but most? It just shows "Error" in
>> the field.
>>
>> I use the latest version of the SMF plugin.
>>
>> Anybody else having the same problem?
>>
>>
>
>
but could not find anything.
I would really appreciate your help
Au
On Fri, Mar 29, 2013 at 1:47 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> Without examples of ticker symbols and element numbers, it's hard to help.
> Could be a website is down, or has changed the format of their web page.
>
> If AdvFN elements, you may need the fix mentioned in the LINKS area of the
> group...
>
>
> On Fri, Mar 29, 2013 at 10:29 AM, foolishblisterbutt <fgschack@gmail.
>
>>
>> I have used the RCHGetElementNumber
>> failing at most stocks, not all of them, but most? It just shows "Error" in
>> the field.
>>
>> I use the latest version of the SMF plugin.
>>
>> Anybody else having the same problem?
>>
>>
>
>
Fri Mar 29, 2013 12:29 pm (PDT) . Posted by:
"foolishblisterbutt" foolishblisterbutt
Hi,
I think the problem is with Excel, because if I try to do a manual calculate it runs until some point and then stops before it's finished.
I had a similar issue earlier on, if I went to use another program while it was calculating, but then it would finish if I didn't use any other program. Now it just seems to stop, even though I don't use another program.
Maybe an old version of Excel could help me.
Best regards,
Frederik
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Without examples of ticker symbols and element numbers, it's hard to help.
> Could be a website is down, or has changed the format of their web page.
>
> If AdvFN elements, you may need the fix mentioned in the LINKS area of the
> group...
>
> On Fri, Mar 29, 2013 at 10:29 AM, foolishblisterbutt <fgschack@...>wrote:
>
> >
> > I have used the RCHGetElementNumber() heavily, but today it started
> > failing at most stocks, not all of them, but most? It just shows "Error" in
> > the field.
> >
> > I use the latest version of the SMF plugin.
> >
> > Anybody else having the same problem?
> >
> >
>
I think the problem is with Excel, because if I try to do a manual calculate it runs until some point and then stops before it's finished.
I had a similar issue earlier on, if I went to use another program while it was calculating, but then it would finish if I didn't use any other program. Now it just seems to stop, even though I don't use another program.
Maybe an old version of Excel could help me.
Best regards,
Frederik
--- In smf_addin@yahoogrou
>
> Without examples of ticker symbols and element numbers, it's hard to help.
> Could be a website is down, or has changed the format of their web page.
>
> If AdvFN elements, you may need the fix mentioned in the LINKS area of the
> group...
>
> On Fri, Mar 29, 2013 at 10:29 AM, foolishblisterbutt <fgschack@
>
> >
> > I have used the RCHGetElementNumber
> > failing at most stocks, not all of them, but most? It just shows "Error" in
> > the field.
> >
> > I use the latest version of the SMF plugin.
> >
> > Anybody else having the same problem?
> >
> >
>
Fri Mar 29, 2013 1:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's this entry in the LINKS area:
AdvFN.001 - A possible fix for "Error" responses from AdvFN due to a change
from a Windows Update.
http://finance.groups.yahoo.com/group/smf_addin/message/10464
On Fri, Mar 29, 2013 at 11:06 AM, अनन्त: <1998chemie@gmail.com > wrote:
>
> Can you please give the link to fix this issue, I went to the links
> section but could not find anything.
> I would really appreciate your help
> Au
>
> On Fri, Mar 29, 2013 at 1:47 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
>
>> **
>>
>> Without examples of ticker symbols and element numbers, it's hard to
>> help. Could be a website is down, or has changed the format of their web
>> page.
>>
>> If AdvFN elements, you may need the fix mentioned in the LINKS area of
>> the group...
>>
>
AdvFN.001 - A possible fix for "Error" responses from AdvFN due to a change
from a Windows Update.
http://finance.
On Fri, Mar 29, 2013 at 11:06 AM, अनन्त: <1998chemie@gmail.
>
> Can you please give the link to fix this issue, I went to the links
> section but could not find anything.
> I would really appreciate your help
> Au
>
> On Fri, Mar 29, 2013 at 1:47 PM, Randy Harmelink <rharmelink@gmail.
>
>> **
>>
>> Without examples of ticker symbols and element numbers, it's hard to
>> help. Could be a website is down, or has changed the format of their web
>> page.
>>
>> If AdvFN elements, you may need the fix mentioned in the LINKS area of
>> the group...
>>
>
Fri Mar 29, 2013 2:42 pm (PDT) . Posted by:
"foolishblisterbutt" foolishblisterbutt
Hi,
I was wrong, something is wrong with the add-in.
The request below returns an error:
=RCHGetElementNumber("AACC",947)
But this request doesn't:
=RCHGetElementNumber("AAME",947)
Both of them exist on finance.yahoo.com:
http://finance.yahoo.com/q?s=aacc&ql=1
http://finance.yahoo.com/q?s=AAME&ql=1
I have tried to re-download the SMF add-in, but it doesn't help.
Best regards,
Frederik
--- In smf_addin@yahoogroups.com , "foolishblisterbutt" <fgschack@...> wrote:
>
> Hi,
>
> I think the problem is with Excel, because if I try to do a manual calculate it runs until some point and then stops before it's finished.
>
> I had a similar issue earlier on, if I went to use another program while it was calculating, but then it would finish if I didn't use any other program. Now it just seems to stop, even though I don't use another program.
>
> Maybe an old version of Excel could help me.
>
> Best regards,
> Frederik
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Without examples of ticker symbols and element numbers, it's hard to help.
> > Could be a website is down, or has changed the format of their web page.
> >
> > If AdvFN elements, you may need the fix mentioned in the LINKS area of the
> > group...
> >
> > On Fri, Mar 29, 2013 at 10:29 AM, foolishblisterbutt <fgschack@>wrote:
> >
> > >
> > > I have used the RCHGetElementNumber() heavily, but today it started
> > > failing at most stocks, not all of them, but most? It just shows "Error" in
> > > the field.
> > >
> > > I use the latest version of the SMF plugin.
> > >
> > > Anybody else having the same problem?
> > >
> > >
> >
>
I was wrong, something is wrong with the add-in.
The request below returns an error:
=RCHGetElementNumbe
But this request doesn't:
=RCHGetElementNumbe
Both of them exist on finance.yahoo.
http://finance.
http://finance.
I have tried to re-download the SMF add-in, but it doesn't help.
Best regards,
Frederik
--- In smf_addin@yahoogrou
>
> Hi,
>
> I think the problem is with Excel, because if I try to do a manual calculate it runs until some point and then stops before it's finished.
>
> I had a similar issue earlier on, if I went to use another program while it was calculating, but then it would finish if I didn't use any other program. Now it just seems to stop, even though I don't use another program.
>
> Maybe an old version of Excel could help me.
>
> Best regards,
> Frederik
>
> --- In smf_addin@yahoogrou
> >
> > Without examples of ticker symbols and element numbers, it's hard to help.
> > Could be a website is down, or has changed the format of their web page.
> >
> > If AdvFN elements, you may need the fix mentioned in the LINKS area of the
> > group...
> >
> > On Fri, Mar 29, 2013 at 10:29 AM, foolishblisterbutt <fgschack@
> >
> > >
> > > I have used the RCHGetElementNumber
> > > failing at most stocks, not all of them, but most? It just shows "Error" in
> > > the field.
> > >
> > > I use the latest version of the SMF plugin.
> > >
> > > Anybody else having the same problem?
> > >
> > >
> >
>
Fri Mar 29, 2013 3:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They both work fine here.
If you close down EXCEL, restart it, and enter just those two formula in a
new worksheet, does one work and the other return "Error"?
On Fri, Mar 29, 2013 at 2:42 PM, foolishblisterbutt <fgschack@gmail.com >wrote:
>
> I was wrong, something is wrong with the add-in.
>
> The request below returns an error:
> =RCHGetElementNumber("AACC",947)
>
> But this request doesn't:
> =RCHGetElementNumber("AAME",947)
>
> Both of them exist on finance.yahoo.com:
> http://finance.yahoo.com/q?s=aacc&ql=1
> http://finance.yahoo.com/q?s=AAME&ql=1
>
> I have tried to re-download the SMF add-in, but it doesn't help.
>
If you close down EXCEL, restart it, and enter just those two formula in a
new worksheet, does one work and the other return "Error"
On Fri, Mar 29, 2013 at 2:42 PM, foolishblisterbutt <fgschack@gmail.
>
> I was wrong, something is wrong with the add-in.
>
> The request below returns an error:
> =RCHGetElementNumbe
>
> But this request doesn't:
> =RCHGetElementNumbe
>
> Both of them exist on finance.yahoo.
> http://finance.
> http://finance.
>
> I have tried to re-download the SMF add-in, but it doesn't help.
>
Fri Mar 29, 2013 11:10 am (PDT) . Posted by:
"अनन्त:" ritchemie
Hi,
I use RCHGetElementNumber("MMM",xx) to get 10 years and quarterly data for
a company.
However I realized that some of the items are not there in that table like
stocks current price, 52 week low etc. There are other elements to get that
but I was wondering if it can be extracted from the link below.
http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AKO&start_date=15
your help and one example would be really appreciated.
regards
Au
I use RCHGetElementNumber
a company.
However I realized that some of the items are not there in that table like
stocks current price, 52 week low etc. There are other elements to get that
but I was wondering if it can be extracted from the link below.
http://www.advfn.
your help and one example would be really appreciated.
regards
Au
Fri Mar 29, 2013 12:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Easy peasy lemon squeezy! To pick up the 52-week high and low:
=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=KO ",1,">52
Weeks")
=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=KO ",2,">52
Weeks")
On Fri, Mar 29, 2013 at 11:10 AM, अनन्त: <1998chemie@gmail.com > wrote:
> I use RCHGetElementNumber("MMM",xx) to get 10 years and quarterly data
> for a company.
> However I realized that some of the items are not there in that table like
> stocks current price, 52 week low etc. There are other elements to get that
> but I was wondering if it can be extracted from the link below.
>
> http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AKO&start_date=15
>
> your help and one example would be really appreciated.
>
>
=RCHGetTableCell(
Weeks")
=RCHGetTableCell(
Weeks")
On Fri, Mar 29, 2013 at 11:10 AM, अनन्त: <1998chemie@gmail.
> I use RCHGetElementNumber
> for a company.
> However I realized that some of the items are not there in that table like
> stocks current price, 52 week low etc. There are other elements to get that
> but I was wondering if it can be extracted from the link below.
>
> http://www.advfn.
>
> your help and one example would be really appreciated.
>
>
Fri Mar 29, 2013 1:08 pm (PDT) . Posted by:
"अनन्त:" ritchemie
Randy
Thats great, you rock.
you are experienced so you know how to put 1, 2 etc etc and where would I
find descriptor to get the content.
if you have sometime can you explain the methodology so that I can apply to
tables from other sites as well.
On Fri, Mar 29, 2013 at 3:50 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> Easy peasy lemon squeezy! To pick up the 52-week high and low:
>
> =RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=KO ",1,">52
> Weeks")
> =RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=KO ",2,">52
> Weeks")
>
>
> On Fri, Mar 29, 2013 at 11:10 AM, अनन्त: <1998chemie@gmail.com > wrote:
>
>> I use RCHGetElementNumber("MMM",xx) to get 10 years and quarterly data
>> for a company.
>> However I realized that some of the items are not there in that table
>> like stocks current price, 52 week low etc. There are other elements to get
>> that but I was wondering if it can be extracted from the link below.
>>
>> http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AKO&start_date=15
>>
>> your help and one example would be really appreciated.
>>
>>
>
>
Thats great, you rock.
you are experienced so you know how to put 1, 2 etc etc and where would I
find descriptor to get the content.
if you have sometime can you explain the methodology so that I can apply to
tables from other sites as well.
On Fri, Mar 29, 2013 at 3:50 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> Easy peasy lemon squeezy! To pick up the 52-week high and low:
>
> =RCHGetTableCell(
> Weeks")
> =RCHGetTableCell(
> Weeks")
>
>
> On Fri, Mar 29, 2013 at 11:10 AM, अनन्त: <1998chemie@gmail.
>
>> I use RCHGetElementNumber
>> for a company.
>> However I realized that some of the items are not there in that table
>> like stocks current price, 52 week low etc. There are other elements to get
>> that but I was wondering if it can be extracted from the link below.
>>
>> http://www.advfn.
>>
>> your help and one example would be really appreciated.
>>
>>
>
>
Fri Mar 29, 2013 1:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You really need to look at the source code of the web page to determine the
best search strings. I usually take a shot with the ">" in front of a
table's row label. The ">" prefix can be useful because otherwise a search
string might show up in a sentence on the page or in the meta-tags of the
page (a description of the web page). But it doesn't work all the time,
since it depends on how the web page is coded. I'd say it applies 80-90% of
the time.
And, sometimes web page content that looks like it's a table isn't actually
a table. Then you need to use the smfGetTagContent() function to grab the
data, which almost universally requires a look at the source code.
Something like the smfGetTagContent-Quick-Webpage-Examination.xls template
can be handy for exploring the web page using various add-in functions.
On Fri, Mar 29, 2013 at 1:07 PM, अनन्त: <1998chemie@gmail.com > wrote:
> Thats great, you rock.
> you are experienced so you know how to put 1, 2 etc etc and where would I
> find descriptor to get the content.
> if you have sometime can you explain the methodology so that I can apply
> to tables from other sites as well.
>
> On Fri, Mar 29, 2013 at 3:50 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
>
>> **
>>
>> Easy peasy lemon squeezy! To pick up the 52-week high and low:
>>
>> =RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=KO ",1,">52
>> Weeks")
>> =RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=KO ",2,">52
>> Weeks")
>>
>>
best search strings. I usually take a shot with the ">" in front of a
table's row label. The ">" prefix can be useful because otherwise a search
string might show up in a sentence on the page or in the meta-tags of the
page (a description of the web page). But it doesn't work all the time,
since it depends on how the web page is coded. I'd say it applies 80-90% of
the time.
And, sometimes web page content that looks like it's a table isn't actually
a table. Then you need to use the smfGetTagContent(
data, which almost universally requires a look at the source code.
Something like the smfGetTagContent-
can be handy for exploring the web page using various add-in functions.
On Fri, Mar 29, 2013 at 1:07 PM, अनन्त: <1998chemie@gmail.
> Thats great, you rock.
> you are experienced so you know how to put 1, 2 etc etc and where would I
> find descriptor to get the content.
> if you have sometime can you explain the methodology so that I can apply
> to tables from other sites as well.
>
> On Fri, Mar 29, 2013 at 3:50 PM, Randy Harmelink <rharmelink@gmail.
>
>> **
>>
>> Easy peasy lemon squeezy! To pick up the 52-week high and low:
>>
>> =RCHGetTableCell(
>> Weeks")
>> =RCHGetTableCell(
>> Weeks")
>>
>>
Fri Mar 29, 2013 11:13 am (PDT) . Posted by:
"Sharon McAllister" sharonnraymc
Hi Randy, When will you be updating the latest beta version of the add-in? I noticed in the Change-Log for your beta version an entry on 2013-03-02 for smfGetBigChartsOptionQuote, yet this function is not in the latest beta version that's available from the work in progress folder. It's possible you are still working out some kinks which is why the latest beta version is dated 2/1/2013. This is the version I am on: Stock Market Functions add-in, Version 2.1.2013.01.04
I'm quite interested in giving this function, smfGetBigChartsOptionQuote a whirl to see if there is a useful way to back test various option strategies.
Many thanks for all the work you've put into this add-in. It is a tremendously useful tool.Sharon
I'm quite interested in giving this function, smfGetBigChartsOpti
Many thanks for all the work you've put into this add-in. It is a tremendously useful tool.Sharon
Fri Mar 29, 2013 1:29 pm (PDT) . Posted by:
"Randy H" rharmelink
I don't automatically update the beta version unless it's a fix of
something. Or has something new that was specifically asked for. I also
haven't written up documentation for the new function yet, or added it
as a data source to smfGetOptionQuotes().
I happened to need to get historical option quotes a while back, and
found out they were available on BigCharts, so I wrote a little
function to grab them. I update the change log when I do changes so that
if people see something there they could use, they can let me know and
I'll do a new release.
And, to tell the truth, I have a concern about even releasing the
function for general use, because each historical date requires a
separate Internet access. The last thing I would want is for people to
retrieve numerous strike prices and dates. My own usage was to get a
single quote at each expiration date, for a single strike price. So I
accessed about a dozen web pages.
But, since you asked, version 2.1.2012.03.29 is now available in the
"Works in Progress" folder.
As far as I can tell, you can only get historical quotes on existing
contracts. It appears to me that if the contract has expired, the
historical data is no longer available.
Function format:
=smfGetBigChartsOptionQuote(equity ticker,C/P,Expiry,Strike,Data
code,[optional Historical Date])
Sample current option quote parameters:
Description Value Equity C/P Expiry Strike Code Ask price
$11.84 SPY C 2014-01-18 150 a Bid price $11.65 SPY C
2014-01-18 150 b $ Change $0.18 SPY C 2014-01-18 150 c
Open Interest 18006 SPY C 2014-01-18 150 i Last price $11.60
SPY C 2014-01-18 150 l Strike price 150 SPY C 2014-01-18
150 s Last price of underlying equity $156.67 SPY C 2014-01-18
150 u Volume 56 SPY C 2014-01-18 150 v Option
expiration date 41657 SPY C 2014-01-18 150 x Option ticker
symbol SPYA18143150000 SPY C 2014-01-18 150 z
Sample historical quote parameters:
Description Value Equity C/P Expiry Strike Code Historical Date
Historical Date Fri, Mar 01, 2013 SPY C 2014-01-18 150 d
2013-03-01 Low price 8.11 SPY C 2014-01-18 150 g 2013-03-01
High Price 8.93 SPY C 2014-01-18 150 h 2013-03-01 Last Price
(i.e. closing) 8.87 SPY C 2014-01-18 150 l 2013-03-01 Open
price 8.28 SPY C 2014-01-18 150 o 2013-03-01 Volume 62 SPY
C 2014-01-18 150 v 2013-03-01 Option ticker symbol SPDR 500
Jan 2014 Call 150.00 SPY C 2014-01-18 150 z 2013-03-01
On Fri, Mar 29, 2013 at 11:13 AM, Sharon McAllister
<sharonnraymc@yahoo.com <mailto:sharonnraymc@yahoo.com > > wrote:
Hi Randy, When will you be updating the latest beta version of the
add-in? I noticed in the Change-Log for your beta version an entry on
2013-03-02 for smfGetBigChartsOptionQuote, yet this function is not in
the latest beta version that's available from the work in progress
folder. It's possible you are still working out some kinks which is why
the latest beta version is dated 2/1/2013. This is the version I am
on: Stock Market Functions add-in, Version 2.1.2013.01.04
I'm quite interested in giving this function,
smfGetBigChartsOptionQuote a whirl to see if there is a useful way to
back test various option strategies.
Many thanks for all the work you've put into this add-in. It is a
tremendously useful tool.Sharon
something. Or has something new that was specifically asked for. I also
haven't written up documentation for the new function yet, or added it
as a data source to smfGetOptionQuotes(
I happened to need to get historical option quotes a while back, and
found out they were available on BigCharts, so I wrote a little
function to grab them. I update the change log when I do changes so that
if people see something there they could use, they can let me know and
I'll do a new release.
And, to tell the truth, I have a concern about even releasing the
function for general use, because each historical date requires a
separate Internet access. The last thing I would want is for people to
retrieve numerous strike prices and dates. My own usage was to get a
single quote at each expiration date, for a single strike price. So I
accessed about a dozen web pages.
But, since you asked, version 2.1.2012.03.
"Works in Progress" folder.
As far as I can tell, you can only get historical quotes on existing
contracts. It appears to me that if the contract has expired, the
historical data is no longer available.
Function format:
=smfGetBigChartsOpt
code,[optional Historical Date])
Sample current option quote parameters:
Description Value Equity C/P Expiry Strike Code Ask price
$11.84 SPY C 2014-01-18 150 a Bid price $11.65 SPY C
2014-01-18 150 b $ Change $0.18 SPY C 2014-01-18 150 c
Open Interest 18006 SPY C 2014-01-18 150 i Last price $11.60
SPY C 2014-01-18 150 l Strike price 150 SPY C 2014-01-18
150 s Last price of underlying equity $156.67 SPY C 2014-01-18
150 u Volume 56 SPY C 2014-01-18 150 v Option
expiration date 41657 SPY C 2014-01-18 150 x Option ticker
symbol SPYA18143150000 SPY C 2014-01-18 150 z
Sample historical quote parameters:
Description Value Equity C/P Expiry Strike Code Historical Date
Historical Date Fri, Mar 01, 2013 SPY C 2014-01-18 150 d
2013-03-01 Low price 8.11 SPY C 2014-01-18 150 g 2013-03-01
High Price 8.93 SPY C 2014-01-18 150 h 2013-03-01 Last Price
(i.e. closing) 8.87 SPY C 2014-01-18 150 l 2013-03-01 Open
price 8.28 SPY C 2014-01-18 150 o 2013-03-01 Volume 62 SPY
C 2014-01-18 150 v 2013-03-01 Option ticker symbol SPDR 500
Jan 2014 Call 150.00 SPY C 2014-01-18 150 z 2013-03-01
On Fri, Mar 29, 2013 at 11:13 AM, Sharon McAllister
<sharonnraymc@
Hi Randy, When will you be updating the latest beta version of the
add-in? I noticed in the Change-Log for your beta version an entry on
2013-03-02 for smfGetBigChartsOpti
the latest beta version that's available from the work in progress
folder. It's possible you are still working out some kinks which is why
the latest beta version is dated 2/1/2013. This is the version I am
on: Stock Market Functions add-in, Version 2.1.2013.01.
I'm quite interested in giving this function,
smfGetBigChartsOpti
back test various option strategies.
Many thanks for all the work you've put into this add-in. It is a
tremendously useful tool.Sharon
Tidak ada komentar:
Posting Komentar