![]() ![]() I use this to convert USD to SGD via a formula in Google Finance. USDTOSGD – this you may find useful if you are new to Google Spreadsheet.Price Tolerance – some warning indicator under Stock Summary to change the color of cells should it breach a certain level.You can change them next time when you get comfortable. Stock Category is some categorization that i set for my stocks.Ref > This sheet contains data found in the drop downs in the other sheets.Once you are familiar with google spreadsheet you can create many of these to show to your readers. Current Allocation Chart > Just a chart showing a pie of how much each stock i have.Transactions USD > This is the transactions to Stock Summary USD.So i have a sepearte one that is similar to (3) here. Stock Summary USD > When i come up with this spreadsheet i only have in mind local currency which to me is SGD.If its a 5 to 1 consolidation the ratio is 0.2 Enter your split ratio under Stock Split Ratio. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |