Messages In This Digest (4 Messages)
- 1a.
- Re: Fw: Re: Yahoo Finance "Last Trade"cell From: randy tofsrud
- 1b.
- Re: [Bulk] Re: [smf_addin] Fw: Re: Yahoo Finance "Last Trade"cell From: Mike McQuaid
- 2.1.
- Re: Stock Screener From: Kermit W. Prather
- 2.2.
- Re: Stock Screener From: Ashish Mukerji
Messages
- 1a.
-
Re: Fw: Re: Yahoo Finance "Last Trade"cell
Posted by: "randy tofsrud" rst66@yahoo.com rst66
Tue Jan 17, 2012 6:03 am (PST)
Randy,
Apologies for my thick headedness, but I am still lost.
Let me go back to the basics - how do I point the formula that you sent me to a particular stock ticker? In my spreadsheet I do have a cell (B211) that consists of the string OTEX but I also do not understand how the formula would grab the data for any ticker the way that it is. I must need to point it to a specific ticker?
Thank You,
--- On Tue, 1/17/12, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] Fw: Re: Yahoo Finance "Last Trade"cell
To: smf_addin@yahoogroups.com
Date: Tuesday, January 17, 2012, 12:13 AM
Sigh.
The "&" operator is a concatenation symbol. It is used to concatenate a string to the contents of a worksheet cell, or multiple strings. If you are going to use a literal value, you need to make it a string. This is an EXCEL process, not an add-in one.
As you have it, it is looking for a worksheet cell named OTEX.
On Mon, Jan 16, 2012 at 10:02 AM, randy tofsrud <rst66@yahoo.com > wrote:
=0+smfGetTagContent("http://finance. yahoo.com/ "&OTEX,"span"q?s= ,-1,"yfs_ l84_otex" )
I have tried removing one and then the other "OTEX" ticker symbols but it still doesn't work.
I would like to be able to use the correct formula in 2 different spreadsheets in which I formerly used the "Last Trade" cell.
- 1b.
-
Re: [Bulk] Re: [smf_addin] Fw: Re: Yahoo Finance "Last Trade"cell
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Tue Jan 17, 2012 6:14 am (PST)
Ok, I'll try once.
The first parameter of the TagContent function is the url address of the
webpage in string format.
if you do it like below then excel will concatenate the *contents* of cell
A1 to the previous string. The & is a concatenation operator just like +,
-, ^, and all the mathemetical ones - it just operates on strings.
"http://finance.yahoo.com/ "&A1q?s=
So, if A1 contains OTEX the string results as:
http://finance.yahoo.com/ q?s=OTEX
The way you had it with &OTEX meant excel looked for a cell named OTEX to
attach its contents to the previous part of the string. Unless you had such
a named cell, the formula would give a #NAME error.
If you don't understand excel string processing and concatenation, google
can show you many helpful articles.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of randy tofsrud
Sent: Tuesday, January 17, 2012 9:03 AM
To: smf_addin@yahoogroups.com
Subject: [Bulk] Re: [smf_addin] Fw: Re: Yahoo Finance "Last Trade"cell
Randy,
Apologies for my thick headedness, but I am still lost.
Let me go back to the basics - how do I point the formula that you sent me
to a particular stock ticker? In my spreadsheet I do have a cell (B211) that
consists of the string OTEX but I also do not understand how the formula
would grab the data for any ticker the way that it is. I must need to point
it to a specific ticker?
Thank You,
--- On Tue, 1/17/12, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] Fw: Re: Yahoo Finance "Last Trade"cell
To: smf_addin@yahoogroups.com
Date: Tuesday, January 17, 2012, 12:13 AM
Sigh.
The "&" operator is a concatenation symbol. It is used to concatenate a
string to the contents of a worksheet cell, or multiple strings. If you are
going to use a literal value, you need to make it a string. This is an EXCEL
process, not an add-in one.
As you have it, it is looking for a worksheet cell named OTEX.
On Mon, Jan 16, 2012 at 10:02 AM, randy tofsrud <rst66@yahoo.com > wrote:
=0+smfGetTagContent("http://finance. yahoo.com/ "&OTEX,"span"q?s= ,-1,"yfs_ l84_
otex")
I have tried removing one and then the other "OTEX" ticker symbols but it
still doesn't work.
I would like to be able to use the correct formula in 2 different
spreadsheets in which I formerly used the "Last Trade" cell.
- 2.1.
-
Re: Stock Screener
Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra
Tue Jan 17, 2012 7:36 am (PST)
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.
- 2.2.
-
Re: Stock Screener
Posted by: "Ashish Mukerji" ashishkm@yahoo.com ashishkm
Tue Jan 17, 2012 8:46 am (PST)
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.
>
>
>
>
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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
Tidak ada komentar:
Posting Komentar