10 New Messages
Digest #2438
Messages
Sun Dec 16, 2012 4:41 am (PST) . Posted by:
"Jason Mak" jasonchmak
Thanks Randy!
On Sun, Dec 16, 2012 at 1:54 AM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> You install it just like you do the SMF add-in -- just point the add-in
> manager to the TA-Lib XLL file.
>
> I even keep it in the same folder as I do all of my SMF add-in files.
>
> On Sat, Dec 15, 2012 at 10:23 AM, Jason <jasonchmak@gmail.com > wrote:
>
>>
>> Thanks a lot for your advice. Are there any difference between download
>> the Free Trial and just download the file you recommemded? I've tried
>> downloaded the free trial and finished the installation process but don't
>> know how to tell Excel (my version is 2007) to use it as add-in though I
>> see "TALibProExcel" is in my "Inactive Application Add-ins" list. I guess
>> I'm just one step away. May I have your advice please?
>>
>
>
>
On Sun, Dec 16, 2012 at 1:54 AM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> You install it just like you do the SMF add-in -- just point the add-in
> manager to the TA-Lib XLL file.
>
> I even keep it in the same folder as I do all of my SMF add-in files.
>
> On Sat, Dec 15, 2012 at 10:23 AM, Jason <jasonchmak@gmail.
>
>>
>> Thanks a lot for your advice. Are there any difference between download
>> the Free Trial and just download the file you recommemded? I've tried
>> downloaded the free trial and finished the installation process but don't
>> know how to tell Excel (my version is 2007) to use it as add-in though I
>> see "TALibProExcel" is in my "Inactive Application Add-ins" list. I guess
>> I'm just one step away. May I have your advice please?
>>
>
>
>
Sun Dec 16, 2012 7:41 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
I sent you 2 word docs that might be of value. Let me know if you get them.
I sent to your email not the group
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Stock Jock
Sent: Sunday, December 16, 2012 12:29 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Indicator Codes: SMF vs. TA-LIB
The TA-LIB indicators are an open source project; so I opened it to see the
indicator code for Excel. Although it appears to be coded in C# the
programming design seems to be similar to yours which I believe is in VBA.
I'm interested in this design strategy which appears to have some other
modules that the actual indicator code relies upon to do the calculation.
I'm trying to find a way to code my indicators in VB and use your code and
the TA-LIB code as examples. Due to the reference to other modules as I
described, this makes it difficult. Could you explain how I can trace how
one of your indicators makes its calculation to better understand how you
did it?
I sent to your email not the group
Kermit
From: smf_addin@yahoogrou
Of Stock Jock
Sent: Sunday, December 16, 2012 12:29 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Indicator Codes: SMF vs. TA-LIB
The TA-LIB indicators are an open source project; so I opened it to see the
indicator code for Excel. Although it appears to be coded in C# the
programming design seems to be similar to yours which I believe is in VBA.
I'm interested in this design strategy which appears to have some other
modules that the actual indicator code relies upon to do the calculation.
I'm trying to find a way to code my indicators in VB and use your code and
the TA-LIB code as examples. Due to the reference to other modules as I
described, this makes it difficult. Could you explain how I can trace how
one of your indicators makes its calculation to better understand how you
did it?
Sun Dec 16, 2012 8:06 am (PST) . Posted by:
"DonaldB" donald_brown_48367
Hi Randy,
I get this this when entering =RCHgetElementNumber("Version")
Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program Files\SMF Add In; 1)
I noticed that if I open a new spreadsheet and hit the edit links I see the "Source Is Open" after hitting the "Check Status" button but if I open a spreadsheet that I copied the downloaded Yahoo market statistics template into it says "OK" instead of "Source Is Open".
Any ideas?
Don
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I agree that the locations appear to match. I guess the question is -- is
> the add-in really location there? What do you get for:
>
> =RCHGetElementNumber("Version")
>
> When I go to "Edit Links" in EXCEL 2007 after opening an add-in workbook, I
> also the the "Unknown" status.. But if I click on "Check Status" or
> "Update", I get a response message of "Source is Open". If I immediately do
> "Edit Links" again, it returns to "Unknown" until I do a "Check Status" or
> "Update" again.
>
> On Sun, Dec 9, 2012 at 2:21 PM, DonaldB <donald_brown_48367@...>wrote:
>
> >
> > First Thanks for all your hard work. You developed a great set of tools
> > for investors.
> >
> > I am having a problem getting the smf to work for downloading the Yahoo
> > market statistics data (see SMF Photo 1 in the group Files>Misc section) -
> > just getting the #NAME? error. I've read the location error in the links
> > section and the cells appear to be looking for the add-in in the correct
> > location on my computer but when I check the edit link function it says
> > status "Unknown" (see SMF Photo 2). If I hit the "update" or "check
> > status", it says status "OK" (see SMF Photo 3) but closing the dialogue box
> > and reopening it the status changes to "Unknown" again.
> >
> > I'm using Excel 2007 and Windows 7.
> >
>
I get this this when entering =RCHgetElementNumbe
Stock Market Functions add-in, Version 2.1.2012.02.
I noticed that if I open a new spreadsheet and hit the edit links I see the "Source Is Open" after hitting the "Check Status" button but if I open a spreadsheet that I copied the downloaded Yahoo market statistics template into it says "OK" instead of "Source Is Open".
Any ideas?
Don
--- In smf_addin@yahoogrou
>
> I agree that the locations appear to match. I guess the question is -- is
> the add-in really location there? What do you get for:
>
> =RCHGetElementNumbe
>
> When I go to "Edit Links" in EXCEL 2007 after opening an add-in workbook, I
> also the the "Unknown" status.. But if I click on "Check Status" or
> "Update", I get a response message of "Source is Open". If I immediately do
> "Edit Links" again, it returns to "Unknown" until I do a "Check Status" or
> "Update" again.
>
> On Sun, Dec 9, 2012 at 2:21 PM, DonaldB <donald_brown_
>
> >
> > First Thanks for all your hard work. You developed a great set of tools
> > for investors.
> >
> > I am having a problem getting the smf to work for downloading the Yahoo
> > market statistics data (see SMF Photo 1 in the group Files>Misc section) -
> > just getting the #NAME? error. I've read the location error in the links
> > section and the cells appear to be looking for the add-in in the correct
> > location on my computer but when I check the edit link function it says
> > status "Unknown" (see SMF Photo 2). If I hit the "update" or "check
> > status", it says status "OK" (see SMF Photo 3) but closing the dialogue box
> > and reopening it the status changes to "Unknown" again.
> >
> > I'm using Excel 2007 and Windows 7.
> >
>
Sun Dec 16, 2012 8:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
According to the results of the version formula you give me below, the
add-in is located in location "C:\Program Files\SMF Add In", but all of the
images you uploaded says "Edit Links" believes it to be in a different
location. The file must have been saved when you had the add-in located in
that different location.
That's why you are getting the #NAME? errors, and why the LINKS area item
on location errors suggests you manually fix the location errors. As I
mentioned there, I've had issues with trying to fix location errors using
EXCEL's "Edit Links" process. So I no longer use it.
On Sun, Dec 16, 2012 at 9:06 AM, DonaldB <donald_brown_48367@yahoo.com >wrote:
>
> I get this this when entering =RCHgetElementNumber("Version")
> Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program
> Files\SMF Add In; 1)
>
> I noticed that if I open a new spreadsheet and hit the edit links I see
> the "Source Is Open" after hitting the "Check Status" button but if I open
> a spreadsheet that I copied the downloaded Yahoo market statistics template
> into it says "OK" instead of "Source Is Open".
>
> Any ideas?
>
add-in is located in location "C:\Program Files\SMF Add In", but all of the
images you uploaded says "Edit Links" believes it to be in a different
location. The file must have been saved when you had the add-in located in
that different location.
That's why you are getting the #NAME? errors, and why the LINKS area item
on location errors suggests you manually fix the location errors. As I
mentioned there, I've had issues with trying to fix location errors using
EXCEL's "Edit Links" process. So I no longer use it.
On Sun, Dec 16, 2012 at 9:06 AM, DonaldB <donald_brown_
>
> I get this this when entering =RCHgetElementNumbe
> Stock Market Functions add-in, Version 2.1.2012.02.
> Files\SMF Add In; 1)
>
> I noticed that if I open a new spreadsheet and hit the edit links I see
> the "Source Is Open" after hitting the "Check Status" button but if I open
> a spreadsheet that I copied the downloaded Yahoo market statistics template
> into it says "OK" instead of "Source Is Open".
>
> Any ideas?
>
Sun Dec 16, 2012 9:54 am (PST) . Posted by:
"DonaldB" donald_brown_48367
Ah, Thanks Randy. I went in using the edit links and changed it to the program files/SMF Add In location and it worked. Thanks for your help.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> According to the results of the version formula you give me below, the
> add-in is located in location "C:\Program Files\SMF Add In", but all of the
> images you uploaded says "Edit Links" believes it to be in a different
> location. The file must have been saved when you had the add-in located in
> that different location.
>
> That's why you are getting the #NAME? errors, and why the LINKS area item
> on location errors suggests you manually fix the location errors. As I
> mentioned there, I've had issues with trying to fix location errors using
> EXCEL's "Edit Links" process. So I no longer use it.
>
> On Sun, Dec 16, 2012 at 9:06 AM, DonaldB <donald_brown_48367@...>wrote:
>
> >
> > I get this this when entering =RCHgetElementNumber("Version")
> > Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program
> > Files\SMF Add In; 1)
> >
> > I noticed that if I open a new spreadsheet and hit the edit links I see
> > the "Source Is Open" after hitting the "Check Status" button but if I open
> > a spreadsheet that I copied the downloaded Yahoo market statistics template
> > into it says "OK" instead of "Source Is Open".
> >
> > Any ideas?
> >
>
--- In smf_addin@yahoogrou
>
> According to the results of the version formula you give me below, the
> add-in is located in location "C:\Program Files\SMF Add In", but all of the
> images you uploaded says "Edit Links" believes it to be in a different
> location. The file must have been saved when you had the add-in located in
> that different location.
>
> That's why you are getting the #NAME? errors, and why the LINKS area item
> on location errors suggests you manually fix the location errors. As I
> mentioned there, I've had issues with trying to fix location errors using
> EXCEL's "Edit Links" process. So I no longer use it.
>
> On Sun, Dec 16, 2012 at 9:06 AM, DonaldB <donald_brown_
>
> >
> > I get this this when entering =RCHgetElementNumbe
> > Stock Market Functions add-in, Version 2.1.2012.02.
> > Files\SMF Add In; 1)
> >
> > I noticed that if I open a new spreadsheet and hit the edit links I see
> > the "Source Is Open" after hitting the "Check Status" button but if I open
> > a spreadsheet that I copied the downloaded Yahoo market statistics template
> > into it says "OK" instead of "Source Is Open".
> >
> > Any ideas?
> >
>
Sun Dec 16, 2012 8:43 am (PST) . Posted by:
"Ron Spruell" hashky
Randy -
The Java Script hosed your http link.
I quit programing in 1964 when Fortran 4 replaced Fortran 2. So, how about breaking this down so I might be able to see if it works better than the old method that you showed me in the Puts-2.00.xls in the files folder? (The Expiry Dates is calculated at the top of the page.)
Files -> Uploads by Forum Members -> Puts-2.00.xls
http://tinyurl.com/ckmjx8z
Ron Spruell
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Sunday, December 16, 2012 4:05 AM
>Subject: Re: [smf_addin] Option chains Downloader, multiple stocks at once
>
>
>
>You'd just download each stock in the list, as needed.
>
>I just programmed a new function using the Yahoo API data feeds. They have one data feed where you can get all strikes and all expirations for a single ticker symbol:
>
>"http://query.yahooapis.com/v1/public/yql?q=SELECT%20*%20FROM%20yahoo.finance.options%20WHERE%20symbol=%22~~~~~%22%20AND%20expiration%20in%20%28SELECT%20contract%20FROM%20yahoo.finance.option_contracts%20WHERE%20symbol=%22~~~~~%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env "
>
>Just subsitute your ticker symbol where I am using "~~~~~".
>
>In my case, I am using just this add-in subroutine to extract each data item:
>
>=smfConvertData(smfGetTagContent(sURL, pItem & ">", 1, pOptionSymbol))
>
>...where sURL is the URL above, pOptionSymbol is the Yahoo option symbol, and pItem is one of these:
>
>StrikePrice
>LastPrice
>Change
>Bid
>Ask
>Vol
>OpenInt
>StrikePrice
>LastPrice
>Change
>Bid
>Ask
>Vol
>OpenInt
>
>The result is an XML file, so you could extract everything yourself any way you want.
>
>
>On Sun, Dec 16, 2012 at 2:04 AM, amg11901 <amg11901@gmail.com > wrote:
>
>I was wondering if is possible to download all expirations option chains from a list of stocks? If you google it you can download option chain for specific stock but not for a list. Can anyone of you can help me please?
>>
>
>
>
>
The Java Script hosed your http link.
I quit programing in 1964 when Fortran 4 replaced Fortran 2. So, how about breaking this down so I might be able to see if it works better than the old method that you showed me in the Puts-2.00.xls in the files folder? (The Expiry Dates is calculated at the top of the page.)
Files -> Uploads by Forum Members -> Puts-2.00.xls
http://tinyurl.
Ron Spruell
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Sunday, December 16, 2012 4:05 AM
>Subject: Re: [smf_addin] Option chains Downloader, multiple stocks at once
>
>
>
>You'd just download each stock in the list, as needed.
>
>I just programmed a new function using the Yahoo API data feeds. They have one data feed where you can get all strikes and all expirations for a single ticker symbol:
>
>"http://query.
>
>Just subsitute your ticker symbol where I am using "~~~~~".
>
>In my case, I am using just this add-in subroutine to extract each data item:
>
>=smfConvertData(
>
>...where sURL is the URL above, pOptionSymbol is the Yahoo option symbol, and pItem is one of these:
>
>StrikePrice
>LastPrice
>Change
>Bid
>Ask
>Vol
>OpenInt
>StrikePrice
>LastPrice
>Change
>Bid
>Ask
>Vol
>OpenInt
>
>The result is an XML file, so you could extract everything yourself any way you want.
>
>
>On Sun, Dec 16, 2012 at 2:04 AM, amg11901 <amg11901@gmail.
>
>I was wondering if is possible to download all expirations option chains from a list of stocks? If you google it you can download option chain for specific stock but not for a list. Can anyone of you can help me please?
>>
>
>
>
>
Sun Dec 16, 2012 9:16 am (PST) . Posted by:
"Randy H" rharmelink
On Sun, Dec 16, 2012 at 9:43 AM, Ron Spruell <hashky@yahoo.
>
> The Java Script hosed your http link.
The links looked fine to me. I used both the link you repeated in your message, and the one posted in the Yahoo group. Both work for me.
HOWEVER, as I noted, you do need to replace the two occurrences of "~~~~~" with the stock ticker symbol. For example, here's the link using ticker symbol MO:
http://query.
This is what the XML entry looks like for a single option:
<option symbol="MO121222C00
<strikePrice>
<lastPrice>15.
<change>0</change>
<changeDir/>
<bid>16.05</
<ask>16.35</
<vol>11</vol>
<openInt>8</
</option>
...which is why I was using the smfGetTagContent(
The advantage of this API for Yahoo is that it gets all the options for all the expirations, in a single Internet access.
Sun Dec 16, 2012 9:35 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You could upgrade to the functions mentioned in item 2.2 in the LINKS area
of the group. I think they would be more reliable. But if what you have
works for you, it may not be worth converting.
On Sun, Dec 16, 2012 at 9:43 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> I quit programing in 1964 when Fortran 4 replaced Fortran 2. So, how
> about breaking this down so I might be able to see if it works better than
> the old method that you showed me in the Puts-2.00.xls in the files
> folder? (The Expiry Dates is calculated at the top of the page.)
>
> Files -> Uploads by Forum Members -> Puts-2.00.xls
>
> http://tinyurl.com/ckmjx8z
>
of the group. I think they would be more reliable. But if what you have
works for you, it may not be worth converting.
On Sun, Dec 16, 2012 at 9:43 AM, Ron Spruell <hashky@yahoo.
>
> I quit programing in 1964 when Fortran 4 replaced Fortran 2. So, how
> about breaking this down so I might be able to see if it works better than
> the old method that you showed me in the Puts-2.00.xls in the files
> folder? (The Expiry Dates is calculated at the top of the page.)
>
> Files -> Uploads by Forum Members -> Puts-2.00.xls
>
> http://tinyurl.
>
Sun Dec 16, 2012 2:20 pm (PST) . Posted by:
"Ron Spruell" hashky
It turned out to be easy to convert the dates per smfGetOptionExpirations() function.
Thanks.
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Sunday, December 16, 2012 11:35 AM
>Subject: Re: [smf_addin] Option chains Downloader, multiple stocks at once
>
>
>
>You could upgrade to the functions mentioned in item 2.2 in the LINKS area of the group. I think they would be more reliable. But if what you have works for you, it may not be worth converting.
>
>
>On Sun, Dec 16, 2012 at 9:43 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>I quit programing in 1964 when Fortran 4 replaced Fortran 2. So, how about breaking this down so I might be able to see if it works better than the old method that you showed me in the Puts-2.00.xls in the files folder? (The Expiry Dates is calculated at the top of the page.)
>>
>>Files -> Uploads by Forum Members -> Puts-2.00.xls
>>
>>
>>http://tinyurl.com/ckmjx8z
>>
>
>
>
>
Thanks.
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Sunday, December 16, 2012 11:35 AM
>Subject: Re: [smf_addin] Option chains Downloader, multiple stocks at once
>
>
>
>You could upgrade to the functions mentioned in item 2.2 in the LINKS area of the group. I think they would be more reliable. But if what you have works for you, it may not be worth converting.
>
>
>On Sun, Dec 16, 2012 at 9:43 AM, Ron Spruell <hashky@yahoo.
>
>
>>
>>I quit programing in 1964 when Fortran 4 replaced Fortran 2. So, how about breaking this down so I might be able to see if it works better than the old method that you showed me in the Puts-2.00.xls in the files folder? (The Expiry Dates is calculated at the top of the page.)
>>
>>Files -> Uploads by Forum Members -> Puts-2.00.xls
>>
>>
>>http://tinyurl.
>>
>
>
>
>
Mon Dec 17, 2012 2:06 am (PST) . Posted by:
"Jason" jasonchmak
Hi Randy,
I want to get the unadjusted (closing) price on a certain date but the smfPricesByDates() function can only give me the adjusted close. I've tried to use the smfPricesBetween() function instead by can also get the adjusted close only. Is there any convenient way to get the unadjusted closing price using your functions?
Jason
I want to get the unadjusted (closing) price on a certain date but the smfPricesByDates(
Jason
Tidak ada komentar:
Posting Komentar