Automatic Stock Market Calculations (US and CAN) total in CAN $
I have not found a site that can take both us and canadian holdings, do the share quantity x price calculations, and show the grand total in Canadian Dollars. I can feed it the US Dollar rate if it the web site doesn't automatically provide it. small example/sample report A US COMPANY US 100 shares @ 100 US $ 10,000 US . . A CDN COMPANY US 10 shares @ 50 CAN $ 500 CA Total Value in Canadian Dollars assuming US$ can be sold for 1.30 CAN $ 10,650 CA Im hoping their is a free service that can do this. Can someone help me? Total Value in Canadian ===== The true measure of a man is how he treats someone who can do him absolutely no good. -Samuel Johnson, lexicographer (1709-1784)
On Mon, 1 Mar 2004, Mel Seder wrote:
I have not found a site that can take both us and canadian holdings, do the share quantity x price calculations, and show the grand total in Canadian Dollars.
Have you tried setting up a Yahoo! finance portfolio? It lets you track your holdings, purchase price, and select between several display currencies. Sean -- Sean A. Walberg <sean@ertw.com> http://www.ertw.com
:-) :-) :-) (yahoo being yelled at the top of my voice) I have always used a yahoo finance/portfolio. I have noticed that currency screen but never realized/thought that its function was to convert one currency to another. I now have a US portfolio and a Canadian. My holdings are shown in Canadian Dollars. I did a rough check comparing the calculations I made yesterday with todays NEW portfolios results (some prices changed a few pennies) but it WORKED. Thanks so much, if I live to be 100 you have saved me roughly 10 minutes a day, 5 days a week, 52 weeks a year for the next 41 years which is 74 days if my math is right? You freed up two and a half months for me! I keep a small hero list and you are now on it. Thanks for your help Sean. One teenie weenie itsy bitsy question. Does Yahoo display/show the factor/rate it uses to convert US$ to CA$? I looked around but it didn't jump out at me. --- "Sean A. Walberg" <sean@ertw.com> wrote:
On Mon, 1 Mar 2004, Mel Seder wrote:
I have not found a site that can take both us and Canadian holdings, do the share quantity x price calculations, and show the grand total in Canadian Dollars.
Have you tried setting up a Yahoo! finance portfolio? It lets you track your holdings, purchase price, and select between several display currencies.
Sean
-- Sean A. Walberg <sean@ertw.com> http://www.ertw.com
===== The true measure of a man is how he treats someone who can do him absolutely no good. -Samuel Johnson, lexicographer (1709-1784)
On Tue, 2 Mar 2004, Mel Seder wrote:
One teenie weenie itsy bitsy question. Does Yahoo display/show the factor/rate it uses to convert US$ to CA$? I looked around but it didn't jump out at me.
If I had to guess, it would be same as: http://finance.yahoo.com/q?s=USDCAD=X&d=t You can also add that to your portfolio and it'll track the current exchange rate. Keep in mind that this is the latest trade, not the actual buy/sell rate you'll get from a bank. Sean
--- "Sean A. Walberg" <sean@ertw.com> wrote:
On Mon, 1 Mar 2004, Mel Seder wrote:
I have not found a site that can take both us and Canadian holdings, do the share quantity x price calculations, and show the grand total in Canadian Dollars.
Have you tried setting up a Yahoo! finance portfolio? It lets you track your holdings, purchase price, and select between several display currencies.
Sean
-- Sean A. Walberg <sean@ertw.com> http://www.ertw.com
===== The true measure of a man is how he treats someone who can do him absolutely no good. -Samuel Johnson, lexicographer (1709-1784) _______________________________________________ Roundtable mailing list Roundtable@muug.mb.ca http://www.muug.mb.ca/mailman/listinfo/roundtable
-- Sean A. Walberg <sean@ertw.com> http://www.ertw.com
participants (2)
-
Mel Seder -
Sean A. Walberg