<t>Well if you like modelling in Excel it is very useful. Easy too learn too, especially with the automatic recording function. However, could not possibly believe that it would be useful as a prerequisite for a job. It's a tool, nothing more, nothing less.Beware of the VBA trap... "once learned VBA...

The great thing with the techniques is that you don't even need to rely on a SQL Server, it could be any db with OLE DB support. Watch out for locking, but that's a resposibility that comes with any system development of course.

<t>QuoteOriginally posted by: yuanche17Does anyone know if sql server 2000 allows a single query to inn-join tables which reside on two different database servers (not different databases, or tables, i.e. each has a unique server name and a workstation name) ?The preferred way is to use Replication,...

Won't Right-clicking on the cell, selecting 'Format cell' - category - 'Number' work?

<r>QuoteOriginally posted by: DrBenHave you looked at:<URL url="http://data.island.comThey">http://data.island.comThey</URL> have a (beta) Web service data feed at:<URL url="http://data.island.com/ds/dev/ws/beta/Interesting">http://data.island.com/ds/dev/ws/beta/Interesting</URL>, will immidiately h...

<t>I find the problem so far with xml standards are not the standards (the idea is great!) but with the slow pace with which the standard evolves.By the time a xml standard has been developed, 2 or more software product cycles by middleware companies has been completed and the standard is obsolete a...

[Dirty Harry] "We are coming to get you"[Robber] "Who's 'we' sucker??"[Dirty Harry] "Smith, Wesson and ME"

[Girl] "Hello, I'm Plenty"[Bond] "Well of course you are"

<r>skimania, I don't thint u can use New keyword together with With Events. You must first declare your object and instanciate it afterwords.Have a look at the office application event sample at:<URL url="http://msdn.microsoft.com/library/en-us/odeopg/html/deconworkingwithevents.asp?Hope"><LINK_TEXT...

<r>QuoteOriginally posted by: FDAXHunterWannabedude,You simply created a .NET wrapper for the COM API. Simple as that.<URL url="http://www.csharphelp.com/archives3/archive513.htmlhttp://msdn.microsoft.com/msdnmag/issues/01/08/Interop/And"><LINK_TEXT text="http://www.csharphelp.com/archives3/arc ... ...

<t>QuoteOriginally posted by: DominguesPlease... could I use Outlook Express or only the MS Outlook?If you use this code demonstrated you have to install Ms Outlook ;-/ What the code actually does is it starts outlook in the background and uses it to send an email.(which means you could use the outl...

Bomba,Have a look at Peter Jäckel's book "Monte carlo methods in finance". Theres a chapter devoted to the subject.Regards,

Bond,Some very good examples and thurrogh documentation can be found at:http://www.ipoglobal.biz/Interaction101.htmBest of luck !

<t>Here is an issue that keeps bugging me,Seems to me that the disctinction between normal and log normal distributions are not very clear when returns are analysed in literature.I've found the same approach in a two different VaR calculations (which leads me to some unresolved questions):Let R deno...

QuoteOriginally posted by: potatochipCan you analytically calc VaR if you want to 2. for nonlinear products, include convexityThe delta-gamma VaR approach could be used to account for convexity of non linear products, see the delta-gamma VaR thread on this topic.Regards