Minggu, 16 Desember 2012

[smf_addin] Digest Number 2437

14 New Messages

Digest #2437
1a
1b
3a
Re: Channels by "Jason" jasonchmak
3b
Re: Channels by "Randy Harmelink" rharmelink
4a
ADVFN Company financial information by "Jacob Jose" pepecan47
4b
Re: ADVFN Company financial information by "Randy Harmelink" rharmelink
5a
Indicator Codes: SMF vs. TA-LIB by "Stock Jock" stockjocktrader
5b
Re: Indicator Codes: SMF vs. TA-LIB by "Randy Harmelink" rharmelink

Messages

Sat Dec 15, 2012 4:46 am (PST) . Posted by:

"Ron Spruell" hashky

My brain and my fingers must not be synchronized, my typos are terrible.

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

It appears that any type of virtual machine that allows Windows to run "normally" will run Excel with the Add-In.  Note that you do have to have a Windows operating system and Microsoft Excel to run in the virtual machine.  Virtual Box is an open source, cross platform program that runs on Windows, MAC or Linux.  Parallels is a commercial program that runs on several platforms including MAC.

Boot Camp is a dual boot for a MAC (I think).

Ron Spruell

>________________________________
> From: randc_1yh <randcinv@infowest.com>
>To: smf_addin@yahoogroups.com
>Sent: Saturday, December 15, 2012 12:52 AM
>Subject: [smf_addin] Re: Any success using this on a Mac?
>
>
> 
>I have been running a number of Windows-only programs on my Mac for years, including a macro suite for Excel that imports historic and real time stock data. I use Fusion software by VM Ware to create a virtual PC on my Mac, which will run any version of Windows software (I am still using XP) and most Windows software. My Windows programs (Microsoft Office mainly) actually run faster on my MacBook Pro than on my Windows PC. I haven't yet tried this particular addin however, but will be doing that very soon.
>
>--- In smf_addin@yahoogroups.com, Ron Spruell <hashky@...> wrote:
>>
>> I doubt it.  With both VirtualBox and Prallels, you have to have Windows.
>>
>>
>>
>>
>>
>> >________________________________
>> > From: james morlock <JimMorlock@...>
>> >To: smf_addin@yahoogroups.com
>> >Sent: Friday, December 14, 2012 8:44 AM
>> >Subject: Re: [smf_addin] Any success using this on a Mac?
>> >
>> >
>> > 
>> > If these products work on a Mac does that also mean they are likely to run on an iPad?  I have avoided Mac products because most investing software is Windows based.
>> >
>> >Jim
>> >
>> >
>> >On Fri, Dec 14, 2012 at 8:22 AM, Ron Spruell wrote:
>> >
>> >   Search through the messages.  I think there has be success with Parallels and VirtualBox.
>> >
>> >Ron Spruell
>> >
>> >
>> >
>> >___________________________________
>> >
>> >From: peterson8484 <peterson8484@...>
>> >To: smf_addin@yahoogroups.com
>> >Sent: Tuesday, December 11, 2012 10:27 AM
>> >Subject: [smf_addin] Any success using this on a Mac?
>> >
>> >  I'm switching from a PC to a Mac and before I resort to a solution that will run Windows on my Mac I wanted to check:
>> >
>> >Has anyone found a way to successfully use this add-in on a Mac?
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>
>
>
>
>

Sat Dec 15, 2012 8:38 am (PST) . Posted by:

"randc_1yh" randc_1yh

Hi Ron,

You are correct, Boot Camp on the Mac is a hard boot into "Windows" mode only. The beauty of VMWare Fusion is that it creates a fully-functional virtual Windows PC, in a window on the Mac. So your Mac still boots and operates as normal, and you can simply click in or out of the virtual PC at any time.

Because it is a virtual PC, you can load any operating system you want (Windows, Linux, etc.), or you can have multiple virtual PC's with different operating systems on each one.

