Messages In This Digest (7 Messages)
- 1a.
- Re: Stock screener.xls ticket hypelink each symbol From: almondtree
- 1b.
- Re: Stock screener.xls ticket hypelink each symbol From: Randy Harmelink
- 2a.
- Auditor Info? From: john.sitarz
- 2b.
- Re: Auditor Info? From: Randy Harmelink
- 3a.
- shut off update on quarterly or annual data From: almondtree
- 3b.
- Re: shut off update on quarterly or annual data From: Mike McQuaid
- 3c.
- Re: shut off update on quarterly or annual data From: Randy Harmelink
Messages
- 1a.
-
Re: Stock screener.xls ticket hypelink each symbol
Posted by: "almondtree" almondtree@yahoo.com almondtree
Thu Dec 1, 2011 3:21 pm (PST)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Use the EXCEL HYPERLINK() function to create your own links in a "helper"
> column.
>
> On Mon, Nov 28, 2011 at 10:19 PM, almondtree <almondtree@...> wrote:
>
> > I like the cvs of FINVIZ stock screener.xls would like to click on a
> > ticker link it back to FinViz.com to check chart. It there a way to do this
> > in Excel 2010.
> >
>
Ifound this Macro on Yahoo Answers: It makes all tickers blue I don't know how insert a URL maybe you could have a look:
Sub ConvertToHyperlink()
Dim rng As Range
Set rng = Range("A6:A" & Cells _
(rows.Count, 1).End(xlUp).Row)
'Set rng = ActiveSheet.UsedRange
For Each cell In rng
cell.Select
If cell.Value <> "" Then
If Left(cell.Value, 7) = "http://" Then
URL = cell.Value
Else
URL = "http://" + cell.Value
End If
ActiveSheet.Hyperlinks. Add Anchor:=cell, _
Address:=URL, TextToDisplay:=cell.Value
End If
here:
Next
End Sub
- 1b.
-
Re: Stock screener.xls ticket hypelink each symbol
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Dec 1, 2011 5:37 pm (PST)
You would need to modify the "rng" and "URL" values to be what you need
them to be. Like I said, I personally prefer to use the hyperlink function
in a new column.
On Thu, Dec 1, 2011 at 4:21 PM, almondtree <almondtree@yahoo.com > wrote:
>
> Ifound this Macro on Yahoo Answers: It makes all tickers blue I don't know
> how insert a URL maybe you could have a look:
> Sub ConvertToHyperlink()
> Dim rng As Range
> Set rng = Range("A6:A" & Cells _
> (rows.Count, 1).End(xlUp).Row)
> 'Set rng = ActiveSheet.UsedRange
> For Each cell In rng
> cell.Select
> If cell.Value <> "" Then
> If Left(cell.Value, 7) = "http://" Then
> URL = cell.Value
> Else
> URL = "http://" + cell.Value
> End If
> ActiveSheet.Hyperlinks. Add Anchor:=cell, _
> Address:=URL, TextToDisplay:=cell.Value
> End If
> here:
> Next
> End Sub
>
>
>
> --------------------- --------- ------
>
> Yahoo! Groups Links
>
>
>
>
- 2a.
-
Auditor Info?
Posted by: "john.sitarz" john.sitarz@gmail.com john.sitarz
Thu Dec 1, 2011 3:28 pm (PST)
Is there a function that could return the auditor of mutual funds? Thanks.
- 2b.
-
Re: Auditor Info?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Dec 1, 2011 5:39 pm (PST)
Depends on the data source you have in mind? Sample URLs?
On Thu, Dec 1, 2011 at 4:28 PM, john.sitarz <john.sitarz@gmail.com > wrote:
> Is there a function that could return the auditor of mutual funds? Thanks.
>
- 3a.
-
shut off update on quarterly or annual data
Posted by: "almondtree" almondtree@yahoo.com almondtree
Thu Dec 1, 2011 3:40 pm (PST)
I don't know if this question has been asked before, but how to turn off different parts of Spreadsheets update.
- 3b.
-
Re: shut off update on quarterly or annual data
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Thu Dec 1, 2011 4:28 pm (PST)
I put a "Y" or "N" in one field and then use an IF statement on an equation
for that field. I then type Y or N to make it run or not.
Example
IF(A1="Y",RCHGetYahooQuotes( ...),#n/a)
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of almondtree
Sent: Thursday, December 01, 2011 6:40 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] shut off update on quarterly or annual data
I don't know if this question has been asked before, but how to turn off
different parts of Spreadsheets update.
- 3c.
-
Re: shut off update on quarterly or annual data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Dec 1, 2011 5:44 pm (PST)
As mentioned, you can use a toggle switch to indicate whether the data
should be retrieved. The disadvantage is that the data isn't available
except when you have the toggle switch on. Most people would prefer to have
the previously retrieved values available.
To have the previously retrieved values available, you'd have to replace
the formulas with their respective values.
For example, you could do something like the smfUpdateDownloadTable process
(see "Links" area of the group). However, this means you would have a table
of data available to you. To see it in another format, you'd need to pull
the data out of that table, either directly by cell reference, or via
something like a VLOOKUP() function.
Another alternative is to write your own VBA routine that either converts
formulas to values, or places the values directly in the workbook.
It all depends on what the specifics are of what you need to do.
On Thu, Dec 1, 2011 at 4:40 PM, almondtree <almondtree@yahoo.com > wrote:
> I don't know if this question has been asked before, but how to turn off
> different parts of Spreadsheets update.
>
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