Messages In This Digest (25 Messages)
- 1a.
- how to extrack text from ticker symbol From: wu_ming_sg
- 1b.
- Re: how to extrack text from ticker symbol From: wu_ming_sg
- 1c.
- Re: how to extrack text from ticker symbol From: dguillett1
- 1d.
- Re: how to extrack text from ticker symbol From: wu_ming_sg
- 1e.
- Re: how to extrack text from ticker symbol From: dguillett1
- 1f.
- Re: how to extrack text from ticker symbol From: Hong Chong NG
- 1g.
- Re: how to extrack text from ticker symbol From: Randy Harmelink
- 1h.
- Re: how to extrack text from ticker symbol From: Hong Chong NG
- 1i.
- Re: how to extrack text from ticker symbol From: wu_ming_sg
- 1j.
- Re: how to extract text from ticker symbol From: dguillett1
- 1k.
- Re: how to extrack text from ticker symbol From: Randy Harmelink
- 1l.
- Re: how to extrack text from ticker symbol From: Hong Chong NG
- 2a.
- How to extract a table from a site? From: aviadmfi
- 2b.
- Re: How to extract a table from a site? From: Randy Harmelink
- 3a.
- RCHGetyYahooHistory delivers Data without Decimalpoints From: deng3
- 3b.
- Re: RCHGetyYahooHistory delivers Data without Decimalpoints From: Randy Harmelink
- 4a.
- data element for busineeweek.com From: wu_ming_sg
- 4b.
- Re: data element for busineeweek.com From: Randy Harmelink
- 6a.
- Re: how to extract text from ticker symbol From: dguillett1
- 6b.
- Re: how to extract text from ticker symbol [1 Attachment] From: Hong Chong NG
- 7a.
- Re: Is there a way to get NYSE daily number of new highs and new low From: Jacob Jose
- 7b.
- Re: Is there a way to get NYSE daily number of new highs and new low From: Randy Harmelink
- 8.
- Get Yahoo Quotes From: sterob
Messages
- 1a.
-
how to extrack text from ticker symbol
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Aug 14, 2011 3:50 am (PDT)
Hi,
I am trying to start a new template from scratch.
Before I go into extracting data using SMI addin, I like to create a weblink in it that can link to the website for manual viewing first.
eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
How can I replace goog with a cell that would allows one to key in the ticker and goog will change accordingly? Just like your sample templates..
hong
- 1b.
-
Re: how to extrack text from ticker symbol
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Aug 14, 2011 5:03 am (PDT)
How do I use a cell to define the value (eg. goog) in the below hyperlink? I am not trying to use the addin yet, trying to pull up a website with the stock selected immediately.
http://investing.businessweek. com/research/ stocks/financial s/financials. asp?ticker= goog
--- In smf_addin@yahoogroups.com , "wu_ming_sg" <nghongchong@...> wrote:
>
> Hi,
>
> I am trying to start a new template from scratch.
>
> Before I go into extracting data using SMI addin, I like to create a weblink in it that can link to the website for manual viewing first.
>
> eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
>
> How can I replace goog with a cell that would allows one to key in the ticker and goog will change accordingly? Just like your sample templates..
>
> hong
>
- 1c.
-
Re: how to extrack text from ticker symbol
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Sun Aug 14, 2011 7:01 am (PDT)
Put this in the SHEET MODULE and change a3 to suit
Private Sub Worksheet_BeforeDoubleClick( ByVal Target As Range, Cancel As Boolean)
if Target.address<>range("a3").address then exit sub
ActiveWorkbook.FollowHyperlink Address:= _
"http://investing.businessweek. " & Targetcom/research/ stocks/financial s/financials. asp?ticker=
end sub
From: wu_ming_sg
Sent: Sunday, August 14, 2011 5:50 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] how to extrack text from ticker symbol
Hi,
I am trying to start a new template from scratch.
Before I go into extracting data using SMI addin, I like to create a weblink in it that can link to the website for manual viewing first.
eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
How can I replace goog with a cell that would allows one to key in the ticker and goog will change accordingly? Just like your sample templates..
hong
- 1d.
-
Re: how to extrack text from ticker symbol
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Aug 14, 2011 7:53 am (PDT)
I am a newbie here and I googled what you mentioned and it looks like you are talking about VBA which is way out of my level of understanding with Excel
I do appreciate your reply though. thanks!
--- In smf_addin@yahoogroups.com , "dguillett1" <dguillett1@...> wrote:
>
> Put this in the SHEET MODULE and change a3 to suit
>
> Private Sub Worksheet_BeforeDoubleClick( ByVal Target As Range, Cancel As Boolean)
> if Target.address<>range(“a3â€).address then exit sub
> ActiveWorkbook.FollowHyperlink Address:= _
> "http://investing.businessweek. " & Targetcom/research/ stocks/financial s/financials. asp?ticker=
> end sub
>
> From: wu_ming_sg
> Sent: Sunday, August 14, 2011 5:50 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] how to extrack text from ticker symbol
>
>
> Hi,
>
> I am trying to start a new template from scratch.
>
> Before I go into extracting data using SMI addin, I like to create a weblink in it that can link to the website for manual viewing first.
>
> eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
>
> How can I replace goog with a cell that would allows one to key in the ticker and goog will change accordingly? Just like your sample templates..
>
> hong
>
- 1e.
-
Re: how to extrack text from ticker symbol
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Sun Aug 14, 2011 8:20 am (PDT)
Send your file to me dguillett1@gmail.com and I'll put it in.
From: wu_ming_sg
Sent: Sunday, August 14, 2011 9:53 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: how to extrack text from ticker symbol
I am a newbie here and I googled what you mentioned and it looks like you are talking about VBA which is way out of my level of understanding with Excel
I do appreciate your reply though. thanks!
--- In mailto:smf_addin%40yahoogroups. com, "dguillett1" <dguillett1@ ...> wrote:
>
> Put this in the SHEET MODULE and change a3 to suit
>
> Private Sub Worksheet_BeforeDoubleClick( ByVal Target As Range, Cancel As Boolean)
> if Target.address<>range(“a3â€).address then exit sub
> ActiveWorkbook.FollowHyperlink Address:= _
> "http://investing.businessweek. " & Targetcom/research/ stocks/financial s/financials. asp?ticker=
> end sub
>
> From: wu_ming_sg
> Sent: Sunday, August 14, 2011 5:50 AM
> To: mailto:smf_addin%40yahoogroups. com
> Subject: [smf_addin] how to extrack text from ticker symbol
>
>
> Hi,
>
> I am trying to start a new template from scratch.
>
> Before I go into extracting data using SMI addin, I like to create a weblink in it that can link to the website for manual viewing first.
>
> eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
>
> How can I replace goog with a cell that would allows one to key in the ticker and goog will change accordingly? Just like your sample templates..
>
> hong
>
- 1f.
-
Re: how to extrack text from ticker symbol
Posted by: "Hong Chong NG" nghongchong@hotmail.com wu_ming_sg
Sun Aug 14, 2011 9:01 am (PDT)
[Attachment(s) from Hong Chong NG included below]
for a start, lets try B24 and J15 to automate with C5 being the Ticker cell.
thanks1
To: smf_addin@yahoogroups.com
From: dguillett1@gmail.com
Date: Sun, 14 Aug 2011 10:19:27 -0500
Subject: Re: [smf_addin] Re: how to extrack text from ticker symbol
Send your file to me dguillett1@gmail.com and I�ll put it
in.
From: wu_ming_sg
Sent: Sunday, August 14, 2011 9:53 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: how to extrack text from ticker
symbol
I am a newbie here and I googled what you mentioned and it looks like you
are talking about VBA which is way out of my level of understanding with
Excel
I do appreciate your reply though. thanks!
--- In mailto:smf_addin%40yahoogroups. com,
"dguillett1" <dguillett1@...> wrote:
>
> Put this in the SHEET
MODULE and change a3 to suit
>
> Private Sub
Worksheet_BeforeDoubleClick( ByVal Target As Range, Cancel As Boolean)
> if
Target.address<>range("a3").address then exit sub
>
ActiveWorkbook.FollowHyperlink Address:= _
> "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker=
& Target
> end sub
>
> From: wu_ming_sg
> Sent:
Sunday, August 14, 2011 5:50 AM
> To: mailto:smf_addin%40yahoogroups. com
> Subject: [smf_addin] how to extrack text from ticker symbol
>
>
> Hi,
>
> I am trying to start a new template from
scratch.
>
> Before I go into extracting data using SMI addin, I
like to create a weblink in it that can link to the website for manual viewing
first.
>
> eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
>
> How can I replace goog with a cell that would allows one to key in the
ticker and goog will change accordingly? Just like your sample
templates..
>
> hong
>
Attachment(s) from Hong Chong NG
1 of 1 File(s)
- 1g.
-
Re: how to extrack text from ticker symbol
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 14, 2011 10:39 am (PDT)
Just use regular EXCEL string concatenation:
"...string1..."&B1&". ..string2. .."
On Sun, Aug 14, 2011 at 3:50 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> I am trying to start a new template from scratch.
>
> Before I go into extracting data using SMI addin, I like to create a
> weblink in it that can link to the website for manual viewing first.
>
> eg. "
> http://investing.businessweek. com/research/ stocks/financial s/financials. asp?ticker= goog
> "
>
> How can I replace goog with a cell that would allows one to key in the
> ticker and goog will change accordingly? Just like your sample templates..
>
- 1h.
-
Re: how to extrack text from ticker symbol
Posted by: "Hong Chong NG" nghongchong@hotmail.com wu_ming_sg
Sun Aug 14, 2011 10:42 am (PDT)
eg. http://www.gurufocus.com/financials "&c5&"_print.php? symbol=
it won't work :(
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Sun, 14 Aug 2011 10:39:14 -0700
Subject: Re: [smf_addin] how to extrack text from ticker symbol
Just use regular EXCEL string concatenation:
"...string1..."&B1&". ..string2. .."
On Sun, Aug 14, 2011 at 3:50 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
I am trying to start a new template from scratch.
Before I go into extracting data using SMI addin, I like to create a weblink in it that can link to the website for manual viewing first.
eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
How can I replace goog with a cell that would allows one to key in the ticker and goog will change accordingly? Just like your sample templates..
- 1i.
-
Re: how to extrack text from ticker symbol
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Aug 14, 2011 10:51 am (PDT)
hi,
just an update, it works inside a formula...
eg. "=RCHGetTableCell("http://investing. businessweek. "&C5&"&dataset=com/businessweek /research/ stocks/financial s/financials. asp?ticker= cashFlow& period=A& currency= native",2, ">Cash from operations") "
but when I just want to use it as a hyperlink in a cell with no formula, it cannot work.
eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= $C$5
--- In smf_addin@yahoogroups.com , Hong Chong NG <nghongchong@...> wrote:
>
>
> eg. http://www.gurufocus.com/financials "&c5&"_print.php? symbol=
> it won't work :(
>
> To: smf_addin@yahoogroups.com
> From: rharmelink@...
> Date: Sun, 14 Aug 2011 10:39:14 -0700
> Subject: Re: [smf_addin] how to extrack text from ticker symbol
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Just use regular EXCEL string concatenation:
>
> "...string1..."&B1&". ..string2. .."
>
> On Sun, Aug 14, 2011 at 3:50 AM, wu_ming_sg <nghongchong@...> wrote:
>
>
>
> I am trying to start a new template from scratch.
>
>
>
> Before I go into extracting data using SMI addin, I like to create a weblink in it that can link to the website for manual viewing first.
>
>
>
> eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
>
>
>
>
> How can I replace goog with a cell that would allows one to key in the ticker and goog will change accordingly? Just like your sample templates..
>
- 1j.
-
Re: how to extract text from ticker symbol
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Sun Aug 14, 2011 12:10 pm (PDT)
[Attachment(s) from dguillett1 included below]
Not sure all got this so resending
I took a different approach. Anytime you change c5 symbol:
1. All formulas will change to that symbol
2. Your hyperlinks in b24 & b25 automatically change.
3. A defined name for the current symbol is created
=this is the macro I created
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> Range("c5").Address Then Exit Sub
'MsgBox [oldsym]
Dim oldsyma As String
oldsyma = [oldsym]
Application.DisplayAlerts = False
ActiveSheet.UsedRange. Replace oldsyma, Target
ActiveWorkbook.Names.Add Name:="oldsym" , RefersToR1C1: ="=""" & Target & """"
Range("B24").Hyperlinks( 1).Address = _
"http://investing.businessweek. " & Targetcom/research/ stocks/financial s/financials. asp?ticker=
Range("b25").Hyperlinks( 1).Address = _
"http://www.google.com/finance? " & Target & "&fstype=ii"q=NASDAQ:
Application.DisplayAlerts = True
End Sub
From: wu_ming_sg
Sent: Sunday, August 14, 2011 12:51 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: how to extrack text from ticker symbol
hi,
just an update, it works inside a formula...
eg. "=RCHGetTableCell("http://investing. businessweek. "&C5&"&dataset=com/businessweek /research/ stocks/financial s/financials. asp?ticker= cashFlow& period=A& currency= native",2, ">Cash from operations") "
but when I just want to use it as a hyperlink in a cell with no formula, it cannot work.
eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= $C$5
--- In mailto:smf_addin%40yahoogroups. com, Hong Chong NG <nghongchong@ ...> wrote:
>
>
> eg. http://www.gurufocus.com/financials "&c5&"_print.php? symbol=
> it won't work :(
>
> To: mailto:smf_addin%40yahoogroups. com
> From: rharmelink@...
> Date: Sun, 14 Aug 2011 10:39:14 -0700
> Subject: Re: [smf_addin] how to extrack text from ticker symbol
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Just use regular EXCEL string concatenation:
>
> "...string1..."&B1&". ..string2. .."
>
> On Sun, Aug 14, 2011 at 3:50 AM, wu_ming_sg <nghongchong@...> wrote:
>
>
>
> I am trying to start a new template from scratch.
>
>
>
> Before I go into extracting data using SMI addin, I like to create a weblink in it that can link to the website for manual viewing first.
>
>
>
> eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
>
>
>
>
> How can I replace goog with a cell that would allows one to key in the ticker and goog will change accordingly? Just like your sample templates..
>
Attachment(s) from dguillett1
1 of 1 File(s)
- 1k.
-
Re: how to extrack text from ticker symbol
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 14, 2011 12:18 pm (PDT)
See: http://www.info-stat.com/ XLConCat. htm
It's the ampersand that concatenates strings together, or strings with
cells.
Your last example has no concatenation, simply a single string.
On Sun, Aug 14, 2011 at 10:51 AM, wu_ming_sg <nghongchong@hotmail.com >wrote:
> hi,
>
> just an update, it works inside a formula...
>
> eg. "=RCHGetTableCell("
> http://investing.businessweek. "&C5&"&dataset=com/businessweek /research/ stocks/financial s/financials. asp?ticker= cashFlow& period=A& currency= native",2, ">Cash
> from operations")"
>
>
> but when I just want to use it as a hyperlink in a cell with no formula, it
> cannot work.
>
> eg. "
> http://investing.businessweek. com/research/ stocks/financial s/financials. asp?ticker= $C$5
> "
>
- 1l.
-
Re: how to extrack text from ticker symbol
Posted by: "Hong Chong NG" nghongchong@hotmail.com wu_ming_sg
Sun Aug 14, 2011 12:36 pm (PDT)
i still cant get it to work, how will you make it work please?
I tried putting the http://investing.businessweek. in one cell. (com/research/ stocks/financial s/financials. asp?ticker
Then I use =b24&c5, I got this, "http://investing.businessweek. ". But its not a hyperlink, just plain text.com/research/ stocks/financial s/financials. asp?ticker= ntes
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Sun, 14 Aug 2011 12:18:35 -0700
Subject: Re: [smf_addin] Re: how to extrack text from ticker symbol
See: http://www.info-stat.com/ XLConCat. htm
It's the ampersand that concatenates strings together, or strings with cells.
Your last example has no concatenation, simply a single string.
On Sun, Aug 14, 2011 at 10:51 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
hi,
just an update, it works inside a formula...
eg. "=RCHGetTableCell("http://investing. businessweek. "&C5&"&dataset=com/businessweek /research/ stocks/financial s/financials. asp?ticker= cashFlow& period=A& currency= native",2, ">Cash from operations") "
but when I just want to use it as a hyperlink in a cell with no formula, it cannot work.
eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= $C$5
- 2a.
-
How to extract a table from a site?
Posted by: "aviadmfi" yinonari@yahoo.com aviadmfi
Sun Aug 14, 2011 4:24 am (PDT)
I'm trying to read the financial numbers from this page for example https://robotdough.com/equities/ using the SMFreadtable function but it doesn't work. Can some assist me with that?TLV/AMRK/ balance-sheet/ quarter
Thanks!
Avi
- 2b.
-
Re: How to extract a table from a site?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 14, 2011 10:34 am (PDT)
Try:
=RCHGetHTMLTable("
https://robotdough.com/equities/ ","Cash andTLV/AMRK/ balance-sheet/ quarter
Equiv",-1,"",1)
...although the date headers are offset because of the way the table is
coded.
On Sun, Aug 14, 2011 at 4:23 AM, aviadmfi <yinonari@yahoo.com > wrote:
> I'm trying to read the financial numbers from this page for example
> https://robotdough.com/equities/ using theTLV/AMRK/ balance-sheet/ quarter
> SMFreadtable function but it doesn't work. Can some assist me with that?
>
- 3a.
-
RCHGetyYahooHistory delivers Data without Decimalpoints
Posted by: "deng3" diengelke@live.com dieterengelke
Sun Aug 14, 2011 5:20 am (PDT)
Hi Randy,
since a while R.CHGetyYahooHistory delivers Data without Decimalpoints.
e. g. it shows 123456 instead of 1234.56
Do you know a way to fix this?
Dieter Engelke
- 3b.
-
Re: RCHGetyYahooHistory delivers Data without Decimalpoints
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 14, 2011 10:35 am (PDT)
Example please -- what function parameters are you using?
On Sun, Aug 14, 2011 at 5:19 AM, deng3 <diengelke@live.com > wrote:
>
> since a while R.CHGetyYahooHistory delivers Data without Decimalpoints.
>
> e. g. it shows 123456 instead of 1234.56
>
> Do you know a way to fix this?
>
- 4a.
-
data element for busineeweek.com
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Aug 14, 2011 5:40 am (PDT)
Hi,
Any plans to do the data set for the following website?
http://investing.businessweek. com/businessweek /research/ stocks/financial s/financials. asp?ticker= NTES:US&dataset= cashFlow& period=A& currency= native
- 4b.
-
Re: data element for busineeweek.com
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 14, 2011 10:38 am (PDT)
Nope. I used to have businessweek elements, but they dropped almost
everything I had that was of interest to me. You can use the other functions
to extract the data though. For the most part, I've found that financial
statements just aren't worth the effort of defining the elements. Especially
since different companies can have different line items. And I've been
through a few instances where websites have changed their display of the
financial statements, and updating was almost impossible -- different line
items, combined line items, etc.
On Sun, Aug 14, 2011 at 5:40 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> Any plans to do the data set for the following website?
>
>
> http://investing.businessweek. com/businessweek /research/ stocks/financial s/financials. asp?ticker= NTES:US&dataset= cashFlow& period=A& currency= native
>
- 5a.
-
MAC?
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Aug 14, 2011 11:20 am (PDT)
Would your templates wowk in MAC? Just curious and I know nothing about MAC...
- 5b.
-
Re: MAC?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 14, 2011 12:19 pm (PDT)
As noted on the home page of the group -- "No Mac. No Open Office."
On Sun, Aug 14, 2011 at 11:20 AM, wu_ming_sg <nghongchong@hotmail.com >wrote:
> Would your templates wowk in MAC? Just curious and I know nothing about
> MAC...
>
- 6a.
-
Re: how to extract text from ticker symbol
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Sun Aug 14, 2011 11:49 am (PDT)
[Attachment(s) from dguillett1 included below]
I took a different approach. Anytime you change c5 symbol:
1. All formulas will change to that symbol
2. Your hyperlinks in b24 & b25 automatically change.
3. A defined name for the current symbol is created
=this is the macro I created
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> Range("c5").Address Then Exit Sub
'MsgBox [oldsym]
Dim oldsyma As String
oldsyma = [oldsym]
Application.DisplayAlerts = False
ActiveSheet.UsedRange. Replace oldsyma, Target
ActiveWorkbook.Names.Add Name:="oldsym" , RefersToR1C1: ="=""" & Target & """"
Range("B24").Hyperlinks( 1).Address = _
"http://investing.businessweek. " & Targetcom/research/ stocks/financial s/financials. asp?ticker=
Range("b25").Hyperlinks( 1).Address = _
"http://www.google.com/finance? " & Target & "&fstype=ii"q=NASDAQ:
Application.DisplayAlerts = True
End Sub
From: Hong Chong NG
Sent: Sunday, August 14, 2011 11:45 AM
To: dguillett1@gmail.com
Subject: RE: [smf_addin] Re: how to extract text from ticker symbol
nice Thanks!
are you able to link C24-25 to it as well?
And how about the formula in J15?
many thanks!
--------------------- --------- --------- --------- --------- -
From: dguillett1@gmail.com
To: nghongchong@hotmail.com
Subject: Re: [smf_addin] Re: how to extract text from ticker symbol
Date: Sun, 14 Aug 2011 11:41:00 -0500
try this. Enter ticker and Double click to goto the hyperlink
From: Hong Chong NG
Sent: Sunday, August 14, 2011 11:01 AM
To: dguillett1@gmail.com
Subject: FW: [smf_addin] Re: how to extrack text from ticker symbol
for a start, lets try B24 and J15 to automate with C5 being the Ticker cell.
thanks1
--------------------- --------- --------- --------- --------- -
To: smf_addin@yahoogroups.com
From: dguillett1@gmail.com
Date: Sun, 14 Aug 2011 10:19:27 -0500
Subject: Re: [smf_addin] Re: how to extrack text from ticker symbol
Send your file to me dguillett1@gmail.com and I�ll put it in.
From: wu_ming_sg
Sent: Sunday, August 14, 2011 9:53 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: how to extrack text from ticker symbol
I am a newbie here and I googled what you mentioned and it looks like you are talking about VBA which is way out of my level of understanding with Excel
I do appreciate your reply though. thanks!
--- In mailto:smf_addin@yahoogroups.com , "dguillett1" <dguillett1@...> wrote:
>
> Put this in the SHEET MODULE and change a3 to suit
>
> Private Sub Worksheet_BeforeDoubleClick( ByVal Target As Range, Cancel As Boolean)
> if Target.address<>range("a3").address then exit sub
> ActiveWorkbook.FollowHyperlink Address:= _
> "http://investing.businessweek. " & Targetcom/research/ stocks/financial s/financials. asp?ticker=
> end sub
>
> From: wu_ming_sg
> Sent: Sunday, August 14, 2011 5:50 AM
> To: mailto:smf_addin@yahoogroups.com
> Subject: [smf_addin] how to extrack text from ticker symbol
>
>
> Hi,
>
> I am trying to start a new template from scratch.
>
> Before I go into extracting data using SMI addin, I like to create a weblink in it that can link to the website for manual viewing first.
>
> eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
>
> How can I replace goog with a cell that would allows one to key in the ticker and goog will change accordingly? Just like your sample templates..
>
> hong
>
Attachment(s) from dguillett1
1 of 1 File(s)
- 6b.
-
Re: how to extract text from ticker symbol [1 Attachment]
Posted by: "Hong Chong NG" nghongchong@hotmail.com wu_ming_sg
Sun Aug 14, 2011 12:00 pm (PDT)
thanks for your help! I guess I need your add-in file as well..
To: nghongchong@hotmail.com
CC: smf_addin@yahoogroups.com
From: dguillett1@gmail.com
Date: Sun, 14 Aug 2011 13:48:36 -0500
Subject: Re: [smf_addin] Re: how to extract text from ticker symbol [1 Attachment]
[Attachment(s) from dguillett1 included below]
I took a different approach. Anytime you change c5 symbol:
1. All formulas will change to that symbol
2. Your hyperlinks in b24 & b25 automatically change.
3. A defined name for the current symbol is created
=this is the macro I created
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> Range("c5").Address Then Exit Sub
'MsgBox [oldsym]
Dim oldsyma As String
oldsyma = [oldsym]
Application.DisplayAlerts = False
ActiveSheet.UsedRange. Replace oldsyma, Target
ActiveWorkbook.Names.Add Name:="oldsym" , RefersToR1C1: ="=""" & Target
& """"
Range("B24").Hyperlinks( 1).Address = _
"http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker=
& Target
Range("b25").Hyperlinks( 1).Address = _
"http://www.google.com/finance? "q=NASDAQ:
& Target & "&fstype=ii"
Application.DisplayAlerts = True
End Sub
From: Hong Chong NG
Sent: Sunday, August 14, 2011 11:45 AM
To: dguillett1@gmail.com
Subject: RE: [smf_addin] Re: how to extract text from ticker
symbol
nice Thanks!
are you able to link C24-25 to it as well?
And how about the formula in J15?
many thanks!
From: dguillett1@gmail.com
To: nghongchong@hotmail.com
Subject: Re:
[smf_addin] Re: how to extract text from ticker symbol
Date: Sun, 14 Aug 2011
11:41:00 -0500
try this. Enter ticker and Double click to goto the hyperlink
From: Hong Chong NG
Sent: Sunday, August 14, 2011 11:01 AM
To: dguillett1@gmail.com
Subject: FW: [smf_addin] Re: how to extrack text from ticker
symbol
for a start, lets try B24 and J15 to automate with C5 being the
Ticker cell.
thanks1
To: smf_addin@yahoogroups.com
From: dguillett1@gmail.com
Date: Sun, 14 Aug
2011 10:19:27 -0500
Subject: Re: [smf_addin] Re: how to extrack text from
ticker symbol
Send your file to me dguillett1@gmail.com and I�ll put it
in.
From: wu_ming_sg
Sent: Sunday, August 14, 2011 9:53 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: how to extrack text from ticker
symbol
I am a newbie here and I googled what you mentioned and
it looks like you are talking about VBA which is way out of my level of
understanding with Excel
I do appreciate your reply though.
thanks!
--- In mailto:smf_addin@yahoogroups.com ,
"dguillett1" <dguillett1@...> wrote:
>
> Put this in the SHEET
MODULE and change a3 to suit
>
> Private Sub
Worksheet_BeforeDoubleClick( ByVal Target As Range, Cancel As Boolean)
> if
Target.address<>range("a3").address then exit sub
>
ActiveWorkbook.FollowHyperlink Address:= _
> "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker=
& Target
> end sub
>
> From: wu_ming_sg
> Sent:
Sunday, August 14, 2011 5:50 AM
> To: mailto:smf_addin@yahoogroups.com
> Subject: [smf_addin] how to extrack text from ticker symbol
>
>
> Hi,
>
> I am trying to start a new template from
scratch.
>
> Before I go into extracting data using SMI addin, I
like to create a weblink in it that can link to the website for manual viewing
first.
>
> eg. "http://investing.businessweek. "com/research/ stocks/financial s/financials. asp?ticker= goog
>
> How can I replace goog with a cell that would allows one to key in the
ticker and goog will change accordingly? Just like your sample
templates..
>
> hong
>
- 7a.
-
Re: Is there a way to get NYSE daily number of new highs and new low
Posted by: "Jacob Jose" pepecan47@yahoo.ca pepecan47
Sun Aug 14, 2011 12:01 pm (PDT)
I use SMF-Template-Barchart- Market-Momentum. xls from the files area to get market momentum information.
Randy, do you know why the values in this spreadsheet are different than the ones in http://unicorn.us.com/advdec/
Regards,
Jose L. Jacob
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Saturday, August 13, 2011 11:46:35 AM
Subject: Re: [smf_addin] Is there a way to get NYSE daily number of new highs and new lows?
Take a look at http://unicorn.us.com/advdec/
On Sat, Aug 13, 2011 at 6:58 AM, Tze Wei, <tzewei_79@yahoo.com.sg > wrote:
>May I know if we can get NYSE daily number of new highs and new lows?
>
- 7b.
-
Re: Is there a way to get NYSE daily number of new highs and new low
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 14, 2011 12:22 pm (PDT)
No idea, but take a look at the "About" tab at http://unicorn.us.com/advdec
On Sun, Aug 14, 2011 at 12:01 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> I use SMF-Template-Barchart- Market-Momentum. xls from the files area to get
> market momentum information.
>
> Randy, do you know why the values in this spreadsheet are different than
> the ones in http://unicorn.us.com/advdec/
>
>
- 8.
-
Get Yahoo Quotes
Posted by: "sterob" anticato124@gmail.com sterob_469
Sun Aug 14, 2011 1:09 pm (PDT)
In the documentation for the RCHGetYahooQuotes function, it says that the codes listed are the most commonly used. Does that mean that there are codes to use the function for other data on the Yahoo Key Statistics page? If so, could you tell us what they are?
Thanks
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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