I was a summer this last year and between going back FT, I am working at a HF. My question is: what is the CIQ input to get updated info on the USDCNY exchange rate for excel? I tried +CIQ(USDCNY), as well as a few other combinations, but no dice. I learned it this summer but have since forgotten it...
Thanks in advance!
| +270 | Earliest you can get fired | 58 | 15h |
| +251 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 47 | 18h |
| +238 | Investment Banking is Divine | 40 | 11h |
| +223 | Career Crossroads | 31 | 1d |
| +213 | US 2027 SA IB worried about background check | 53 | 7h |
| +207 | Another $115bn Mega deal for these banks. Congrats! | 45 | 12h |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 1d |
| +122 | Is UBS really that bad? | 38 | 10h |
| +39 | Is Houston SA 28 recruiting already over? | 33 | 13h |
| +26 | 2026-27 IB Energy Top Banks | 8 | 14h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+CIQ("$USDCNY","IQ_LASTSALEPRICE","11/08/2010")
Would make quick updates easier if you reference cells vs. hardcoding as shown above.
Sit dolore non pariatur quas perspiciatis quam ab. Rerum enim autem perferendis nihil ut maiores aspernatur. Saepe maxime sunt ut quis. Reprehenderit ipsa aperiam ut quia ut neque iste sint. Et illo suscipit dolorem eos non. Unde iure reprehenderit ea accusantium.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...