tag:blogger.com,1999:blog-5465015914589377788.post6085929332969162024..comments2024-03-20T09:32:16.592-04:00Comments on Michael James on Money: Portfolio Rebalancing Based on Expected Profit and Trading CostsMichael Jameshttp://www.blogger.com/profile/10362529610470788243noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-5465015914589377788.post-44561697195562507662014-03-12T20:32:03.306-04:002014-03-12T20:32:03.306-04:00Again, Thanks!Again, Thanks!sclimhttps://www.blogger.com/profile/06493166858602139688noreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-45220821700953899992014-03-12T17:13:15.548-04:002014-03-12T17:13:15.548-04:00@sclim: Some tickers seem to work with .to appende...@sclim: Some tickers seem to work with .to appended (e.g., xic.to), but not others. A different solution is to use the =ImportXML("http://...","//span") function to access data from a web page that has the price you need and pick out the cell you want. Unfortunately, this breaks frequently as web page formatting changes.Michael Jameshttps://www.blogger.com/profile/10362529610470788243noreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-79315757731212791602014-03-12T16:44:53.854-04:002014-03-12T16:44:53.854-04:00A further cry for help here -- Google Finance work...A further cry for help here -- Google Finance works great most of the time, but seems to get hung up with Canadian ETFs that share an identical name with US ETFs (such as FXM and XEC). To the best of my searching, the fix should be to add the prefix "TSE:" However I tried this with TSE:FXM and TSE:XEC and I keep on getting error messages in my Google spreadsheets. What's the real fix?sclimhttps://www.blogger.com/profile/06493166858602139688noreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-66904623402459675542014-03-02T17:13:57.879-05:002014-03-02T17:13:57.879-05:00Never mind thanks -- I figured it out -- Just ente...Never mind thanks -- I figured it out -- Just enter VBR, GoogleFinance seems to know where to find the appropriate market and Stock Exchange!sclimhttps://www.blogger.com/profile/06493166858602139688noreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-67644923341683511222014-03-02T16:02:36.205-05:002014-03-02T16:02:36.205-05:00Thanks. This is brilliant!
I'm trying to dis...Thanks. This is brilliant! <br /><br />I'm trying to display VBR which is sold on the AMEX exchange. I have used VBR.IV which is its official listing, I think, and VBR.AMEX; neither works. Do you know if GoogleFinance works for US stock Exchanges?sclimhttps://www.blogger.com/profile/06493166858602139688noreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-33272000240652246292014-03-02T09:33:24.347-05:002014-03-02T09:33:24.347-05:00@sclim: Thanks. I use GoogleFinance(A1,"pric...@sclim: Thanks. I use GoogleFinance(A1,"price"), where A1 is a cell reference that contains the ETF's ticker. I don't bother to try to get spreads automatically. I just enter them manually once and on those rare occasions when the spreadsheet says to rebalance, I confirm that the current spreads are the same.Michael Jameshttps://www.blogger.com/profile/10362529610470788243noreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-86351264455097265212014-03-01T23:40:12.721-05:002014-03-01T23:40:12.721-05:00Read your paper -- nice thinking in translating ru...Read your paper -- nice thinking in translating rule of thumb into mathematical thresh-hold trigger. I'm relatively unsophisticated in googledocs spreadsheet use. I have been manually looking up ETF prices for the day and plugging them in manually into my spreadsheet. What is the exact command to use to populate the ETF price fields automatically in real time? As I understand it, you also populate the latest bid-ask spreads into your cells too? What's the command for that?sclimhttps://www.blogger.com/profile/06493166858602139688noreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-84417220481931867242012-05-17T09:00:05.817-04:002012-05-17T09:00:05.817-04:00Also interested in a generic spreadsheet. Thanks ...Also interested in a generic spreadsheet. Thanks for the post and the linked article.Tafirkhoohttps://www.blogger.com/profile/09006984575303907277noreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-19529252507343414272012-03-14T02:01:36.834-04:002012-03-14T02:01:36.834-04:00I would definitely welcome a generic spreadsheet!I would definitely welcome a generic spreadsheet!Be'ennoreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-55648918560287325052012-03-13T22:06:25.288-04:002012-03-13T22:06:25.288-04:00This looks real nice. A generic spreadsheet would...This looks real nice. A generic spreadsheet would be much appreciated and I understand about to-do lists so no pressure from me.<br />ThanksACMZnoreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-1579082472374435392012-03-13T18:02:50.296-04:002012-03-13T18:02:50.296-04:00@Erick: I can't promise anything too soon, bu...@Erick: I can't promise anything too soon, but I'll add it to my to-do list.Michael Jameshttps://www.blogger.com/profile/10362529610470788243noreply@blogger.comtag:blogger.com,1999:blog-5465015914589377788.post-19399322274836641582012-03-13T15:50:47.683-04:002012-03-13T15:50:47.683-04:00Definitely interested in seeing a generic spreadsh...Definitely interested in seeing a generic spreadsheet that I can mooch off of ;)Ericknoreply@blogger.com