search

sahilgupta / sbi-fx-ratekeeper

This project downloads and stores the daily SBI forex rates in a CSV file enabling you to access historical rates, easily.
MIT License
83 stars 18 forks source link

Pulling Data Directly into Excel for a particular Date #3

Closed nipunmehar closed 1 year ago

nipunmehar commented 1 year ago

Great work Sahil and Shivam! This information has been really helpful. Can data be directly imported into an Excel sheet for a specific date? Doing so would enhance data accessibility.

sahilgupta commented 1 year ago

I am not sure, I follow, @nipunmehar. Can you please elaborate what you are trying to achieve?

Any of the CSV files can be imported into Excel where you can filter or do a VLOOKUP for specific dates.

nipunmehar commented 1 year ago

I have a excel sheet where I am tracking all my US holdings. What I am currently doing is searching here for exchange rates for individual dates for each of my holdings and then manually filing them in my excel sheet. I wondered if it was possible to directly populate data per date in my excel sheet from this repository.

sahilgupta commented 1 year ago

Got it.

You can have all the data in one Excel sheet /tab and cross-reference it from the holdings data using =VLOOKUP function, having date as the lookup key.

No need to manually fill.

nipunmehar commented 1 year ago

Thanks Sahil!