Anyone knows how to update "Market" category for all stocks in existing db?
Tried updating using a csv which has 2 columns (a.)TICKER (b.)MARKET
I tried using the format to import :
-------------
$FORMAT TICKER,MARKET
$SEPARATOR ,
$SKIPLINES 1
$NOQUOTES 1
-------------
But the Market remains "NYSE".
I do not have it in me to update "Market" for 100's of scrips, individually.
Could someone please inform or point in the right direction?
Very much appreciate any help!
Thanks
Tried updating using a csv which has 2 columns (a.)TICKER (b.)MARKET
I tried using the format to import :
-------------
$FORMAT TICKER,MARKET
$SEPARATOR ,
$SKIPLINES 1
$NOQUOTES 1
-------------
But the Market remains "NYSE".
I do not have it in me to update "Market" for 100's of scrips, individually.
Could someone please inform or point in the right direction?
Very much appreciate any help!
Thanks