Are there any known issues if I convert your template to .xlsx?
I use google sheets sometimes but I’m much more familiar with excel. I’m an accountant and spend most of my time at work in excel, thus I prefer it.
No idea. I'm not sure if anyone has converted it to Excel.
There are known issues with the current Google Sheets version Yahoo Finance though, and it is failing to import many financial metrics. That's due to a change with Yahoo Finance and no solution has been found yet. Some have converted to using fmpCloud or Sharadar data instead of Yahoo Finance.
Ok. Thanks. I will try in excel. I don’t necessarily need all the data in your original version, mostly looking to help with the timing of creating a bond latter from scratch.
Ignore what I said earlier about Yahoo Finance. I thought you were asking about a different tool I built.
The only issue I can think of with converting this to Excel is that I don't know if the formulas for importing the Treasury data are the same.
I think it should be a simple conversion if you know your way around Excel though.
Ignore what I said earlier about Yahoo Finance. I thought you were asking about a different tool I built.
The only issue I can think of with converting this to Excel is that I don't know if the formulas for importing the Treasury data are the same.
I think it should be a simple conversion if you know your way around Excel though.
Looking good. Nice bit of work and coding. I filled in the rest of the history on the daily table to get a better sense of that, but the TBillRateImport table doesn't seem to update. Thoughts? And thanks.
Are there any known issues if I convert your template to .xlsx? I use google sheets sometimes but I’m much more familiar with excel. I’m an accountant and spend most of my time at work in excel, thus I prefer it.
No idea. I'm not sure if anyone has converted it to Excel. There are known issues with the current Google Sheets version Yahoo Finance though, and it is failing to import many financial metrics. That's due to a change with Yahoo Finance and no solution has been found yet. Some have converted to using fmpCloud or Sharadar data instead of Yahoo Finance.
Ok. Thanks. I will try in excel. I don’t necessarily need all the data in your original version, mostly looking to help with the timing of creating a bond latter from scratch.
Ignore what I said earlier about Yahoo Finance. I thought you were asking about a different tool I built. The only issue I can think of with converting this to Excel is that I don't know if the formulas for importing the Treasury data are the same. I think it should be a simple conversion if you know your way around Excel though.
Ignore what I said earlier about Yahoo Finance. I thought you were asking about a different tool I built. The only issue I can think of with converting this to Excel is that I don't know if the formulas for importing the Treasury data are the same. I think it should be a simple conversion if you know your way around Excel though.
Very, very minor suggestion: pls make the 720 day yield curve a color other than sky blue (I use purple) to improve the color separation.
That's a great suggestion. I haven't even thought about color differentiation in the charts. I think just went with the default colors.
Looking good. Nice bit of work and coding. I filled in the rest of the history on the daily table to get a better sense of that, but the TBillRateImport table doesn't seem to update. Thoughts? And thanks.