Bartman's Blob

Sometime ago i created a simple spreadsheet to simplify the calculation of the effect of foreign currency exchange when trading with foreign stocks.   It has been awhile since i use this spreadsheet and i had kind of forgot how to use it. In the process of trying to recall how to use the spreadsheet, i found that it needs some changes to make the spreadsheet easier to understand. I have made some minor changes and upload it to a file share. You can download the spreadsheet here . Download Password is : bartman88.blogspot.com   The previous post on this subject can be found here .   Disclaimer : I will try as far as i can to keep the information or techniques used in this post as accurate as possible. But I will not be responsible for any use of this information or techniques nor accept any liability (whether arising out of negligence or otherwise), for any injury, damages, costs, expenses and losses suffered or incurred by a person where such a per...

Investing is laying out money today to receive more money tomorrow – Warren Buffett.

Here is the latest chart that i have complied on the Singapore Treasury Bill Movement. Click on the image to view a larger graph. Disclaimer : I try as much as i can to keep the data used in the chart as accurate as possible. But I will not be responsible for any use of this chart nor accept any liability (whether arising out of negligence or otherwise), for any injury, damages, costs, expenses and losses suffered or incurred by a person where such a person has relied on this chart.

I have created a simple spreadsheet to help you in calculating your stock purchase that is exposed to foreign exchange fluctuations,(e.g US shares) As you can see from the below example, even when you sell your shares when the share price has gone up, you have actually made a lost of $10 (we have not even added the trading fees yet). Even thou your local currency have strengthen against the foreign currency(which is a good thing), but that has impacted the "value" of your "foreign currency" which is those shares that you are holding. Although you do not have much control over the fluctuation of the foreign currency, whenever you are thinking of selling your US "assets" and converting it back to your local currency, do take note of the below example and calculate your gains(if there are any) before unloading your US "assets". Example : Although the share price has gone up, but............... Use the simple sp...

Be Greedy when others are Fearful. Be Fearful when others are Greedy - Warren Buffett.

Here is the latest chart that i have on the Singapore Treasury Bill Movement. Click on the image to view a larger graph. Disclaimer : I try as much as i can to keep the data used in the chart as accurate as possible. But I will not be responsible for any use of this chart nor accept any liability (whether arising out of negligence or otherwise), for any injury, damages, costs, expenses and losses suffered or incurred by a person where such a person has relied on this chart.

Here is the latest chart that i have on the Singapore Treasury Bill Movement. Click here for my previous graphs. Disclaimer : I try as much as i can to keep the data used in the chart as accurate as possible. But I will not be responsible for any use of this chart nor accept any liability (whether arising out of negligence or otherwise), for any injury, damages, costs, expenses and losses suffered or incurred by a person where such a person has relied on this chart.

I managed to compile a list of the 30 components that make up the Singpore ST Index. Here is the list of the ST Index components (as of 29 Oct 2008) for you to load and create your own Portfolio tracking list in Yahoo Finance. Copy and Paste the whole list below : ^STI C31.SI C38U.SI C09.SI F83.SI D05.SI F99.SI G13.SI E5H.SI H78.SI J36.SI J37.SI C07.SI BN4.SI K17.SI N03.SI N21.SI O39.SI O32.SI C6L.SI S68.SI S59.SI T39.SI S63.SI U96.SI S51.SI CC3.SI U11.SI F34.SI Z25.SI Hope you will find it useful. Have Fun. Disclaimer : I have tried as much as i can to keep the data used in the list as accurate as possible. But I will not be responsible for any use of this list nor accept any liability (whether arising out of negligence or otherwise), for any injury, damages, costs, expenses and losses suffered or incurred by a person where such a person has relied on this list.

I have been searching around looking for a historical chart on the Singapore 3 Months Treasury Bill. But i have not been successful in locating such chart. Looks like nobody is interested in compiling such chart. So i guess i have not much choice but to plot my our chart.. Every since i had it done and occasionally updating the chart i thought why not i put it up here just in case any of you guys might be interested. Here it is : For period 7-Jan-05 to 18-Sep-08. Click on the image to ZOOOOOOOOOM in.... I will try to upload updated chart as and when i have new data. Do leave any comments for improvement. Disclaimer : I will tried as much as i can to keep the data used in the chart as accurate as possible. But I will not be responsible for any use of this chart nor accept any liability (whether arising out of negligence or otherwise), for any injury, damages, costs, expenses and losses suffered or incurred by a person where such a person has relied on this ...