importing sectors and industries

importing sectors and industries

ivanf
2017-04-11 08:03:20

HI all,

there's a few very old threads regarding importation of sectors , the finviz downloader was the answer to one, however if you don't have a finviz premium account
then the downloader cant work.

I'm importing my own data from metastock, I also have data from AAII's SIPro which provides me with symbol, fullname, industry , sector ,market

Using symbol-> import symbols from a file
So far I can import everything except the sector .
I would like to map the industries to a sector and preferably not doing it by hand via symbol->categories->sector

Can anyone help with a downloader which can import a CSV file containing a column representing sectors ?
so this is what my csv looks like

|symbol|fullname|industry|sector|market|

so as previously stated, its the sector info I cant import as there is no sector field in the dbase for me to map the column to

thanks
Ivan
Disclaimer: coding skills non existent

QuantShare
2017-04-12 01:55:07

Hi Ivan,

Unfortunately, there is no way to import the sector directly. You can either use "Tools -> Script Editor" or do it manually by associating an industry to a sector (not a ticker to a sector) in "Symbol -> Categories".

jason
2017-08-06 07:48:42

Hi,

Facing the same issue from time to time...

How would you use the script editor to update the sectors? An example would be great.

Thanks

QuantShare
2017-08-06 09:08:02

Use "Symbols.AddSector" to add a sector.
Use "Symbols.AddIndustry" to add an industry and associate it with a sector.

Get more messages

No more messages

Back


Trading Items Industry and Sector Information for the US Stock Market Advancing-Declining Industries Rank Industries based on the average Relative Strength Index Large price and volume gain after consolidation Horizontal Line - Changes by Value and Percentage	How-to Lessons Difference between the watchlist and the screener tools How to download EOD quotes for active and valid stocks only How to create trading rules based on Put and Call volume data How to plot support and resistance lines automatically How to create and trade a Neural Network model
Related Forum Threads How do I setup Sectors and Industries since Yahoo no longer works... Indicies and Sectors Importing Trade Ticks from a .CSV How do you retrieve the entry and exit price for a position? Can one add a vector of price and trade signals and get a backtes...	Blog Posts Diversify your portfolio by investing in stocks from various indu... Industry Analysis - How to Compare Stocks with their Industries New Ranking and Percentile Composite Functions Download historical EOD data for the stock, futures, ETF and Fore... Different Types of Trading Indicators: Trend, Momentum, Volatilit...