Kamis, 28 Juli 2011

[smf_addin] Digest Number 1900

Messages In This Digest (21 Messages)

Messages

1a.

Re: Help!VBA! trying to create a formula that wit "RCHGetElementNumb

Posted by: "Me Bellsouth" fullerdj@bellsouth.net   fullerdj18

Wed Jul 27, 2011 6:41 am (PDT)



Randy
How can I get my email off
This thread
Thanks
David

Sent from my iPhone5 - an extremely cool and tremendously expensive device which you probably could not afford even
if you could find one.
The content of this message is so privileged, confidential and important that is very likely that you received thus message accidentally, by subterfuge or by using mood ring technology. If this is the case you must immediately delete all memory of whatever infernal device you used to intercept my message. On the other hand, if you believe any part of this message, or have no capacity to recognize humor, please let me know immediately! I've always wondered who read all this stuff at the end of a email and I would really like to meet one of the people from your planet. I won't make fun of you...I promise.
Unless you are really weird.

On Jul 26, 2011, at 10:48 PM, Randy Harmelink <rharmelink@gmail.com> wrote:

> Check the "Links" area of the group for a link to a message on using add-in functions in VBA.
>
> Also, check out the links related to smfUpdateDownloadTable. There's already a macro that more or less does the looping for you automatically.
>
> Also note that typically "Ticker" is a defined worksheet cell name. You can't use it like you're doing below. You need to access it through the Range() function of VBA.
>
>
> On Tue, Jul 26, 2011 at 7:24 PM, Ilya R <ilya559@yahoo.com> wrote:
>
> I want to create a VBA with an array and a loop that would input "=RCHGetElementNumber(Ticker, 5565)" into different cells.
>
> I have the following code
> -----------------------------------------
> Sub ilya49()
> Dim colNum As Long, rowNum As Long, rch As String
> rch = "=RCHGetElementNumber(Ticker, "
>
>
> colNum = 2
> For nm = 5565 To 5556 Step -1
> colNum = colNum + 2
> Sheets(1).Cells(24, colNum).Value = rch & nm
> Next nm
> End Sub
> ------------------------------------------
>
> However, when I run it, it gives me an error "Run-time error '1004': Application-defined or object-defined error"
>
> the reason for that is because rch = "=RCHGetElementNumber(Ticker, "
>
> Is there any way to solve it or work around it???
> Please Help!!!!!
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1b.

Re: Help!VBA! trying to create a formula that wit "RCHGetElementNumb

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Wed Jul 27, 2011 8:51 am (PDT)



At the bottom of every email there is an unsubscribe just click on it.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Me Bellsouth
Sent: Wednesday, July 27, 2011 9:41 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Help!VBA! trying to create a formula that wit "RCHGetElementNumber" but CONFLICT


Randy
How can I get my email off
This thread
Thanks
David

Sent from my iPhone5 - an extremely cool and tremendously expensive device which you probably could not afford even
if you could find one.
The content of this message is so privileged, confidential and important that is very likely that you received thus message accidentally, by subterfuge or by using mood ring technology. If this is the case you must immediately delete all memory of whatever infernal device you used to intercept my message. On the other hand, if you believe any part of this message, or have no capacity to recognize humor, please let me know immediately! I've always wondered who read all this stuff at the end of a email and I would really like to meet one of the people from your planet. I won't make fun of you...I promise.
Unless you are really weird.


On Jul 26, 2011, at 10:48 PM, Randy Harmelink <rharmelink@gmail.com> wrote:

Check the "Links" area of the group for a link to a message on using add-in functions in VBA.

Also, check out the links related to smfUpdateDownloadTable. There's already a macro that more or less does the looping for you automatically.

Also note that typically "Ticker" is a defined worksheet cell name. You can't use it like you're doing below. You need to access it through the Range() function of VBA.
On Tue, Jul 26, 2011 at 7:24 PM, Ilya R <ilya559@yahoo.com> wrote:

I want to create a VBA with an array and a loop that would input "=RCHGetElementNumber(Ticker, 5565)" into different cells.

I have the following code
-----------------------------------------
Sub ilya49()
Dim colNum As Long, rowNum As Long, rch As String
rch = "=RCHGetElementNumber(Ticker, "


colNum = 2
For nm = 5565 To 5556 Step -1
colNum = colNum + 2
Sheets(1).Cells(24, colNum).Value = rch & nm
Next nm
End Sub
------------------------------------------

