euroTRIN

[vengeance]

Does anyone have an idea how to go about constructing a NYSE TRIN type indicator for the eurostoxx50 in realtime (using excel and esignal)?

Not sure if it would be as useful as the TRIN, since sentiment areas wouldn't be widely known, and followed (eg. .5-1.0 TRIN indicates more likely than not that both long and short day setups may provide good RR).

Any guidance would be greatly appreciated.

p.s. if the esignal guys would be so kind as to toss a spreadsheet my way that would be super.

[ScottJ]

Euro Trin

Unfortunately, we aren't currently building and maintaining the component breakdowns for each index. They can be quite time-consuming, as you are probably well aware. It's something we'd like to eventually do or have other users assist with. In case it helps, I did find a pdf for the current symbols that compose the Stoxx 50 here:

http://www.stoxx.com/indexes/factsheets.html

Thanks.

[vengeance]

how to

Thanks ScottJ.

If anyone is interested, here's a response from another helpful soul from the Wilmott forum.

The TRIN is calculated as:

((Advancing issues/declining issues) / (advancing volume/declining
volume))

So basically you need for the 50 constituents:
- Difference to yesterday (if that is greater than 0, it is an
advancing issue, else a declinging issue)
- The days Cumulative Volume

Then simply for all the decliners, add their volumes up, same for
the advancers, and plug those numbers in the above formula.
Done.
--

The programming aspect remains to be figured out.