mahkoh
1,065 posts
msg #100282
- Ignore mahkoh |
4/16/2011 4:16:11 PM
I recently created a csv file of stocks with high institutional ownership using finviz.com. I open the file in excel, copy the column that contains the symbols and paste these symbols into the symlist of a filter in SF.
Now if I want the filter to work I need to manually add a comma after every symbol in the symlist.
I believe there must be an easier way to do this, after all csv stands for "comma seperated value"?
Can anyone help me out? I use excel starter that came with my computer but would not mind switching to Open Office if my version of excel doen't support this.
|
four
5,087 posts
msg #100286
- Ignore four
modified |
4/16/2011 6:41:48 PM
Excel can add a comma between each symbol.
Please create this example.
Step 1 Column A [place symbols in column A]
MSFT
DELL
LLY
VZ
Step 2 Cell B1 [place a comma in cell B1]
,
Step 3 Cell C1 [place this formula in cell C1]
=A1&$B$1
Step 4 Cell C2 [place this formula in cell C2]
=C1&A2&$B$1
Step 5 Copy C2 down the column and the last cell in column C will be the string of symbols to use with StockFetcher
|
mahkoh
1,065 posts
msg #100288
- Ignore mahkoh |
4/16/2011 7:17:20 PM
Wonderful. Thanks a bunch, four.
|