However, when I run it, it gives me an error "Run-time error '1004': Application-defined or object-defined error"

the reason for that is because rch = "=RCHGetElementNumber(Ticker, "

Is there any way to solve it or work around it???
Please Help!!!!!


Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1c.

Re: Help!VBA! trying to create a formula that wit "RCHGetElementNumb

Posted by: "Ilya R" ilya559@yahoo.com   ilya559

Wed Jul 27, 2011 4:34 pm (PDT)



Randy,
Thank you for your help, but I cannot seem to understand what needs to be done. I presume I have to insert the whole smfRCHgetElementNumber instead of a formula

my code looks like this:
------------------------
Sub ilya49()
Dim colNum As Long, rowNum As Long, rch As String
rch = smfGetAdvFNElement(5196;AdvFN-A;Annual Indicators -- Ending Date -- FY1;AdvFN-A;1;>INDICATORS;>year end date; ; ;0;0;0;0)

'/ Total Revenue 5305 - 5296
colNum = 2
For nm = 5305 To 5296 Step -1
colNum = colNum + 2
Cells(4, colNum).Value = rch
Next nm
End Sub
-------------------------

Please help!!!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Check the "Links" area of the group for a link to a message on using add-in
> functions in VBA.
>
> Also, check out the links related to smfUpdateDownloadTable. There's already
> a macro that more or less does the looping for you automatically.
>
> Also note that typically "Ticker" is a defined worksheet cell name. You
> can't use it like you're doing below. You need to access it through the
> Range() function of VBA.
>
> On Tue, Jul 26, 2011 at 7:24 PM, Ilya R <ilya559@...> wrote:
>
> >
> > I want to create a VBA with an array and a loop that would input
> > "=RCHGetElementNumber(Ticker, 5565)" into different cells.
> >
> > I have the following code
> > -----------------------------------------
> > Sub ilya49()
> > Dim colNum As Long, rowNum As Long, rch As String
> > rch = "=RCHGetElementNumber(Ticker, "
> >
> >
> > colNum = 2
> > For nm = 5565 To 5556 Step -1
> > colNum = colNum + 2
> > Sheets(1).Cells(24, colNum).Value = rch & nm
> > Next nm
> > End Sub
> > ------------------------------------------
> >
> > However, when I run it, it gives me an error "Run-time error '1004':
> > Application-defined or object-defined error"
> >
> > the reason for that is because *rch = "=RCHGetElementNumber(Ticker, "*
> >
> > Is there any way to solve it or work around it???
> > Please Help!!!!!
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1d.

Re: Help!VBA! trying to create a formula that wit "RCHGetElementNumb

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

Wed Jul 27, 2011 4:40 pm (PDT)



I don't understand why you would loop to set cells to the same value (i.e.
"rch") ? Where are your ticker symbols?

On Wed, Jul 27, 2011 at 4:34 PM, Ilya R <ilya559@yahoo.com> wrote:

> Thank you for your help, but I cannot seem to understand what needs to be
> done. I presume I have to insert the whole smfRCHgetElementNumber instead of
> a formula
>
> my code looks like this:
> ------------------------
> Sub ilya49()
> Dim colNum As Long, rowNum As Long, rch As String
> rch = smfGetAdvFNElement(5196;AdvFN-A;Annual Indicators -- Ending Date --
> FY1;AdvFN-A;1;>INDICATORS;>year end date; ; ;0;0;0;0)
>
> '/ Total Revenue 5305 - 5296
> colNum = 2
> For nm = 5305 To 5296 Step -1
> colNum = colNum + 2
> Cells(4, colNum).Value = rch
> Next nm
> End Sub
> -------------------------
>
> Please help!!!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

How to extract the symbol of the companies which have earning releas

Posted by: "cocoaacc" cocoaacc@yahoo.com.hk   cocoaacc

Wed Jul 27, 2011 7:43 am (PDT)



Dear Sir/Madam,

I have known how to create a table of stocks using the below function,
=RCHGetYahooQuotes(A4:A5001,B2:AG2,,NOW())

I am wondering if I can extract the symbol of the companies which have earning release today.
Such as, I would like to extract the company's symbols to excel in the below link,
http://biz.yahoo.com/research/earncal/today.html

Many Thanks!
Will

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

Re: How to extract the symbol of the companies which have earning re

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

Wed Jul 27, 2011 9:32 am (PDT)



You can get the whole table with:

