Categories
General

Videoblog. Again.

With my friend, I decided to create a new videoblog. Previously, I had one at orangebox.tv, but since I was busy and almost had no time to maintain it, I left the domain expired. Now, it has a new domain name, with a new concept. I will not talk about technology or other geeky stuff. If you like technology, you should visit Webicara, Notsogeeky, or Macindos.TV. Our new videoblog will focus on daily life.
Right now, almost all videos take Jakarta as the object. But, for me personally, I see many interesting stuff here in Jakarta — I’ve been staying in this city for almost three months. Last month, we went to Kalibata and Pasar Minggu. Not only to have durian, but also witnessing another area in Jakarta, at night. Not really at night, but can I say early in the morning?
What makes this videoblog different — from my previos one — is that I do it with a partner. He’s a good friend of mine since high school. The other important thing is that we share a same concept and understanding. It makes the videoblogging process easier. We do this videoblog mostly on weekend since we’re both working.
Anyway, the videoblog is using dadio.tv as its domain name. And we put our videos on YouTube. What does it mean? It might be meaningless in English, or in Indonesian language. But, you understand Javanese language, you’ll get the meaning. Yeah, it’s not a television, anyway. :D Okey, there are already some videos to watch. We have some videos on the stock about Betawi culture, food and also train (the economy class!).

Categories
General

Track Current Stock Information in Google Spreadsheet


I am not a person who got affected when there are major stock changes in the market. But, for those who need to track the stock information growth — and also use Google Spreadsheet, this is probably useful. Anyway, this will retrieve data from Google Finance.
There is a tutorial about tracking stocks in Google Spreadsheets

Instead of copying data into your worksheet, when the linked source changes, the cells in your spreadsheet will automatically update, which can save a lot of work if you pull reports regularly. This external data can be pulled from XML, other spreadsheet documents, and even (assuming you can bear to look) current and historical stock quotes from Google Finance.

Using this method, you can retrieve current stock information and also pull historical stock data. There are some spreadsheet samples you can download.