Click here to Login





                                                   importing sectors and industries

  0

0
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

  0

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

  0

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

  0

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



No more messages
0




Reply:

No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"










QuantShare

Trading Items
Industry and Sector Information for the US Stock Market
Advancing-Declining Industries
Rank Industries based on the average Relative Strength Index
Staggered Entry and Exit Strategy
Historical EOD data for LSE-listed Stocks and ETFs

How-to Lessons
Difference between the watchlist and the screener tools
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
How to scale and move the chart Y-axis

Related Forum Threads
How do I setup Sectors and Industries since Yahoo no longer works...
Indicies and Sectors
Importing Trade Ticks from a .CSV
Can I update the sector and industry information in the stock dat...
Importing portfolio from a comma delimted file

Blog Posts
Industry Analysis - How to Compare Stocks with their Industries
New Ranking and Percentile Composite Functions
Diversify your portfolio by investing in stocks from various indu...
How to speed up quotes and news downloads
Backtesting chart patterns using the auto support and resistance ...









QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright 2021 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.