=RCHGetHTMLTable("http://biz.yahoo.com/research/earncal/today.html
",">Symbol",-1,"",1)

On Wed, Jul 27, 2011 at 7:42 AM, cocoaacc <cocoaacc@yahoo.com.hk> wrote:

>
> I have known how to create a table of stocks using the below function,
> =RCHGetYahooQuotes(A4:A5001,B2:AG2,,NOW())
>
> I am wondering if I can extract the symbol of the companies which have
> earning release today.
> Such as, I would like to extract the company's symbols to excel in the
> below link,
> http://biz.yahoo.com/research/earncal/today.html
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

Re: RCHGetTable Cell Question

Posted by: "GaryFera" gfera@shaw.ca   GaryFera

Wed Jul 27, 2011 9:35 am (PDT)



Thanks, Randy - that solution worked.

I am still curious about how to extract the arrow or color data if you have had any experience with that. Otherwise not to worry.

Gary

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> How about a simpler solution -- use RCHGetYahooQuotes() to retrieve the
> prior day close of all of your ticker symbols, then compute the $ change and
> % change yourself?
>
> On Tue, Jul 26, 2011 at 6:35 AM, GaryFera <gfera@...> wrote:
>
> > Randy, I am okay to use either of your suggestions (text or color) but I
> > cannot figure out how to extract that information from what SMF returns in
> > the data. Any advice would be welcomed.
> >
> > Gary
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > In similar situations, I've looked for the text of the actual image of
> > the
> > > arrow, then used that to determine if it was positive or negative. Or you
> > > can look at the font color on the change amount, since they usually use
> > red
> > > or green.
> > >
> > > On Mon, Jul 25, 2011 at 6:30 AM, GaryFera <gfera@> wrote:
> > >
> > > > Randy, one of the available views on Finance.Yahoo.com is the
> > Real-Time
> > > > view an example of which is shown below.
> > > >
> > > > The "change" data contains an arrow indicating if the security is up
> > or
> > > > down in price. But this arrow is a small image and when I use the
> > > > RCHGetTableCell function to retrieve the data from the web site I do
> > get the
> > > > dollar value of the change but not the small image. So I cannot tell
> > from
> > > > the inquiry if the security has gone up or down because that particular
> > > > Yahoo view does not provide the previous close price.
> > > >
> > > > Do you have any suggestions that would allow me to determine the
> > direction
> > > > of the change? Thanks.
> > > >
> > > > Gary
> > > >
> > > > Symbol Last Trade Change Related Info
> > > > AA 9:12AM EDT 15.60 0.23 1.45% Chart, Message, Profile, more...
> >
>

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

Re: RCHGetTable Cell Question

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

Wed Jul 27, 2011 10:18 am (PDT)



I haven't been able to find any examples, although I know I've done it in
the past. It's a method of last resort.

On Wed, Jul 27, 2011 at 9:35 AM, GaryFera <gfera@shaw.ca> wrote:

>
> I am still curious about how to extract the arrow or color data if you have
> had any experience with that. Otherwise not to worry.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
4a.

My spreadsheets cannot see the SMF addin functions

Posted by: "James Nylen" jnylen@gmail.com   jamesnylen

Wed Jul 27, 2011 10:20 am (PDT)



Hi all,

I'm having an issue with the SMF addin where my Excel files cannot see the
RCH...() functions or use them in formulas. I'm using Excel 2007 on Windows
7. To get around this, I have added a reference to the addin to each of my
workbooks and written "wrapper" functions as follows:

Public Function GetElementNumber(ByVal pTicker As String, _
Optional ByVal pItem As Integer = 1, _
Optional ByVal pError As Variant = "Error", _
Optional ByVal pFile As String = "")

GetElementNumber = RCHGetElementNumber(pTicker, pItem, pError, pFile)
End Function

However, this is pretty clunky and annoying since it has to be done for
every file. Anybody have any idea what could be going wrong? I've checked
that the add-in is installed and enabled - otherwise, I don't think I would
be able to use it the way I am now.

Also, on a side note, I was thinking about some ways the code could be
improved. One idea was allowing strings (e.g. "Market Cap") to be passed in
to specify the desired data item(s). Another was to improve the caching
system to not limit the number of entries that can be stored, and use files
on the hard drive to store previous requests persistently.

Each of those ideas would take some work and further thought, but Randy, I'd
especially like to hear your thoughts there. I was also thinking about
attempting to write some of the add-in's logic in C# since I greatly prefer
to code in that environment. This is good stuff though - I haven't been
able to find anything else that comes anywhere close to the quality or
comprehensiveness of this package.

Thanks,
James
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4b.

Re: My spreadsheets cannot see the SMF addin functions

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

Wed Jul 27, 2011 10:39 am (PDT)



On Wed, Jul 27, 2011 at 10:14 AM, James Nylen <jnylen@gmail.com> wrote:

> I'm having an issue with the SMF addin where my Excel files cannot see the
> RCH...() functions or use them in formulas. I'm using Excel 2007 on Windows
> 7.
>

I've never heard of such a thing when the add-in is properly installed.
Might this be a corporate machine that doesn't allow add-ins?

> To get around this, I have added a reference to the addin to each of my
> workbooks and written "wrapper" functions as follows:
>
> Public Function GetElementNumber(ByVal pTicker As String, _
> Optional ByVal pItem As Integer = 1, _
> Optional ByVal pError As Variant = "Error", _
> Optional ByVal pFile As String = "")
>
> GetElementNumber = RCHGetElementNumber(pTicker, pItem, pError, pFile)
> End Function
>
> However, this is pretty clunky and annoying since it has to be done for
> every file. Anybody have any idea what could be going wrong?
>

Wrapper functions won't work properly for some functions, because they use
the Application.Caller object in their processing.

> I've checked that the add-in is installed and enabled - otherwise, I don't
> think I would be able to use it the way I am now.
>

What do you get with:

=RCHGetElementNumber("Version")

If that doesn't work, you don't have the add-in installed and enabled.

Note that the EXCEL worksheet and the VBA project are two completely
separate environments. To use the add-in in either location requires a
separate activation process.

Also, on a side note, I was thinking about some ways the code could be
> improved. One idea was allowing strings (e.g. "Market Cap") to be passed in
> to specify the desired data item(s).
>

Initially, that was the process. But it added another layer of having to
look things up. Plus, a string definition for many items would be way too
difficult to remember. In most cases, the best way to create the formulas is
by a copy and paste from a template anyway, because you are copying it out
of the context the function is being used in.

Another was to improve the caching system to not limit the number of entries
> that can be stored, and use files on the hard drive to store previous
> requests persistently.
>

Won't happen. I'm afraid too many people would try to download everything
they can, as often as they can. Too many people think more data will help
them make better decisions. However, it's UNDERSTANDING the data that helps
make better decisions. More data means people take less time to understand
the data.

Besides, I don't want to overload the free data services. It would be easy
enough for them to present the data in a different way that would prevent
the add-in from accessing the data.

At the start, I did have a function that loaded a database, and the data
could either be retrieved from the database or from online.

Each of those ideas would take some work and further thought, but Randy, I'd
> especially like to hear your thoughts there. I was also thinking about
> attempting to write some of the add-in's logic in C# since I greatly prefer
> to code in that environment. This is good stuff though - I haven't been
> able to find anything else that comes anywhere close to the quality or
> comprehensiveness of this package.
>

It can about because of my frustration with the EXCEL Web Query process. Too
many crashes. Too difficult to get the exact data. Etc.
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4c.

Re: My spreadsheets cannot see the SMF addin functions

Posted by: "James Nylen" jnylen@gmail.com   jamesnylen

Wed Jul 27, 2011 12:21 pm (PDT)



I'll play around with the add-in some more. I agree that either I missed
something simple or my corporate settings are the problem, but we do have
people who use Essbase and other Excel add-ins so I'm not sure.

My intent with the caching improvements was actually to cut down on the
number of requests to the services... I am trying to do some historical
analysis and many of the data items I am using should not change. It should
be possible to come up with some kind of scheme to indicate which retrieved
items expire when, but that would probably take a while.

Finally, one more question for you: do you have the add-in code under
source control somewhere?

Thanks again,
James

On Wed, Jul 27, 2011 at 1:39 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> On Wed, Jul 27, 2011 at 10:14 AM, James Nylen <jnylen@gmail.com> wrote:
>
>> I'm having an issue with the SMF addin where my Excel files cannot see
>> the RCH...() functions or use them in formulas. I'm using Excel 2007 on
>> Windows 7.
>>
>
> I've never heard of such a thing when the add-in is properly installed.
> Might this be a corporate machine that doesn't allow add-ins?
>
>
>> To get around this, I have added a reference to the addin to each of my
>> workbooks and written "wrapper" functions as follows:
>>
>> Public Function GetElementNumber(ByVal pTicker As String, _
>> Optional ByVal pItem As Integer = 1, _
>> Optional ByVal pError As Variant = "Error", _
>> Optional ByVal pFile As String = "")
>>
>> GetElementNumber = RCHGetElementNumber(pTicker, pItem, pError, pFile)
>> End Function
>>
>> However, this is pretty clunky and annoying since it has to be done for
>> every file. Anybody have any idea what could be going wrong?
>>
>
> Wrapper functions won't work properly for some functions, because they use
> the Application.Caller object in their processing.
>
>
>> I've checked that the add-in is installed and enabled - otherwise, I don't
>> think I would be able to use it the way I am now.
>>
>
> What do you get with:
>
> =RCHGetElementNumber("Version")
>
> If that doesn't work, you don't have the add-in installed and enabled.
>
> Note that the EXCEL worksheet and the VBA project are two completely
> separate environments. To use the add-in in either location requires a
> separate activation process.
>
> Also, on a side note, I was thinking about some ways the code could be
>> improved. One idea was allowing strings (e.g. "Market Cap") to be passed in
>> to specify the desired data item(s).
>>
>
> Initially, that was the process. But it added another layer of having to
> look things up. Plus, a string definition for many items would be way too
> difficult to remember. In most cases, the best way to create the formulas is
> by a copy and paste from a template anyway, because you are copying it out
> of the context the function is being used in.
>
> Another was to improve the caching system to not limit the number of
>> entries that can be stored, and use files on the hard drive to store
>> previous requests persistently.
>>
>
> Won't happen. I'm afraid too many people would try to download everything
> they can, as often as they can. Too many people think more data will help
> them make better decisions. However, it's UNDERSTANDING the data that helps
> make better decisions. More data means people take less time to understand
> the data.
>
> Besides, I don't want to overload the free data services. It would be easy
> enough for them to present the data in a different way that would prevent
> the add-in from accessing the data.
>
> At the start, I did have a function that loaded a database, and the data
> could either be retrieved from the database or from online.
>
> Each of those ideas would take some work and further thought, but Randy,
>> I'd especially like to hear your thoughts there. I was also thinking about
>> attempting to write some of the add-in's logic in C# since I greatly prefer
>> to code in that environment. This is good stuff though - I haven't been
>> able to find anything else that comes anywhere close to the quality or
>> comprehensiveness of this package.
>>
>
> It can about because of my frustration with the EXCEL Web Query process.
> Too many crashes. Too difficult to get the exact data. Etc.
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4d.

Re: My spreadsheets cannot see the SMF addin functions

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

Wed Jul 27, 2011 1:17 pm (PDT)



On Wed, Jul 27, 2011 at 12:21 PM, James Nylen <jnylen@gmail.com> wrote:
>
> My intent with the caching improvements was actually to cut down on the
number
> of requests to the services... I am trying to do some historical analysis
and many
> of the data items I am using should not change. It should be possible to
come up
> with some kind of scheme to indicate which retrieved items expire when,
but that
> would probably take a while.

Take a look at the smfUpdateDownloadTable process (see the "Links" area of
the group). It loads values into the worksheet instead of a formula that
recalculates.

> Finally, one more question for you: do you have the add-in code under
source control somewhere?

Nope. Just manual archives that I keep.
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5a.

Calculates on doing anything

Posted by: "sterob" anticato124@gmail.com   sterob_469

Wed Jul 27, 2011 2:48 pm (PDT)



Hi,

I'm using Excel 2010 on Windows 7. When incorporating any of the Yahoo-based functions in my spreadsheets, most importantly the price by date function, I have recently had some aggravation.

My basic design is to find use the quotes from 4 chosen dates for a number of stocks. Even when I limit it to the S&P 100 companies, and only 2 dates, I still get the problem. To wit, when I do anything else, it calculates again the function's data extraction. Even when I am using completely unrelated cells, even when what I'm entering requires no new calculations. I don't mind if it takes a minute or two to originally get the data, but once I manipulate the data I would like it to just sit there.

I have tried using arrays, but as my spreadsheet is about many more tickers than dates, it is not of much benefit. I know I can turn all calculations off, but then I can't do anything else either. I have looked through old messages, and some have mentioned playing with macros, but I didn't really understand how to implement that solution, or if it would be effective in my situation.

Thank you,
Steven

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

Re: Calculates on doing anything

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

Wed Jul 27, 2011 2:52 pm (PDT)



Most of the formula are non-volatile and shouldn't recalculate every time
something changes. HOWEVER, if you MAKE them volatile by using a volatile
function, they WILL recalculate with every change.

For example, if one of the dates you are using in the function is something
like DATE(), it does change with every worksheet update, and would thus
trigger anything for recalculation anything that uses it. Could that be the
culprit of your problem?

On Wed, Jul 27, 2011 at 2:21 PM, sterob <anticato124@gmail.com> wrote:

> Hi,
>
> I'm using Excel 2010 on Windows 7. When incorporating any of the
> Yahoo-based functions in my spreadsheets, most importantly the price by date
> function, I have recently had some aggravation.
>
> My basic design is to find use the quotes from 4 chosen dates for a number
> of stocks. Even when I limit it to the S&P 100 companies, and only 2 dates,
> I still get the problem. To wit, when I do anything else, it calculates
> again the function's data extraction. Even when I am using completely
> unrelated cells, even when what I'm entering requires no new calculations.
> I don't mind if it takes a minute or two to originally get the data, but
> once I manipulate the data I would like it to just sit there.
>
> I have tried using arrays, but as my spreadsheet is about many more tickers
> than dates, it is not of much benefit. I know I can turn all calculations
> off, but then I can't do anything else either. I have looked through old
> messages, and some have mentioned playing with macros, but I didn't really
> understand how to implement that solution, or if it would be effective in my
> situation.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
5c.

Re: Calculates on doing anything

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

Wed Jul 27, 2011 2:53 pm (PDT)



Oops...I meant the TODAY() or NOW() functions, not the DATE() function.
Sorry.

On Wed, Jul 27, 2011 at 2:52 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> Most of the formula are non-volatile and shouldn't recalculate every time
> something changes. HOWEVER, if you MAKE them volatile by using a volatile
> function, they WILL recalculate with every change.
>
> For example, if one of the dates you are using in the function is something
> like DATE(), it does change with every worksheet update, and would thus
> trigger anything for recalculation anything that uses it. Could that be the
> culprit of your problem?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
5d.

Re: Calculates on doing anything

Posted by: "S Anti-cato" anticato124@gmail.com   sterob_469

Wed Jul 27, 2011 3:50 pm (PDT)



Yes, that seems to be better.

Thank you

On Wed, Jul 27, 2011 at 4:53 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> Oops...I meant the TODAY() or NOW() functions, not the DATE() function.
> Sorry.
>
>
> On Wed, Jul 27, 2011 at 2:52 PM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>> Most of the formula are non-volatile and shouldn't recalculate every time
>> something changes. HOWEVER, if you MAKE them volatile by using a volatile
>> function, they WILL recalculate with every change.
>>
>> For example, if one of the dates you are using in the function is
>> something like DATE(), it does change with every worksheet update, and would
>> thus trigger anything for recalculation anything that uses it. Could that be
>> the culprit of your problem?
>>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
5e.

Re: Calculates on doing anything

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

Wed Jul 27, 2011 3:59 pm (PDT)



One thing I've done in the past to get the "current date" for such
processing:

=RCHGetYahooQuotes("SPY","d1")

It should be a non-volatile way of getting the most recent trading date of
the market.
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
6.

Takeover

Posted by: "jeromieweatherburn" jeromieweatherburn@yahoo.com.au   jeromieweatherburn

Wed Jul 27, 2011 7:29 pm (PDT)



Accepting there is a risk that I will be booted off the group, I wanted to see if anyone is keen to get a proactive group together and actually take some of this analysis to the next level.

My problem which I will extrapolate to most of you is that I trade in 10K's not 1Mill's + which one needs to do if you want to get anywhere.

To date I have had no success approaching Venture Capital or Private Equity firms saying, "Hey, lets do a JV of some sort, using my analysis" to identify cheap companies (approached 5 or 6 thus far).

The easiest starting place is Cash Boxes where;
SUM(Cash & Marketable Securities) - Total Liabilities is about equal to Market Capitalization.

Take a sufficient stake to kick out current management (20%-30% of shares at minimum) because they are probably just paying themselves a high income and not doing anything, and either;
1) redeploy cash to other CashBoxes repeating the process , or,
2) Buy back other shares using company funds to increase proportion ownership before,
2) Wind Up and distribute net assets.

