Messages In This Digest (10 Messages)

1a.: Re: Thanks From: almondtree
1b.: Re: Thanks From: almondtree
1c.: Re: Thanks From: Randy Harmelink
1d.: Re: Thanks From: almondtree

2a.: trying to get stock opion from barchart.com From: David
2b.: Re: trying to get stock opion from barchart.com From: Randy Harmelink
2c.: Re: trying to get stock opion from barchart.com From: John Zman

3a.: Gummy Bears CD From: almondtree
3b.: Re: Gummy Bears CD From: Randy Harmelink
3c.: Re: Gummy Bears CD From: almondtree

View All Topics | Create New Topic

Messages

1a.: Re: Thanks

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

Sat Nov 12, 2011 9:25 am (PST)

Thanks, but I do have a question In Windows 7 pro there is two files named PROGRAM FILES: C:\Program Files and C:\Program Files (x86) does it matter where the SMF addin is placed.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It can be frustrating on some days, but I always try to put it into
> perspective by imagining the person asking questions is probably feeling a
> lot more frustrated than I am... :)
>
> On Fri, Nov 11, 2011 at 8:53 AM, Jean <jeanmousnier@...> wrote:
>
> > I really do not have a question, just wanted to thank you for all of your
> > hard work and making available to everyone.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
1b.: Re: Thanks

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

Sat Nov 12, 2011 9:45 am (PST)

Wow! I to am interested in Graham #, have you fiqured out a way to get Reuters' total Assets,Total Liabilities and Common Shares.

--- In smf_addin@yahoogroups.com, "moosazahiruddin" <moosazahiruddin@...> wrote:
>
> Hi Randy & all,
>
> I have downloaded the add-in just in order to view a spreadsheet based on Graham's formula. I find the add-in very useful and interesting, so I joined this group. Thanks Randy for the wonderful work. Thanks to other members who have done some useful reviews and helped to revise the functions so far.
>
> I am mostly interested in Indian Stock Market. I would like to ask members from India, which site is better to use viz. Yahoo or Reuters? Is it possible to get data from Moneycontrol, Religare or SBICapsec?
>
> Regards,
>
> Zahiruddin
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
1c.: Re: Thanks

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

Sat Nov 12, 2011 10:00 am (PST)

You'll have the most compatibility with C:\Program Files. The location
really only matters when files are shared between different people, because
EXCEL stores a hard-coded link location to the add-in whenever a workbook
is saved. If the opener of the workbook has the add-in in a different
location, EXCEL will not resolve the links automatically, and they need to
be resolved manually.

On Sat, Nov 12, 2011 at 10:25 AM, almondtree <almondtree@yahoo.com> wrote:

> Thanks, but I do have a question In Windows 7 pro there is two files named
> PROGRAM FILES: C:\Program Files and C:\Program Files (x86) does it matter
> where the SMF addin is placed.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
1d.: Re: Thanks

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

Sat Nov 12, 2011 6:07 pm (PST)

I am glad you answer this question, because I think it will help others that are have the same problem with Excel 2010, I deleted everything by putting SMF add-in it Program Files instead of Program Files (x86)it now works so far.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You'll have the most compatibility with C:\Program Files. The location
> really only matters when files are shared between different people, because
> EXCEL stores a hard-coded link location to the add-in whenever a workbook
> is saved. If the opener of the workbook has the add-in in a different
> location, EXCEL will not resolve the links automatically, and they need to
> be resolved manually.
>
> On Sat, Nov 12, 2011 at 10:25 AM, almondtree <almondtree@...> wrote:
>
> > Thanks, but I do have a question In Windows 7 pro there is two files named
> > PROGRAM FILES: C:\Program Files and C:\Program Files (x86) does it matter
> > where the SMF addin is placed.
> >
>

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

2a.: trying to get stock opion from barchart.com

Posted by: "David" nicholasdavid@comcast.net dnicholas4967

Sat Nov 12, 2011 3:40 pm (PST)

