<t>It is often said if US economy can avoid a hard-landing or achieve a soft-landing...who decide that it is hard or soft? Do we just look at DJI? GDP? FX? etc?Which period in history was there a hard-landing?Looking back at the DJI, I can only spot a sharp dn fall on black Monday...suddenly I feel ...

<t>inflation and economic growth hv yet again be the latest debate for central bankers, would like your 2cents on this funny situation in Singapore, - inflation up (1.3% ->4.2%--> heading abv 5%)- interest rate lowered (3M 2.5% -> 1.8%)- Gradual Ccy appreciating policy (USDSGD 1.46 -> 1.435)- tight ...

Hi,THANK YOU! It works!Cheers

<t>Hi experts!My company is using Excel 97, Windows NT. I know that in later version of Excel, there is this Personal.xls where Global macro can be kept.This workbook would be loaded automatically everytime we open an Excel applicationAny macro kept in this workbook will be available globally for th...

<t>Hi,If my Excel file (e.g 123.xls) is linked to another excel file (e.g ABC.xls, with opening password protection). Whenever I open 123.xls and "yes" to update links, it would prompt me to key in password for ABC.xlsIs there a way to write a macro to refresh such links with password included? so t...

<t>Hmmm... I got your idea.Well, I'm actually plotting x-axis = Daily P/L changes; y-axis = No. of DaySo the P/L will be in terms of e.g blocks of [-500--400], [-400--300]...[400-500]and what I have will be bar chart of no of days that the changes in P/L fall into this blocks...and I need a normal b...

HiThanks for the tips!!! I'm able to get a bell curve.Say if I have an observation of 300days and the Daily changes in P/L range from+/-500,000Just wonder, how do you determine the value of RStDev to use.Thanks again!

<t>Hi,I'm trying to plot a chart showing Distribution of Daily Changes in P/L together with a Normal bell curve to show the distribution is normal.BUT I can't seems to plot a normal bell curve, the curve around Prob(0.5) is not smooth but rather linear thus my curve look more pointed than bell. I di...

<t>Hi , Anyone there familiar with OPICS/ANALYTICS by MKI Frustum?My dept is working on implementing VaR using the module ANVR, however I can’t seen to get the result calculated by the system. Would appreciate your helpI tried to calculate the VaR on a single dealE.G Short USD 10 million @ 2% for 1y...

<t>Hi Onuk,Yeah, YOU GOT ME RIGHT. I'm trying to extract details of new, delete/ change from different tables with same fieldsI have used Access to get the details I wanted. Just that whenever I got different tables (i.e with different fields) I need to create a new Access file again, and I don't li...

<t>Hi,Dunno if this has been discuss before:I’ve been using Microsoft Access to extract new, delete and change details from 2 database (e.g Jun02 and May02) that contains say details of Customer name, code, ccy, amt, …etcHowever, I find the process of creating the Access file rather tedious (as I’m ...

Yeah that solves my problem.I often read with delight the topic discuss in Wilmott forumsIt's really a good learning place for amateur like me ... DO keep the discussion alive!!!Cheers

<t>Hi Anthony n Yuka,Thanks for your helpful tips. I manage to get the graph I need w/o creating any extra column:-)However, I'm a bit puzzledEvaluate formula uses e.g EVALUATE(Sheet1!$C$3&"+X*0")(where Sheet1!$C$3 contains the formula) I don't quite understand the usage of : &"+X*0"I manage...

Hi,I'd like to know if there is a way to mirror the graph on the x-axis without adding a minus sign to the original data.i.e if I've a +VaR data, could I plot a -VaR data on the chart without adding another colum to my worksheetThanks!!!

To become a more powerful entity like AMIR, I think PRMIA and GARP should merge to form one entity again! Nevermind abt the the difference opinion on profit/non-profit organisation... ask what they can do to boost the Risk Mgmt industry