Messages In This Digest (14 Messages)

1a.: Re: Managing with Excel Arrays From: KailuaKid
1b.: Re: Managing with Excel Arrays From: george
1c.: Re: Managing with Excel Arrays From: Ashish Mukerji
1d.: Re: Managing with Excel Arrays From: george
1e.: Re: Managing with Excel Arrays From: Ashish Mukerji

2.1.: Re: Stock Screener From: Kermit W. Prather
2.2.: Re: Stock Screener From: Ashish Mukerji

3a.: Change in Yahoo Finance Format From: Marty
3b.: Re: Change in Yahoo Finance Format From: Martin Topper
3c.: Re: Change in Yahoo Finance Format From: Randy Harmelink
3d.: Re: Change in Yahoo Finance Format From: bizmark_ee

4a.: Re: problem with smfGetADVFNElement From: antonvanas1989
4b.: Re: problem with smfGetADVFNElement From: Mike McQuaid
4c.: Re: problem with smfGetADVFNElement From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.: Re: Managing with Excel Arrays

Posted by: "KailuaKid" Gary.Hartling@gmail.com garyhartling

Wed Jan 18, 2012 8:07 am (PST)

Here's what I do to make modifying arrays easier. I set up 2 macros that are tied to buttons at the top of my spreadsheet. One macro clears the array like this:

Sub Modify_GH_Stocks()
' Undo GH_Array so I can modify stock entries.
Application.Goto Reference:="GH_Array"
Selection.ClearContents
End Sub

where "GH_Array" is a defined name for the array. BTW, you can easily figure out the bounds of your array by by selecting any cell in the array and doing a CTRL+/ (holding down the Control key and hitting the "/" key).

Once you "clear" the array you can delete/insert rows as much as you want and then I hit the other button which is tied to the macro that sets the array back in place:

Sub Set_GH_Array()
' Set up the GH_Array so Yahoo can update the quotes.'
Range("F4").Select
ActiveCell.FormulaR1C1 = "=RCHGetYahooQuotes(GH_Tickers,GH_Datalist,,_NOW)"
Application.Goto Reference:="GH_Array"
Selection.FormulaArray = "=RCHGetYahooQuotes(GH_Tickers,GH_Datalist,,_NOW)"
End Sub

In my case, cell F4 is the upper-left cell of the array, "GH_Tickers" is a defined name for the tickers in the array and "GH_Datalist" is a defined name for the Yahoo retrievals I want, like "l1" for last quote, etc. "_NOW" is a defined name for a cell that contains "=NOW()". Hope this helps.

--Gary H.

--- In smf_addin@yahoogroups.com, "Ashish" <ashishkm@...> wrote:
>
> I understand the benefit of using Arrays with SMF Add-in functions like RCHGetYahooQuotes() or smfGetOptionQuotes() but I find it quite cumbersome to manage a large array which, from time to time, needs quite a few rows to be deleted (for example at option expirations) ... o if I need to sort the array based on certain parameters based outside of the array .... it is entirely possible that I do not know some of the tricks that might exist .... any suggestions? ... thanks in advance ....
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
1b.: Re: Managing with Excel Arrays

Posted by: "george" panax@fuse.net simon_of_iernot

Wed Jan 18, 2012 9:39 am (PST)

What I have done on this is to link the stock symbol in the workbook with the array (workbook X) to a different workbook (workbook Y). The array is set up to work on columns B - L with the stock symbol variable that feeds the array in column A.

But since column A in workbook X is linked to a column in workbook Y it is childs play to change/add/delete/sort items in workbook Y and save.

When opening workbook X it asks if I want to update the linked data -- I say yes, and it updates. It takes around 5 seconds to update the stock symbols and array data in workbook X. Before I set it up to operate in an array it took 6 minutes to update, so array math is a must have...

Simon

----- Original Message -----
From: KailuaKid
To: smf_addin@yahoogroups.com
Sent: Wednesday, January 18, 2012 11:07
Subject: [smf_addin] Re: Managing with Excel Arrays

Here's what I do to make modifying arrays easier. I set up 2 macros that are tied to buttons at the top of my spreadsheet. One macro clears the array like this:

Sub Modify_GH_Stocks()
' Undo GH_Array so I can modify stock entries.
Application.Goto Reference:="GH_Array"
Selection.ClearContents
End Sub