Approach would be that of consensus, which companies have the highest potential agreed by the group (i.e the value of other assets which have been ignored by the market, ownership structure as if someone owns 50% you are boned to start with etc etc).

There are of course some tricks that we would need to be aware of such as
1) In Australia there is a 4 month rule that you can't do a takeover at a higher price than you bought at to preent the screwing over of those you first bought shares off.
2) Fit & Proper person test to be a director.
3) Intricacies to call for a Special General Meeting and the sort (outlined in the corporations act).

This isn't prohibitive just traps to be aware of esp if dealing Offshore (I don't know US laws for example).

You would require Internet Access (information to judge any opportunity should be online and easily reviewed by the group) and must be a publicly listed company (i.e don't pitch your cousin's Start Up).

If you are interested let me know.
Promise I'm not from Nigeria if this sounds like a 419 letter. More just a frustrated chump with knowledge but not capital.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
7a.

Formula stopped working

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

Wed Jul 27, 2011 10:23 pm (PDT)



Hi Randy,

I was using the example formula below to get the ticker information from a comapany name from the Reuters website. However, now the formula is not returning anything. Did reuters change the format of their website or am I missing something? All my other smfaddin functions work fine.
Thank you very much in advance for your help.

=smfStrExtr(RCHGetWebData(CONCATENATE("http://www.reuters.com/finance/stocks/lookup?searchType=any&search=","BAYHILL","%20","CAPITAL","%20","CORP"),10484,5000),"symbol=",".")

