Tuesday, March 6, 2007

HOW TO: Embed a spreadsheet in your blog (part 1)

Yes, you can embed an inline spreadsheet in a blog post... You can collaborate with a bunch of people first, create the spreadsheet of your collective dreams (although only sickos and wackos like me dream of spreadsheets) and then you can make it a part of your history in your blog, for the 3 people that read your blog to see... Best Part: If you keep updating the spreadsheet, the blog post will update (assuming you re-publish or choose the "re-publish automatically" option)...
I assume you all realize (yes, i know, all 3 of you) that I'm using Google Docs & Spreadsheets here...

So - here's a spreadsheet, with Stock and Mutual Fund data which uses the GoogleFinance() function within Google Spreadsheets... Notice that during market hours, the stock data will update automatically every 5 minutes (an option on the Publish feature) - the Mutual Fund data, by definition, is only provided by the exchanges on an end-of-day basis...


No, in this instance you can't edit this here in my blog... even if you had permissions... but - check out Part 2 (coming soon) to see how that's done!

No comments: