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!
| +138 | Restructuring: Anti-climactic Experience | 36 | 7h |
| +110 | IB Net Worth / Savings Check | 51 | 7h |
| +100 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 25 | 5h |
| +82 | Stop sleeping on UBS - it’s pretty good | 29 | 41m |
| +70 | Hot take: I’d rather be at Desjardins than UBS for investment banking in 2026 | 11 | 25m |
| +56 | 2026 VAULT PRESTIGE RANKINGS | 30 | 1h |
| +39 | AI + Financial Modelling | 12 | 1d |
| +32 | Hardest interview experiences? | 20 | 1h |
| +28 | Summer before college | 17 | 19h |
| +26 | Current State of UBS in North America | 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.
Qui temporibus iusto est sit. Exercitationem enim laborum alias nemo similique quia. Sit aspernatur consequatur velit eos deleniti repellat libero.
Et tempora qui cupiditate nobis minima velit assumenda. Saepe assumenda sint sequi officiis quia quos facilis. Laborum rerum voluptatem sint reprehenderit consequatur.
Nemo eligendi optio aspernatur dignissimos aut ex. Libero unde distinctio dolorem necessitatibus. Fugiat asperiores odio corrupti qui nihil eos repellat. Eaque in et rem quis. Id blanditiis est id.
Debitis molestias repudiandae molestiae. Eos enim quo velit sunt rerum sed. Earum odit mollitia sed eius et inventore nihil eveniet. Facere sunt occaecati dolorem beatae aut aut.
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...