kk

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

Re: Formula stopped working

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

Wed Jul 27, 2011 10:31 pm (PDT)



Just drop the "10484,5000" from the formula. RCHGetWebData() returns a
32,767 byte string, so there's no reason to add that possibility of it
failing. If they add or subtract code from the page, your range may not
contain the data you need.

Simplest version I have:

=smfStrExtr(RCHGetWebData("
http://www.reuters.com/finance/stocks/lookup?searchType=any&search=BAYHILLCAPITAL
CORP",1),"symbol=",".")

...or:

=smfStrExtr(RCHGetWebData("
http://www.reuters.com/finance/stocks/lookup?searchType=any&search=BAYHILLCAPITAL
CORP","symbol="),"symbol=",".")

On Wed, Jul 27, 2011 at 10:22 PM, kkkutty <kkkutty@yahoo.com> wrote:

>
> I was using the example formula below to get the ticker information from a
> comapany name from the Reuters website. However, now the formula is not
> returning anything. Did reuters change the format of their website or am I
> missing something? All my other smfaddin functions work fine.
> Thank you very much in advance for your help.
>
> =smfStrExtr(RCHGetWebData(CONCATENATE("
> http://www.reuters.com/finance/stocks/lookup?searchType=any&search=
> ","BAYHILL","%20","CAPITAL","%20","CORP"),10484,5000),"symbol=",".")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
7c.

Re: Formula stopped working

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

Wed Jul 27, 2011 11:05 pm (PDT)



Thank you very much!...it worked.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Just drop the "10484,5000" from the formula. RCHGetWebData() returns a
> 32,767 byte string, so there's no reason to add that possibility of it
> failing. If they add or subtract code from the page, your range may not
> contain the data you need.
>
> Simplest version I have:
>
> =smfStrExtr(RCHGetWebData("
> http://www.reuters.com/finance/stocks/lookup?searchType=any&search=BAYHILLCAPITAL
> CORP",1),"symbol=",".")
>
> ...or:
>
> =smfStrExtr(RCHGetWebData("
> http://www.reuters.com/finance/stocks/lookup?searchType=any&search=BAYHILLCAPITAL
> CORP","symbol="),"symbol=",".")
>
> On Wed, Jul 27, 2011 at 10:22 PM, kkkutty <kkkutty@...> wrote:
>
> >
> > I was using the example formula below to get the ticker information from a
> > comapany name from the Reuters website. However, now the formula is not
> > returning anything. Did reuters change the format of their website or am I
> > missing something? All my other smfaddin functions work fine.
> > Thank you very much in advance for your help.
> >
> > =smfStrExtr(RCHGetWebData(CONCATENATE("
> > http://www.reuters.com/finance/stocks/lookup?searchType=any&search=
> > ","BAYHILL","%20","CAPITAL","%20","CORP"),10484,5000),"symbol=",".")
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
Visit Your Group
Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 03.59

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)