=RCHGetTableCell(http://www.barchart.com/quotes/stocks/ticker108,2,"bar chart opinion")

barchart.com gives buy/sell/hold opinion on this site.
I'm searching for the correct syntax and am at a loss. Please help. tks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2b.: Re: trying to get stock opion from barchart.com

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

Sat Nov 12, 2011 4:42 pm (PST)

The URL you have below is not a valid one. I think you want something like:

=RCHGetTableCell("http://www.barchart.com/quotes/stocks/MMM
",0,"background-color")

However, you may want to take a look at this template, which has more of
the buy/sell information:

RCHGetTableCell-Template-BarChart-Technical-Signals.xls

On Sat, Nov 12, 2011 at 4:40 PM, David <nicholasdavid@comcast.net> wrote:

> =RCHGetTableCell(http://www.barchart.com/quotes/stocks/ticker108,2,"bar
> chart opinion")
>
> barchart.com gives buy/sell/hold opinion on this site.
> I'm searching for the correct syntax and am at a loss.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2c.: Re: trying to get stock opion from barchart.com

Posted by: "John Zman" john.zman@yahoo.com john.zman

Sun Nov 13, 2011 2:00 am (PST)

I took a look at this site and they use non-standard option symbols. I think you could figure it out and create the symbol by concatenating the stock symbol with the option type and expiration and strike as they do.

--- On Sat, 11/12/11, David <nicholasdavid@comcast.net> wrote:

From: David <nicholasdavid@comcast.net>
Subject: [smf_addin] trying to get stock opion from barchart.com
To: smf_addin@yahoogroups.com
Date: Saturday, November 12, 2011, 11:40 PM

=RCHGetTableCell(http://www.barchart.com/quotes/stocks/ticker108,2,"bar chart opinion")

barchart.com gives buy/sell/hold opinion on this site.

I'm searching for the correct syntax and am at a loss. Please help. tks

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

3a.: Gummy Bears CD

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

Sat Nov 12, 2011 6:13 pm (PST)

Have you seen any of P.Pooze spreadsheets?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3b.: Re: Gummy Bears CD

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

Sat Nov 12, 2011 6:44 pm (PST)

You mean the "Gummy Stuff" website?

http://www.financialwebring.org/gummy-stuff/gummy_stuff.htm

What about 'em?

On Sat, Nov 12, 2011 at 7:13 PM, almondtree <almondtree@yahoo.com> wrote:

> Have you seen any of P.Pooze spreadsheets?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.: Re: Gummy Bears CD

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

Sun Nov 13, 2011 12:01 am (PST)

Well I read in some of the earlier posts someone wanted a way to sort and each ticker have its own spreadsheet gummy has one named yahoo-richard.xls maybe some of the macros could work in your xls'

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You mean the "Gummy Stuff" website?
>
> http://www.financialwebring.org/gummy-stuff/gummy_stuff.htm
>
> What about 'em?
>
> On Sat, Nov 12, 2011 at 7:13 PM, almondtree <almondtree@...> wrote:
>
> > Have you seen any of P.Pooze spreadsheets?
> >
>

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

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

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

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

EXCEL FEED

Minggu, 13 November 2011

[smf_addin] Digest Number 2014

Messages In This Digest (10 Messages)

Messages

Re: Thanks

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

Sat Nov 12, 2011 9:25 am (PST)

Re: Thanks

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

Sat Nov 12, 2011 9:45 am (PST)

Re: Thanks

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

Sat Nov 12, 2011 10:00 am (PST)

Re: Thanks

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

Sat Nov 12, 2011 6:07 pm (PST)

trying to get stock opion from barchart.com

Posted by: "David" nicholasdavid@comcast.net dnicholas4967

Sat Nov 12, 2011 3:40 pm (PST)

Re: trying to get stock opion from barchart.com

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

Sat Nov 12, 2011 4:42 pm (PST)

Re: trying to get stock opion from barchart.com

Posted by: "John Zman" john.zman@yahoo.com john.zman

Sun Nov 13, 2011 2:00 am (PST)

Gummy Bears CD

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

Sat Nov 12, 2011 6:13 pm (PST)

Re: Gummy Bears CD

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

Sat Nov 12, 2011 6:44 pm (PST)

Re: Gummy Bears CD

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

Sun Nov 13, 2011 12:01 am (PST)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me