It explains the method I will show you and one where you will need a Windows device and a currency API key. If you want to know how to work with an API, check out this article. However, using an API will give you more accurate data. The good news is that you won’t need an API key for this. This method relies on Excel’s Stock feature. Let’s get started! The step-by-step guide for getting currency data in Excel However, there is one method to get currency data in Excel, no matter what device you are working with, and that is what I will show you today. What led me to Google Sheets in the first place was that I am using a Macbook, and I could not find an easy solution to getting real-time data in Excel with it. In it, I described how to get real-time currency data into Google Sheets (if you are interested, you can find it here). But I really hope that is not the main thing you got from the article. If you have seen my last article, you will know that spreadsheets and I have a somewhat ambivalent relationship.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |