Have anyone here used this service from the NewsWire18 group "MarketWatch and StockScreener" ? They are providing almost 400 data fields for each symbol, covering almost all details about a given stock on a daily basis, as well as some of those fields in real time as well. Please check the link for the complete details.
Or if you are aware of ANY OTHER Service Provider who provides similar kind of data in EXCEL, then please post a link about them here.
Thanks a lot :cheers:
NW18 Market Watch & Stock Screener
Market Watch & Stock Screener
The NW18 MarketWatch and StockScreener are very sophisticated yet highly user friendly Excel based add-ins that will provide you a far richer experience in terms of user interface and analytical capabilities.
Some of the key features of these add-ins are:
Market Watch: Is a window of value-added and calculated data fields over 383 captured/calculated data points. Some of the notable ones are...
a) Beta for every stock against its primary index and 27 other indices
b) Live Market Cap, PE, Life highs & lows, Previous days values (O/H/L/C/OI/VOL)
c) Live 52 weeks, 26 weeks, 1 month and lifetime highs and lows.
d) Exact period and month end price performance (1 to 12 months) in absolute & percentage terms.
e) Indicators like Stocks nearing 52 Week/Life Highs or Lows
f) Average Price and Volume (e.g. 10,21,100,200 days)
g) Dividend adjusted arbitrage opportunity between cash and futures in absolute and percentage terms.
h) Arbitrage opportunity between cash symbols from two different exchanges in absolute and percentage terms.
i) Live Implied Volatilities (IVol), Theoretical Value (fair price), Option Greeks (Delta, Gamma, RHO, Theta, Vega) using B&S model
j) IVol calculated based on cash as underlying as well as futures as underlying
k) Financial Ratios
Stock Screener: Is your window of Analytics/Data mining. It has the ability to quickly filter companies as and when the market unfolds during the trading day, up to that very minute. Some of the notable predefined screeners are...
a) Price Performance (1 to 12 Month exact period and month end). E.g. shortlist companies whose share price has gone up by 50% in the last N months
b) Daily Performance (1 to 5 days) e.g. shortlist companies whose share price has risen 10% day on day every day for last N number of days
c) Stocks nearing 52 week highs or lows
d) Stocks that have posted news highs or lows today
e) Average price & Volume crossovers
f) Stocks opening with a gap up or a gap down
g) Stocks hitting upper and lower circuits
h) Advance/Decline Statistics not just for the entire exchange, but also for every index (includes up/down/unchanged companies count, volume and traded value).
i) User defined screener/queries: Ability to build complex filters using query builder wizard. E.g. shortlist companies with Low PE and High EPS, large capitalization, volume greater than 5 times previous volumes etc.
News Search in MarketWatch: Seamless access to up to the minute snapshot news, including huge amount of news history over 2 years.
a) Quick & easy news search on any selected companies (including multi select) from the watch lists.
b) Eliminate duplicate headlines from two different entitled wires, allowing us to display more relevant headlines
c) Quick and easy access to predefined news searches like industry, earnings, views etc. (centrally maintained)
Market Watch & Stock Screener
The NW18 MarketWatch and StockScreener are very sophisticated yet highly user friendly Excel based add-ins that will provide you a far richer experience in terms of user interface and analytical capabilities.
Some of the key features of these add-ins are:
Market Watch: Is a window of value-added and calculated data fields over 383 captured/calculated data points. Some of the notable ones are...
a) Beta for every stock against its primary index and 27 other indices
b) Live Market Cap, PE, Life highs & lows, Previous days values (O/H/L/C/OI/VOL)
c) Live 52 weeks, 26 weeks, 1 month and lifetime highs and lows.
d) Exact period and month end price performance (1 to 12 months) in absolute & percentage terms.
e) Indicators like Stocks nearing 52 Week/Life Highs or Lows
f) Average Price and Volume (e.g. 10,21,100,200 days)
g) Dividend adjusted arbitrage opportunity between cash and futures in absolute and percentage terms.
h) Arbitrage opportunity between cash symbols from two different exchanges in absolute and percentage terms.
i) Live Implied Volatilities (IVol), Theoretical Value (fair price), Option Greeks (Delta, Gamma, RHO, Theta, Vega) using B&S model
j) IVol calculated based on cash as underlying as well as futures as underlying
k) Financial Ratios
Stock Screener: Is your window of Analytics/Data mining. It has the ability to quickly filter companies as and when the market unfolds during the trading day, up to that very minute. Some of the notable predefined screeners are...
a) Price Performance (1 to 12 Month exact period and month end). E.g. shortlist companies whose share price has gone up by 50% in the last N months
b) Daily Performance (1 to 5 days) e.g. shortlist companies whose share price has risen 10% day on day every day for last N number of days
c) Stocks nearing 52 week highs or lows
d) Stocks that have posted news highs or lows today
e) Average price & Volume crossovers
f) Stocks opening with a gap up or a gap down
g) Stocks hitting upper and lower circuits
h) Advance/Decline Statistics not just for the entire exchange, but also for every index (includes up/down/unchanged companies count, volume and traded value).
i) User defined screener/queries: Ability to build complex filters using query builder wizard. E.g. shortlist companies with Low PE and High EPS, large capitalization, volume greater than 5 times previous volumes etc.
News Search in MarketWatch: Seamless access to up to the minute snapshot news, including huge amount of news history over 2 years.
a) Quick & easy news search on any selected companies (including multi select) from the watch lists.
b) Eliminate duplicate headlines from two different entitled wires, allowing us to display more relevant headlines
c) Quick and easy access to predefined news searches like industry, earnings, views etc. (centrally maintained)
Thanks a lot :cheers: