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!
| +462 | Don’t work at UBS - UBS Sucks | 47 | 11h |
| +226 | Should My Intern Get a Return Offer? | 58 | 1d |
| +65 | Getting Laid in IB? | 28 | 1d |
| +62 | Intern keeps sleeping at work - what to tell them | 27 | 14m |
| +56 | F*ck it I'm Going to Med School | 22 | 36m |
| +55 | Incompetent and annoying co-intern | 21 | 7h |
| +51 | Living in greenwich as an analyst? | 9 | 1d |
| +35 | Nauseous every morning for past 3 years in IB, anyone else? | 21 | 17h |
| +35 | Quick Thoughts on CVC AI Sale Process | 6 | 12h |
| +33 | NYC Associate Budget | 13 | 13h |
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.
Ut est magnam iure rem dolor et repellendus. Adipisci non ullam voluptas ea ipsa libero quos. Sit eius autem est recusandae rem natus. Earum dolore omnis cum vitae earum sit.
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...