where "GH_Array" is a defined name for the array. BTW, you can easily figure out the bounds of your array by by selecting any cell in the array and doing a CTRL+/ (holding down the Control key and hitting the "/" key).

Once you "clear" the array you can delete/insert rows as much as you want and then I hit the other button which is tied to the macro that sets the array back in place:

Sub Set_GH_Array()
' Set up the GH_Array so Yahoo can update the quotes.'
Range("F4").Select
ActiveCell.FormulaR1C1 = "=RCHGetYahooQuotes(GH_Tickers,GH_Datalist,,_NOW)"
Application.Goto Reference:="GH_Array"
Selection.FormulaArray = "=RCHGetYahooQuotes(GH_Tickers,GH_Datalist,,_NOW)"
End Sub

In my case, cell F4 is the upper-left cell of the array, "GH_Tickers" is a defined name for the tickers in the array and "GH_Datalist" is a defined name for the Yahoo retrievals I want, like "l1" for last quote, etc. "_NOW" is a defined name for a cell that contains "=NOW()". Hope this helps.

--Gary H.

--- In smf_addin@yahoogroups.com, "Ashish" <ashishkm@...> wrote:
>
> I understand the benefit of using Arrays with SMF Add-in functions like RCHGetYahooQuotes() or smfGetOptionQuotes() but I find it quite cumbersome to manage a large array which, from time to time, needs quite a few rows to be deleted (for example at option expirations) ... o if I need to sort the array based on certain parameters based outside of the array .... it is entirely possible that I do not know some of the tricks that might exist .... any suggestions? ... thanks in advance ....
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
1c.: Re: Managing with Excel Arrays

Posted by: "Ashish Mukerji" ashishkm@yahoo.com ashishkm

Wed Jan 18, 2012 2:55 pm (PST)

that sounds like a neat trick ... i wonder if you mean "sheet x" and "sheet y" instead of workbook x and y ... i will certainly play with this .... thx. Simon

Ashish

>________________________________
> From: george <panax@fuse.net>
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, January 18, 2012 12:38 PM
>Subject: Re: [smf_addin] Re: Managing with Excel Arrays
>
>
>
>What I have done on this is to link the stock
symbol in the workbook with the array (workbook X) to a
different workbook (workbook Y). The array is set up to work on columns B
- L with the stock symbol variable that feeds the array in column
A.
>
>But since column A in workbook X is linked to
a column in workbook Y it is childs play to change/add/delete/sort
items in workbook Y and save.
>
>When opening workbook X it asks if I want to update
the linked data -- I say yes, and it updates. It takes around 5 seconds to
update the stock symbols and array data in workbook X. Before I set it up
to operate in an array it took 6 minutes to update, so array math is a must
have...
>
>Simon
>
>
>----- Original Message -----
>>From: KailuaKid
>>To: smf_addin@yahoogroups.com
>>Sent: Wednesday, January 18, 2012 11:07
>>Subject: [smf_addin] Re: Managing with Excel Arrays
>>
>>
>>
>>
>>Here's what I do to make modifying arrays easier. I set up 2 macros
that are tied to buttons at the top of my spreadsheet. One macro clears the
array like this:
>>
>>Sub Modify_GH_Stocks()
>>' Undo GH_Array so I can
modify stock entries.
>>Application.Goto
Reference:="GH_Array"
>>Selection.ClearContents
>>End Sub
>>
>>where
"GH_Array" is a defined name for the array. BTW, you can easily figure out the
bounds of your array by by selecting any cell in the array and doing a CTRL+/
(holding down the Control key and hitting the "/" key).
>>
>>Once you
"clear" the array you can delete/insert rows as much as you want and then I
hit the other button which is tied to the macro that sets the array back in
place:
>>
>>Sub Set_GH_Array()
>>' Set up the GH_Array so Yahoo can update
the quotes.'
>>Range("F4").Select
>>ActiveCell.FormulaR1C1 =
"=RCHGetYahooQuotes(GH_Tickers,GH_Datalist,,_NOW)"
>>Application.Goto
Reference:="GH_Array"
>>Selection.FormulaArray =
"=RCHGetYahooQuotes(GH_Tickers,GH_Datalist,,_NOW)"
>>End Sub
>>
>>In my
case, cell F4 is the upper-left cell of the array, "GH_Tickers" is a defined
name for the tickers in the array and "GH_Datalist" is a defined name for the
Yahoo retrievals I want, like "l1" for last quote, etc. "_NOW" is a defined
name for a cell that contains "=NOW()". Hope this helps.
>>
>>--Gary
H.
>>
>>--- In smf_addin@yahoogroups.com, "Ashish" <ashishkm@...> wrote:
>>>
>>> I understand the benefit
of using Arrays with SMF Add-in functions like RCHGetYahooQuotes() or
smfGetOptionQuotes() but I find it quite cumbersome to manage a large array
which, from time to time, needs quite a few rows to be deleted (for example at
option expirations) ... o if I need to sort the array based on certain
parameters based outside of the array .... it is entirely possible that I do
not know some of the tricks that might exist .... any suggestions? ... thanks
in advance ....
>>>
>>
>>
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
1d.: Re: Managing with Excel Arrays

