StockFetcher Forums · Filter Exchange · importing csv files<< >>Post Follow-up
988 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 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.

4,371 posts
msg #100286
Ignore four
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]


Step 2 Cell B1 [place a comma in cell B1]

Step 3 Cell C1 [place this formula in cell C1]


Step 4 Cell C2 [place this formula in cell C2]


Step 5 Copy C2 down the column and the last cell in column C will be the string of symbols to use with StockFetcher

988 posts
msg #100288
Ignore mahkoh
4/16/2011 7:17:20 PM

Wonderful. Thanks a bunch, four.

StockFetcher Forums · Filter Exchange · importing csv files<< >>Post Follow-up

*** Disclaimer *** does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. does not recommend particular securities., Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.

Copyright 2018 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus