Display Sector and Industry in pivot table rows and in screens

Display Sector and Industry in pivot table rows and in screens

Kiran
2017-06-03 21:52:20

I tried Add Indicator->Database->company_desc-> sector / industry, which gives me this function GetDataCount('company_desc', 'sector');
But the function doesn't display industry or sector.

1) Do i have the right database and fields? My company_desc->sector field shows the industry and company_desc->industry shows a number.
How do i get the text names of sector and industry for all stocks?

2) How do i display the names in pivot table rows and screen rows? And use them as filters in strategies?

thanks
Kiran

QuantShare
2017-06-05 08:35:28

This is a custom database and any custom database is created either manually or by a downloader.

If you want to get the sector or industry of a security then you need to fill the sector/industry for each stock or use the "Symbol -> Auto Manage Symbols" tool. After that you can get that data using these functions industry() and sector()

Get more messages

No more messages

Back


Trading Items Industry and Sector Information for the US Stock Market Market Index for the Gold and Silver Industry Camarilla Pivot Points - Supports and Resistances Detect and Display Potential Splits on a Chart ETF Number of securities, percent stock and cash - Historical Dat...	How-to Lessons How to download and use U.S. stocks earnings data How to create and trade a Neural Network model How to scale and move the chart Y-axis How to save and restore charts How to backup your databases (EOD, Intraday, Tick and Custom) and...
Related Forum Threads Can I update the sector and industry information in the stock dat... Historic fundamental data and foreign stocks mktcap industry data Industy and Sector Folders importing sectors and industries Valuation, fundamental and dividends	Blog Posts How to Display the Year-to-Date Excess Return in a Pivot Table How to Calculate and Display the Bid/Ask Spread on a Chart How to predict and trade the stock market using pivot points Create a Pivot Table that displays the Relative Strength Index - ... How to create buy and sell trading rules based on News Data