Posted by: "george" panax@fuse.net simon_of_iernot

Wed Jan 18, 2012 3:46 pm (PST)

No it is different workbooks, not worksheets. If it was in the same workbook the whole thing would be re-calculating every time one made a change. So, I think you will find that you will want to use two separate workbooks (files).

good luck

Simon

----- Original Message -----
From: Ashish Mukerji
To: smf_addin@yahoogroups.com
Sent: Wednesday, January 18, 2012 17:55
Subject: Re: [smf_addin] Re: Managing with Excel Arrays

that sounds like a neat trick ... i wonder if you mean "sheet x" and "sheet y" instead of workbook x and y ... i will certainly play with this .... thx. Simon

Ashish

----------------------------------------------------------
From: george <panax@fuse.net>
To: smf_addin@yahoogroups.com
Sent: Wednesday, January 18, 2012 12:38 PM
Subject: Re: [smf_addin] Re: Managing with Excel Arrays

What I have done on this is to link the stock symbol in the workbook with the array (workbook X) to a different workbook (workbook Y). The array is set up to work on columns B - L with the stock symbol variable that feeds the array in column A.

But since column A in workbook X is linked to a column in workbook Y it is childs play to change/add/delete/sort items in workbook Y and save.

When opening workbook X it asks if I want to update the linked data -- I say yes, and it updates. It takes around 5 seconds to update the stock symbols and array data in workbook X. Before I set it up to operate in an array it took 6 minutes to update, so array math is a must have...

Simon

----- Original Message -----
From: KailuaKid
To: smf_addin@yahoogroups.com
Sent: Wednesday, January 18, 2012 11:07
Subject: [smf_addin] Re: Managing with Excel Arrays

Here's what I do to make modifying arrays easier. I set up 2 macros that are tied to buttons at the top of my spreadsheet. One macro clears the array like this:

Sub Modify_GH_Stocks()
' Undo GH_Array so I can modify stock entries.
Application.Goto Reference:="GH_Array"
Selection.ClearContents
End Sub

where "GH_Array" is a defined name for the array. BTW, you can easily figure out the bounds of your array by by selecting any cell in the array and doing a CTRL+/ (holding down the Control key and hitting the "/" key).

Once you "clear" the array you can delete/insert rows as much as you want and then I hit the other button which is tied to the macro that sets the array back in place:

Sub Set_GH_Array()
' Set up the GH_Array so Yahoo can update the quotes.'
Range("F4").Select
ActiveCell.FormulaR1C1 = "=RCHGetYahooQuotes(GH_Tickers,GH_Datalist,,_NOW)"
Application.Goto Reference:="GH_Array"
Selection.FormulaArray = "=RCHGetYahooQuotes(GH_Tickers,GH_Datalist,,_NOW)"
End Sub

In my case, cell F4 is the upper-left cell of the array, "GH_Tickers" is a defined name for the tickers in the array and "GH_Datalist" is a defined name for the Yahoo retrievals I want, like "l1" for last quote, etc. "_NOW" is a defined name for a cell that contains "=NOW()". Hope this helps.

--Gary H.

--- In smf_addin@yahoogroups.com, "Ashish" <ashishkm@...> wrote:
>
> I understand the benefit of using Arrays with SMF Add-in functions like RCHGetYahooQuotes() or smfGetOptionQuotes() but I find it quite cumbersome to manage a large array which, from time to time, needs quite a few rows to be deleted (for example at option expirations) ... o if I need to sort the array based on certain parameters based outside of the array .... it is entirely possible that I do not know some of the tricks that might exist .... any suggestions? ... thanks in advance ....
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
1e.: Re: Managing with Excel Arrays