(I'm not affiliatted with VMWare, just been very happy using their product to run Windows programs that are not otherwise available on my Mac.)

Randy C

--- In smf_addin@yahoogroups.com, Ron Spruell <hashky@...> wrote:
>
> My brain and my fingers must not be synchronized, my typos are terrible.
>
> http://finance.groups.yahoo.com/group/smf_addin/message/6861
>
> It appears that any type of virtual machine that allows Windows to run "normally" will run Excel with the Add-In.  Note that you do have to have a Windows operating system and Microsoft Excel to run in the virtual machine.  Virtual Box is an open source, cross platform program that runs on Windows, MAC or Linux.  Parallels is a commercial program that runs on several platforms including MAC.
>
> Boot Camp is a dual boot for a MAC (I think).
>
> Ron Spruell
>
>
>
>
>
>
>
> >________________________________
> > From: randc_1yh <randcinv@...>
> >To: smf_addin@yahoogroups.com
> >Sent: Saturday, December 15, 2012 12:52 AM
> >Subject: [smf_addin] Re: Any success using this on a Mac?
> >
> >
> > 
> >I have been running a number of Windows-only programs on my Mac for years, including a macro suite for Excel that imports historic and real time stock data. I use Fusion software by VM Ware to create a virtual PC on my Mac, which will run any version of Windows software (I am still using XP) and most Windows software. My Windows programs (Microsoft Office mainly) actually run faster on my MacBook Pro than on my Windows PC. I haven't yet tried this particular addin however, but will be doing that very soon.
> >
> >--- In smf_addin@yahoogroups.com, Ron Spruell <hashky@> wrote:
> >>
> >> I doubt it.  With both VirtualBox and Prallels, you have to have Windows.
> >>
> >>
> >>
> >>
> >>
> >> >________________________________
> >> > From: james morlock <JimMorlock@>
> >> >To: smf_addin@yahoogroups.com
> >> >Sent: Friday, December 14, 2012 8:44 AM
> >> >Subject: Re: [smf_addin] Any success using this on a Mac?
> >> >
> >> >
> >> > 
> >> > If these products work on a Mac does that also mean they are likely to run on an iPad?  I have avoided Mac products because most investing software is Windows based.
> >> >
> >> >Jim
> >> >
> >> >
> >> >On Fri, Dec 14, 2012 at 8:22 AM, Ron Spruell wrote:
> >> >
> >> >   Search through the messages.  I think there has be success with Parallels and VirtualBox.
> >> >
> >> >Ron Spruell
> >> >
> >> >
> >> >
> >> >___________________________________
> >> >
> >> >From: peterson8484 <peterson8484@>
> >> >To: smf_addin@yahoogroups.com
> >> >Sent: Tuesday, December 11, 2012 10:27 AM
> >> >Subject: [smf_addin] Any success using this on a Mac?
> >> >
> >> >  I'm switching from a PC to a Mac and before I resort to a solution that will run Windows on my Mac I wanted to check:
> >> >
> >> >Has anyone found a way to successfully use this add-in on a Mac?
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >
> >
> >
> >
> >
>

Sat Dec 15, 2012 7:09 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Randy, the update file on timed functions does not appear to work for me. As
far as I know I have the latest SMF Addin files
Is there something I needed to do to activate the timed function? It counts
down so it appears to go through the loop.

I add the version in cell B1 to show I have the latest.


Here are my SMF-addin files and the dates


Sat Dec 15, 2012 7:20 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The #NAME? results are because of location errors. You'll need to fix those
unresolved link errors in EXCEL before it can work. See the LINKS area of
the group of info on that topic.

On Sat, Dec 15, 2012 at 8:09 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> Randy, the update file on timed functions does not appear to work for me.
> As far as I know I have the latest SMF Addin files****
>
> Is there something I needed to do to activate the timed function? It
> counts down so it appears to go through the loop. ****
>
> ** **
>
> I add the version in cell B1 to show I have the latest.****
>
> ** **
>
> ****
>
> ** **
>
> ** **
>
>

Sat Dec 15, 2012 7:35 am (PST) . Posted by:

"Ron Spruell" hashky

Runs for me.

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Saturday, December 15, 2012 9:20 AM
>Subject: Re: [smf_addin] Sample Timed function does not appear to work on my excel.
>
>
> 
>The #NAME? results are because of location errors. You'll need to fix those unresolved link errors in EXCEL before it can work. See the LINKS area of the group of info on that topic.
>
>
>On Sat, Dec 15, 2012 at 8:09 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
>
>
>>
>>Randy, the update file on timed functions does not appear to work for me. As far as I know I have the latest SMF Addin files
>>Is there something I needed to do to activate the timed function? It counts down so it appears to go through the loop.
>> 
>>I add the version in cell B1 to show I have the latest.
>> 
>> 
>> 
>>
>
>
>
>

Sat Dec 15, 2012 8:19 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Damn, you are good

Works like a charm, now

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Saturday, December 15, 2012 10:21 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Sample Timed function does not appear to work on my excel.


The #NAME? results are because of location errors. You'll need to fix those unresolved link errors in EXCEL before it can work. See the LINKS area of the group of info on that topic.
On Sat, Dec 15, 2012 at 8:09 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:

Randy, the update file on timed functions does not appear to work for me. As far as I know I have the latest SMF Addin files
Is there something I needed to do to activate the timed function? It counts down so it appears to go through the loop.

I add the version in cell B1 to show I have the latest.


Sat Dec 15, 2012 9:50 am (PST) . Posted by:

"Jason" jasonchmak

Hi Randy,

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?

Jason

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I think incorrect predictions are something you almost have to live with on
> something like that. But there are a number of TA functions that check for
> oscillations and trends. You can check to see if any of them help.
>
> A free technical analysis add-in is here:
>
> http://ta-lib.org
>
> You want this file:
>
> ta-lib-0.4.0-msvc.zip
>
> Just look in the ZIP archive for the "ta-lib.xll" (or "ta-lib-reverse.xll")
> file, extract it, and tell EXCEL to use it as an add-in.
>
> On Thu, Jan 12, 2012 at 10:02 AM, ehstats <ericstats@...> wrote:
>
> > I just joined this group for another reason than this question.
> >
> > I'm interested in have an excel program identify when we are in a sideways
> > channel for the S&P 500. I have an investment program that invests in the
> > S&P 500. The program identifies trends, but it gets whipsawed in sideways
> > trading patterns. I want to have it go to cash when the excel program
> > identifies that we are in that sideways channel.
> >
>

Sat Dec 15, 2012 9:54 am (PST) . Posted by:

"Randy Harmelink" rharmelink

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?
>

Sat Dec 15, 2012 8:57 pm (PST) . Posted by:

"Jacob Jose" pepecan47

Is it possible to extract data from this page?
 
http://ca.advfn.com/p.php?pid=financials&symbol=NYSE%3AMCD

I am particulary interested in 

5-Y Average P/E Ratio

Regards,
Jose L. Jacob

Sun Dec 16, 2012 1:44 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Sure. For example:

=RCHGetTableCell("http://ca.advfn.com/p.php?pid=financials&symbol=NYSE%3AMCD",1,">Price/Book
Ratio")

On Sat, Dec 15, 2012 at 9:57 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> Is it possible to extract data from this page?
>
> http://ca.advfn.com/p.php?pid=financials&symbol=NYSE%3AMCD
>
> I am particulary interested in
>
> 5-Y Average P/E Ratio
>
>

Sat Dec 15, 2012 9:29 pm (PST) . Posted by:

"Stock Jock" stockjocktrader


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 1:55 am (PST) . Posted by:

"Randy Harmelink" rharmelink

For SMFTech(), I just have parameters passed to the function, including
the n-row by 6-column array of historical quotes. I don't see any
references to other modules in the function -- it just uses those
parameters passed to it.

The constant "kD" is set to 1, which I can use to refer to the 1st column
of those 6, and is the column that contains the dates. The constant "kC" is
set to 5, which I can use to refer to the 5th column of those 6, and is the
column that contains the closing prices. And so forth...

I primarily used the StockCharts documentation when I programmed the
indicators, both as a guide to programming, and as a way to double-check my
results.

On Sat, Dec 15, 2012 at 10:29 PM, Stock Jock <stockjocktrader@yahoo.com>wrote:

> 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 1:41 am (PST) . Posted by:

"amg11901" amg11901

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 2:05 am (PST) . Posted by:

"Randy Harmelink" rharmelink

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?
>
Diposting oleh EXCEL FEED LEARNING di 03.39

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)