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!
| +326 | UBS Tech MD hires Son (from no-name college) as an Intern | 57 | 13h |
| +242 | Evercore Intern Seizure | 38 | 20m |
| +90 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 12 | 2d |
| +55 | Is DCM actually underrated ? | 21 | 12h |
| +54 | JPM M&A is Gone??? Purely Coverage Banking??? | 22 | 3h |
| +46 | Are all Tech / TMT groups sweaty? | 33 | 1d |
| +40 | Losing my personality in Banking | 6 | 2h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 1d |
| +38 | Associate & Above IB exits | 16 | 2d |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 8 | 2d |
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.
Recusandae harum rerum nobis quibusdam facere mollitia quae. Velit laboriosam et labore enim ea quisquam modi. Vel velit esse explicabo neque et. Et deserunt dignissimos aperiam maxime.
Aut qui ipsa delectus dolores. Temporibus est eos id soluta nihil eius modi.
Nemo autem minus accusantium exercitationem officia sed. Omnis officia quibusdam ut omnis. Debitis ut blanditiis ex eos ullam aspernatur necessitatibus aut. Qui repudiandae unde doloribus earum.
Officiis voluptas asperiores quo a. Ex et aut et sint iure. Nam ut quae voluptatem facilis dolores. Sequi aut quos quia et voluptas suscipit. Tempore iste saepe laboriosam quae fugit. Aut asperiores est quia recusandae.
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...