Posted by: "Ashish Mukerji" ashishkm@yahoo.com ashishkm

Wed Jan 18, 2012 4:59 pm (PST)

Thx. Simon ... You saved me some needless frustration ...

Ashish

>________________________________
> From: george <panax@fuse.net>
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, January 18, 2012 6:46 PM
>Subject: Re: [smf_addin] Re: Managing with Excel Arrays
>
>
>
>
>No it is different workbooks, not worksheets.
If it was in the same workbook the whole thing would be re-calculating every
time one made a change. So, I think you will find that you will want to
use two separate workbooks (files).
>
>good luck
>
>Simon
>
>
>----- Original Message -----
>>From: Ashish Mukerji
>>To: smf_addin@yahoogroups.com
>>Sent: Wednesday, January 18, 2012 17:55
>>Subject: Re: [smf_addin] Re: Managing with Excel Arrays
>>
>>
>>that sounds like a neat trick ... i wonder if you mean "sheet x" and "sheet y" instead of workbook x and y ... i will certainly play with this .... thx. Simon
>>
>>Ashish
>>
>>
>>
>>>________________________________
>>> From: george <panax@fuse.net>
>>>To: smf_addin@yahoogroups.com
>>>Sent: Wednesday, January 18, 2012 12:38 PM
>>>Subject: Re: [smf_addin] Re: Managing with Excel Arrays
>>>
>>>
>>>
>>>What I have done on this is to link the stock symbol in the workbook with the array (workbook X)   to a different workbook (workbook Y). The array is set up to work on columns B - L with the stock symbol variable that feeds the array in column A.
>>>
>>>But since column A in workbook X is linked to a column in workbook Y it is childs play to change/add/delete/sort items in workbook Y and save.
>>>
>>>When opening workbook X it asks if I want to update the linked data -- I say yes, and it updates. It takes around 5 seconds to update the stock symbols and array data in workbook X. Before I set it up to operate in an array it took 6 minutes to update, so array math is a must have...
>>>
>>>Simon
>>>
>>>
>>>----- Original Message -----
>>>>From: KailuaKid
>>>>To: smf_addin@yahoogroups.com
>>>>Sent: Wednesday, January 18, 2012 11:07
>>>>Subject: [smf_addin] Re: Managing with Excel Arrays
>>>>
>>>>
>>>>
>>>>
>>>>Here's what I do to make modifying arrays easier. I set up 2
macros that are tied to buttons at the top of my spreadsheet. One macro
clears the array like this:
>>>>
>>>>Sub Modify_GH_Stocks()
>>>>' Undo
GH_Array so I can modify stock entries.
>>>>Application.Goto
Reference:="GH_Array"
>>>>Selection.ClearContents
>>>>End Sub
>>>>
>>>>where
"GH_Array" is a defined name for the array. BTW, you can easily figure out
the bounds of your array by by selecting any cell in the array and doing a
CTRL+/ (holding down the Control key and hitting the "/" key).
>>>>
>>>>Once
you "clear" the array you can delete/insert rows as much as you want and
then I hit the other button which is tied to the macro that sets the array
back in place:
>>>>
>>>>Sub Set_GH_Array()
>>>>' Set up the GH_Array so Yahoo
can update the quotes.'
>>>>Range("F4").Select
>>>>ActiveCell.FormulaR1C1 =
"=RCHGetYahooQuotes(GH_Tickers,GH_Datalist,,_NOW)"
>>>>Application.Goto
Reference:="GH_Array"
>>>>Selection.FormulaArray =
"=RCHGetYahooQuotes(GH_Tickers,GH_Datalist,,_NOW)"
>>>>End Sub
>>>>
>>>>In my
case, cell F4 is the upper-left cell of the array, "GH_Tickers" is a
defined name for the tickers in the array and "GH_Datalist" is a defined
name for the Yahoo retrievals I want, like "l1" for last quote, etc.
"_NOW" is a defined name for a cell that contains "=NOW()". Hope this
helps.
>>>>
>>>>--Gary H.
>>>>
>>>>--- In smf_addin@yahoogroups.com, "Ashish" <ashishkm@...> wrote:
>>>>>
>>>>> I understand the
benefit of using Arrays with SMF Add-in functions like RCHGetYahooQuotes()
or smfGetOptionQuotes() but I find it quite cumbersome to manage a large
array which, from time to time, needs quite a few rows to be deleted (for
example at option expirations) ... o if I need to sort the array based on
certain parameters based outside of the array .... it is entirely possible
that I do not know some of the tricks that might exist .... any
suggestions? ... thanks in advance
....
>>>>>
>>>>
>>>>
>>>
>>>
>
>
>

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

