Friday, April 7, 2017

cvs to symbol list 4

get list

first u need to paste a cvs file into the input

this was just a little test because the output from the final v had an extra comma on the end ... turns out when i copied the cvs the text editor had added a line

these programs splits the cvs by line feeds. i get my cvs lists from Finviz. (u need the Elite account to get the lists). the Finviz cvs listing for a symbol looks like this: 25,"YGE","Yingli Green Energy Holding Company Limited","Technology","Semiconductor - Specialized","China",51.92,,2.84,-3.26%,327824. to get the symbol we split by ",", then split the first element by " and the second element of that array is the symbol. Your cvs could be different, so this is only "assured" to work with a Finviz cvs.

No comments:

Post a Comment