2.1.: Re: Stock Screener

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

Wed Jan 18, 2012 9:27 am (PST)

I just went to barchart.com, select stocks, then selected screener and entered the filter information.

It does not require a subscription to get the resulting page. You can add many more scan criteria barchart

You might try MSN money, stockcharts.com or stockta.com they also offer free screeners

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Ashish Mukerji
Sent: Tuesday, January 17, 2012 11:47 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Stock Screener

Hi Kermit .... you seem to be using a script with barchart screener (ma_50d-gt-tech.ma_200d%3B&types=1) .... how do you get to that? ...obviously, I am missing something ... thx ...

Ashish
_____

From: Kermit W. Prather <kermitp@tampabay.rr.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, January 17, 2012 10:36 AM
Subject: RE: [smf_addin] Stock Screener

Try barchart.com or one of several online stock screeners.

http://www.barchart.com/my/screener/stock.php?menus=4-0; <http://www.barchart.com/my/screener/stock.php?menus=4-0;&filters=input-tech> &filters=input-tech.
ma_50d-gt-tech.ma_200d%3B&types=1

-----Original Message-----
From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> [mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On Behalf
Of lewglenn
Sent: Monday, January 16, 2012 4:39 PM
To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
Subject: [smf_addin] Stock Screener

I'm looking to set up a stock screener that reports all equities whose 50
Day SMA exceeds its 200 Day SMA. Has anyone in this group implemented
something like this?

Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (35)
2.2.: Re: Stock Screener

Posted by: "Ashish Mukerji" ashishkm@yahoo.com ashishkm

Wed Jan 18, 2012 2:49 pm (PST)

thx. for your response ... I was specifically referring to the second line

"ma_50d-gt-tech.ma_200d%3B&types=1" ..... this is what your email did include and looked to me like a

script that you needed to know ... I misunderstood ... thx. for the other links ...

>________________________________
> From: Kermit W. Prather <kermitp@tampabay.rr.com>
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, January 18, 2012 12:27 PM
>Subject: RE: [smf_addin] Stock Screener
>
>
>
>I just went to barchart.com, select stocks, then selected screener and entered the filter information.
>
>It does not require a subscription to get the resulting page. You can add many more scan criteria barchart
>
>You might try MSN money, stockcharts.com or stockta.com they also offer free screeners
>
>Kermit
>
>From:smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Ashish Mukerji
>Sent: Tuesday, January 17, 2012 11:47 AM
>To: smf_addin@yahoogroups.com
>Subject: Re: [smf_addin] Stock Screener
>
>
>
>
>
>Hi Kermit .... you seem to be using a script with barchart screener (ma_50d-gt-tech.ma_200d%3B&types=1) .... how do you get to that? ...obviously, I am missing something ... thx ...
>
>Ashish
>
>________________________________
>
>From:Kermit W. Prather <kermitp@tampabay.rr.com>
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, January 17, 2012 10:36 AM
>Subject: RE: [smf_addin] Stock Screener
>
>
>Try barchart.com or one of several online stock screeners.
>
>http://www.barchart.com/my/screener/stock.php?menus=4-0;&filters=input-tech.
>ma_50d-gt-tech.ma_200d%3B&types=1
>
>-----Original Message-----
>From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
>Of lewglenn
>Sent: Monday, January 16, 2012 4:39 PM
>To: smf_addin@yahoogroups.com
>Subject: [smf_addin] Stock Screener
>
>I'm looking to set up a stock screener that reports all equities whose 50
>Day SMA exceeds its 200 Day SMA. Has anyone in this group implemented
>something like this?
>
>Thanks.
>
>
>
>
>
>
>
>

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

3a.: Change in Yahoo Finance Format

Posted by: "Marty" mtopper@yahoo.com mtopper

Wed Jan 18, 2012 11:38 am (PST)

The following formula is no longer working (page has been reformatted)

=RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Index Value:")

Can I edit this formula to get the index value from the page?

thanks

Marty

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3b.: Re: Change in Yahoo Finance Format

Posted by: "Martin Topper" mtopper@yahoo.com mtopper

Wed Jan 18, 2012 11:49 am (PST)

Sorry.

Clearly I can't edit it correctly or i would have! :-(

The right question is "Can someone else edit it"?

thanks

________________________________
From: Marty <mtopper@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, January 18, 2012 2:38 PM
Subject: [smf_addin] Change in Yahoo Finance Format

The following formula is no longer working (page has been reformatted)

=RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Index Value:")

Can I edit this formula to get the index value from the page?

thanks

Marty

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3c.: Re: Change in Yahoo Finance Format

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

Wed Jan 18, 2012 12:13 pm (PST)

This appears to work, at least while the market is open:

=0+smfGetTagContent("http://finance.yahoo.com/q?s=
^DJI","span",-1,"yfs_l10_")

On Wed, Jan 18, 2012 at 12:38 PM, Marty <mtopper@yahoo.com> wrote:

> The following formula is no longer working (page has been reformatted)
>
> =RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Index Value:")
>
> Can I edit this formula to get the index value from the page?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3d.: Re: Change in Yahoo Finance Format

Posted by: "bizmark_ee" markpadden@hotmail.com bizmark_ee

Wed Jan 18, 2012 2:43 pm (PST)

They have definitely changed certain aspects of the page format. For example, to get the after-hours price, it used to be (as of 1 week ago) "yfs_l91_" one would use with smfGetTagContent; it seems to have changed to "yfs_l86_" as of this week.

Just passing along in case anyone else is trying to grab after hours prices.

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

4a.: Re: problem with smfGetADVFNElement

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

Wed Jan 18, 2012 2:25 pm (PST)

i think there is an advance.

just copy the advfn colum for like 300 lines in a spreadsheet.
and place this formula in colum ahead =IF(UPPER($C$3)=" ";"--";smfGetADVFNElement($C$3;"A";COLUMNS($D:D);">"&$C6&"<";;"--"))

then drag the formula down to ur botum and right to like 25 colums (you have in a split sec all advfn content for like 25 years back)

first rchelement do not even go that far back, second it is not very easy to select all the numbers and much more change on typos...

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Except that ElementNumber has the find strings externalized. So, when
> changes occur it's easier to correct.
>
> You are also less likely to make typos which create problems that are
> difficult to see :)
>
> But, thanks, glad to know it's just user preference rather than some
> inherent advantage.
>
> oh, and, for the record, I should have typed smfGetAdvFNElement below, not
> RCH...
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of Randy Harmelink
> Sent: Monday, January 16, 2012 6:42 PM
> To: smf_addin@yahoogroups.com
> Subject: Re: [smf_addin] Re: problem with smfGetADVFNElement
>
>
>
>
> To tell the truth, I prefer the first -- it's self-documenting.
>
> I almost got rid of the RCHGetElementNumber() function after I wrote
> RCHGetTableCell().
>
>
>
> On Mon, Jan 16, 2012 at 3:55 PM, Mike McQuaid <mikemcq802@...> wrote:
>
>
>
>
> How is this:
>
> =RCHGetAdvFNElement("IBM","A",1,"Net Cash from Total Operating Activities")
>
> better than this?
>
> =RCHGetElementNumber("IBM",6855)
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
4b.: Re: problem with smfGetADVFNElement

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Wed Jan 18, 2012 10:01 pm (PST)

Oh, I see now - that's pretty cool. I'd never used the COLUMNS function
before - that's a neat trick and very useful in that case.

Clearly if you need more than 10 years or quarters you need to do it that
way. Or, if you are retrieving a large group of different numbers it's
probably easier to type the name rather than look up the GetElementNumber
number for all of them.

And, I may start using it too some times so thanks.

Question though - is the trailing "<" really necessary? I think you could
eliminate that and still not have any problems - and would have avoided your
original problem. Randy, any comment?

If you only need 10 years you could use RCHGetElementNumber with the columns
function to make the typing easier. I'm not suggesting you do this since
you need more than 10 years, but, in case any others look this is another
way:

For example to get the last 10 annual Basic EPS numbers (number 5786 is the
GetElement number for it):

Put this formula in cell D4 with C3 having the value of your ticker:

=RCHGetElementNumber($C$3,5786+columns($d:d)-1)

Drag that across to the next right 9 columns and use the Edit/Fill function
(Ctrl-R).

It also works nice with ROWS going down with this formula in cell D8 for
example

=RCHGetElementNumber($C$3,5786+rows($8,8)-1)

Just drag it to the 9 rows below in the same column and Edit/Fill Down
(Ctrl-D).

Thanks

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of antonvanas1989
Sent: Wednesday, January 18, 2012 5:26 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: problem with smfGetADVFNElement

i think there is an advance.

just copy the advfn colum for like 300 lines in a spreadsheet.
and place this formula in colum ahead =IF(UPPER($C$3)="
";"--";smfGetADVFNElement($C$3;"A";COLUMNS($D:D);">"&$C6&"<";;"--"))

then drag the formula down to ur botum and right to like 25 colums (you have
in a split sec all advfn content for like 25 years back)

first rchelement do not even go that far back, second it is not very easy to
select all the numbers and much more change on typos...

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"Mike McQuaid" <mikemcq802@...> wrote:
>
> Except that ElementNumber has the find strings externalized. So, when
> changes occur it's easier to correct.
>
> You are also less likely to make typos which create problems that are
> difficult to see :)
>
> But, thanks, glad to know it's just user preference rather than some
> inherent advantage.
>
> oh, and, for the record, I should have typed smfGetAdvFNElement below, not
> RCH...
>
> _____
>
> From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
[mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
Behalf
> Of Randy Harmelink
> Sent: Monday, January 16, 2012 6:42 PM
> To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> Subject: Re: [smf_addin] Re: problem with smfGetADVFNElement
>
>
>
>
> To tell the truth, I prefer the first -- it's self-documenting.
>
> I almost got rid of the RCHGetElementNumber() function after I wrote
> RCHGetTableCell().
>
>
>
> On Mon, Jan 16, 2012 at 3:55 PM, Mike McQuaid <mikemcq802@...> wrote:
>
>
>
>
> How is this:
>
> =RCHGetAdvFNElement("IBM","A",1,"Net Cash from Total Operating
Activities")
>
> better than this?
>
> =RCHGetElementNumber("IBM",6855)
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
4c.: Re: problem with smfGetADVFNElement

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

Wed Jan 18, 2012 10:22 pm (PST)

In most cases, the trailing "<" isn't necessary. However, if you search for
">Inventories" without the trailing "<", you'll end up getting
">Inventories, Raw Materials" instead of the total of the various inventory
line items.

But it's definitely a rare situation.

On Wed, Jan 18, 2012 at 11:02 PM, Mike McQuaid <mikemcq802@yahoo.com> wrote:

> **
>
> Question though - is the trailing "<" really necessary? I think you could
> eliminate that and still not have any problems - and would have avoided
> your original problem. Randy, any comment?
>

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

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

Kamis, 19 Januari 2012

Messages In This Digest (14 Messages)

Messages

Posted by: "KailuaKid" Gary.Hartling@gmail.com garyhartling

Wed Jan 18, 2012 8:07 am (PST)

Posted by: "george" panax@fuse.net simon_of_iernot

Wed Jan 18, 2012 9:39 am (PST)

Posted by: "Ashish Mukerji" ashishkm@yahoo.com ashishkm

Wed Jan 18, 2012 2:55 pm (PST)

Posted by: "george" panax@fuse.net simon_of_iernot

Wed Jan 18, 2012 3:46 pm (PST)

Posted by: "Ashish Mukerji" ashishkm@yahoo.com ashishkm

Wed Jan 18, 2012 4:59 pm (PST)

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

Wed Jan 18, 2012 9:27 am (PST)

Posted by: "Ashish Mukerji" ashishkm@yahoo.com ashishkm

Wed Jan 18, 2012 2:49 pm (PST)

Posted by: "Marty" mtopper@yahoo.com mtopper

Wed Jan 18, 2012 11:38 am (PST)

Posted by: "Martin Topper" mtopper@yahoo.com mtopper

Wed Jan 18, 2012 11:49 am (PST)

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

Wed Jan 18, 2012 12:13 pm (PST)

Posted by: "bizmark_ee" markpadden@hotmail.com bizmark_ee

Wed Jan 18, 2012 2:43 pm (PST)

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

Wed Jan 18, 2012 2:25 pm (PST)

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Wed Jan 18, 2012 10:01 pm (PST)

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

Wed Jan 18, 2012 10:22 pm (PST)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me