Well my old Canadian google finance stopped working on Friday so I had a look at that investing.com portfolio facility that I mentioned to you. And I have to say it looks really great !!. I cant tell the update frequency yet but really good, cool features include:-
1. Its free, you have to register but thats all. No costs involved.
2. You can have multiple portfolios (it calls them watchlists in some places and portfolios in others).
3. You can add symbols to a portfolio in several ways:-
a) using the add symbol box on the portfolio page
b) but to add multiple entries you can just clear your recent quotes (use the wastebin icon), display the stocks that you are interested in so they go into your recent quotes and then add them as a group to any of your portfolios using the add to Watchlist button.
4. To delete entries you just use the delete icon that appears at the end of every line in your portfolio.
5. You can hold ANY Fund/Stock/Investment Trust/Exchange Rate that investing.com supports and thats most everything you are ever going to need or want I would think.
6. You can sort your portfolio by stock name or symbol or just drag them to where you want them to appear using the mouse.
7.When you are displaying an index (like FTSE 100 ie not looking at your portfolio) you will find a Download Data button on the screen. If you press that then it downloads all of the stock data on that screen to your computer in CSV format. I cant see anyway to download just your portfolio though ATM.
As I say its sunday so I cant tell what rate the portfolio updates, but if its near real time like the rest of the site this is a FANTASTIC free facility I think. Its what I am going to be using starting tomorrow.
Well FWIW the username PrefInvestor is no longer really appropriate to me as I have just sold every pref that I owned these last two days as a result of the Aviva initiated crisis. No doubt many will think thats a crazy thing to do, but I have my reasons, see below:-
1. This Aviva preference share cancellation issue may take a long time to resolve, probably years if a court case plus appeals plays out. Throughout this time the price of the Aviva prefs are unlikely to improve much, and this is where ~50% of my losses lay. Right now my investments are about 12% down YTD, about 10% of this drop is due to this issue, about 5% due to just the Aviva prefs. So the maximum that I could have regained in the short term is 4-5% from a recovery in the non Aviva prefs in my portfolio. And no guarantee that this would happen.
2. If the issue WAS eventually resolved by a court case then the outcome would have been either quite good for me or REALLY bad. If Aviva were prevented from redeeming at par then I might regain most of the current 10% loss caused by this issue. However if they should be successful then all of my pref investments would likely sink to par or just above, resulting in a loss of about 25%. I have been through the prospectus documents for all my prefs and nearly all have a return of capital clause of some description. If Aviva won a court case on this issue then that would have been an ominous sign for all my prefs. In my opinion a 25% loss outcome needed to be avoided at all costs.
3. Also I really dont want to be tied up for years investment wise waiting for this issue to be resolved via a court case, with a disastrous outcome a real possibility.
4. There is another possible outcome, that Aviva might make an offer to purchase the shares. Were they to do so then it is likely that the amount offered would be less than the market value prior to these events. In fact some people are of the view that their actions have been a deliberate softening up exercise designed to make preference share holders accept a lower price for their shares than the previous prevailing market price. In this scenario i would end up probably slightly down on where I was before this issue. How much depends on the price that they offer obviously. Difficult to put a precise financial value on this outcome.
5. At any time Aviva might have further clarified their position on cancelling their preference shares. Were they to re-iterate their position this would likely cause another panic in the market and a drop towards the 25% loss position. In fact yesterday 15th March Aviva did in fact put out another document re-inforcing their plan and making it clear how they would expect to win the vote required, not good news. Nail in the coffin for me.....
6. Currently the FTSE is down about 8.5% since the start of the year, so had I had been invested purely in equities right now I would likely be down by maybe ~8-10%, thats not a million miles away from where I am now having sold the prefs. In fact I feel better placed than that as I now have a large amount of cash to invest in a stock market that is down and offering many bargains.
7. Preference share investments were already under threat from rising interest rates which will be damaging to pref prices and cause capital losses. This overall situation said to me that it was time to exit from this asset class. There are many high yield opportunities available in ordinary shares, I plan to move forward by investing in those.
Anyway what it all boils down to is that basically Ive taken a 12% loss to avoid the possibility of a much larger one. I made over 20% in gains last year, this hit has reduced that to ~8%, about my normal target for a year. A 25% loss would have been survivable but most unpleasant.
That's me taught! Thanks to you for your lesson on how to use this particuar feature, it really is appreciated,
Perhaps it is going out of fashion (rather as ii considers itself to be doing as it is overly keen on updating the site seemingly against the wishes of its many users) but there are so many posters on this board that are ready to help other users whenever that help is needed, so thank you all.
I really may have to loosen the purse strings a bit and consider upgrading to Excel 2016 in order to keep up to date with progress but in the meantime I will worry about whether I will be able simply to transfer and update all my old spreadsheets from Excel 2007 and get them working as they do now without having to go through a whole new learning process and having to discover where they have hidden all the old tabs that I regularly use.
Yes it is annoying not having the old google portfolio instead of the "better" version that is simply "not". I have been able to continue to access my old version (maybe it that canadian version) but have not been updating it for fear it will just disappear at some point.
I have used google docs to make a copy and linked to the live prices ie GSK
It does most (and more) than the old site but I miss the live price daily chart. I have also tried yahoo finance portfolio but its not live or as simple and maybe its just not as familiar.
Would be interested to find a better alternative but maybe people want you to pay rather than give it away free.
"p.s. you may have noticed that I am unable to figure out how to respond by putting your name in the title as you have done. I presume that the only way is to start a new thread "Google Finance - PrefInvestor.""
If you click on the 'respond' button, between 'view thread' and 'vote up' you will be presented with a respond page in which you can edit the subject line. Also if you click on the 'more' button.
Well to deal with the simple things first, to edit the Subject line of a post (where I usually put the name of the user I am addressing my comment to at the end of the line ) then having selected "Respond" simply click in the Subject: box and edit the text using the keyboard. Couldn't be much simpler really !!.
After BaseCadet's post I considered creating a spreadsheet that would allow tracking of FTSE 100 with updates via web queries and posting it here so that you guys could use it. But I'm afraid that in practice there are problems with me doing this:-
1. You have Excel 2007 I have Excel 2016. I could avoid using facilities that weren't around in 2007 but the trouble is that I couldnt test the resulting spreadsheet on 2007 cos I dont have it. And if it doesnt work then sounds like you arent going to be able to fix it.
The differences between 2007 & 2016 are quite large and I doubt that my instructions for creating a web query in Excel 2016 were any use to you on Excel 2007.
Try this youtube video which should be 2007 specific:-
2. I also have the same web query problem as when FRTEB asked how to do it. I can create web data queries easily enough but if I use the wrong site I might inadvertently pick one where doing this kind of automated data retrieval violates their web site terms and conditions. And I dont want to get in a situation where I have posted a solution on a worldwide accessible web site where I have published a solution that violates some big company's terms and conditions !!!.
So regrettably right now I cant see any way around these problems.
Yes I am still using Excel 2007, it still works fine for what I have been using it for although as I mentioned to you last week I have been unable to create a successful automated spreadsheet using your advice. I tried hard most of last Friday, almost spending the entire day trying to get it to work but unfortunately I had to admit defeat in the end. Perhaps it was me using an outdated version of Excel but mostly I think because I am relatively incompetent when it comes to using technology and getting it to work correctly....
I am still willing to learn so any advice you can offer is always gratefully received.For instance why does my Google Finance refuse to show the FTSE100 stocks that I wish to follow? It shows me "stocks that I might be interested in:" AZN, SSE,LGEN, EZJ,ULVR,NXT,BLT,BATS,SBRY,GBX,VOD & GSK, the last two of which I have a holding in. I cannot find any method to bring up any other stock. I have basically given up on Google Finance, before it got updated it was my preferred site for following my holdings.
p.s. you may have noticed that I am unable to figure out how to respond by putting your name in the title as you have done. I presume that the only way is to start a new thread "Google Finance - PrefInvestor."
Jeez development project is a bit strong. If you just want spreadsheet that takes a list of FTSE 100 stocks plus numbers of each stock and gives you a daily total and day change and can be updated by a web query thatd take me about 20 minutes to create.
I have stopped using Google Finance as I have been unable to get it to show FTSE100 stocks that I own. It insists on showing me. I have been able to get it to show 12 FTSE100 stocks only two of which I own!
I tend to use Yahoo Finance that allows me to display all the stock that I own on one page. Soemtimes Yahoo seems to have technical glitcshes but then don't most sites at some stage.
I am always on the hunt for a new site that will allow me to view my portfolio on one single page that updates almost in real time, doesn't have some long and complicated log in procedure and doesn't automatically close down after 20 -30 minutes. If it also has a decent uncomplicated discussion board as ii still has, although it is threatening to "update" it in a couple of months then I remain relatively content.
Then if only I could convince the market to move my shares in the direction I prefer.......
Had a limit order set which got filled early afternoon while I was off playing with the grandkids. Dropped a couple of pence more after my purchase but you catching the bottom is impossible. FTSE down badly probably worrying about the spat witn Russia ?.
Didnt buy that many and if it drops further I might buy some more. Been bouncing off 700 for a while so hopefully it will recover, but might depend on what HK does overnight.
Prefs had a pretty good day today, still a long way to go but only 11% down now. Cant see much hope for the Aviva ones getting back to where they were, but some of the others did quite well today.
Even had to bale out of RUSP yesterday for fear of what a spat with Russia might do to them. Good timing as they dropped ~6% today. Only 11 prefs left to worry about now !.
Thanks for the moral support, definitely need some. Did a worst case analysis of my prefs going to par and it results in a 26% loss (!) should that come about. Confess given the high weighting of prefs in my portfolio I thought it would be EVEN worse than that. It would put my portfolio back to where it was in March 2016. So not good but survivable. And actually I dont think it will come to that, many prefs have recovered a bit to day and hopefully that will continue. Hope so anyway.
Ecclestiastical (= the church !!) issued an RNS effectively criticising Aviva's action and saying that there was no way they were going to be doing that with their prefs. Things seemed to improve a bit after that. The church doing some good for a change !.
Anyway I sold a couple of things (sold 2 stocks when I could get the capital out without a significant loss) so now I have a bit of money to invest. Planning to buy some HSBA if it drops into the 600s again.
I read of your predicament which, because I do not invest in any bond or bond-like instruments, came as a real shock. If it is any help, I offer that volatility works in both directions and that reading the ordinary share markets (my game) requires more luck than judgement at the moment.
Drifting on-topic finally, I note that HSBC March Call Options in the US. have just shown some very positive activity; although why one would want to buy March Options when the May ones appear to be the ones to go for, beats me.
From recent SE announcements, it appears that HSBC could be clearing the decks for the new team and a new strategic approach, however, I suspect that the 'pivot' to Asia will govern the next five or ten years, to the exclusion of any other meaningful global expansion. I just hope that keeping so many eggs in one basket is not a bit of a liability - something that both you and I have recently experienced in different ways.
As previously stated, its HSBC US Call Options for me until after Q1 and I'm hanging on to my US alternative equities until at least that time. (GOOGL +7.8%, APPL +2.0%, AMZN +28.2 since 28 Nov. '17).
Who knows what next week will dish up? The prospect of a peace dividend delivered by Trump and Kim Jong Un seems about the most unlikely scenario of all time and personally, I don't believe a word of it.
One thing is for sure; it's going to be Stormy, and not just for Trump! So I'm taking some cash off the table in May and going away, just like they say one should.
Hope you're bearing up. The preference share world sure has been ugly the last couple of days. Aviva directors need damn good rollocking for the chaos they have caused with their, at best, unclear statement. Unintended or intended consequences? Makes one wonder...
I hope things work out for you.
The good news is, it's the weekend. Have a good one.
Aviva made a statement in their results in Thursday that they intend to redeem some or all of their prefs at par. Even though they are supposed to be irredeemable !. Lloyds ECNs all over again. This has caused panic in pref stocks for the last 2 days, prices dropping like a stone and no way to sell. Bit of normality returned by lunchtime today, and some of better known prefs have started to recover. You could have bought LLPC for about 125 at one point today, they were 177 Thursday morning. Back to about 146 by cob today.
Personally I dont see the likes of LLPC, NWBD, SAN, SANB as under any real threat - if the issuing companies could have worked out a way to redeem these they would have done it long ago I think. Aviva prefs all hit hard and not recovering as well though, which isnt really surprising.
All of which has added up to about an 11% portfolio loss for me over the last 2 days. About 12% down YTD now, probably not far different to people totally in equities Id guess ?. Puts me back pretty much to where I was in April 2017 portfolio wise.
Still Im not much worried by rising interest rates knocking pref prices back anymore !. Every cloud has a silver lining I guess.
Looking forward to a large drink this evening.....
Hi Prefinvestor. I had a question on the Aviva board earlier and several posters suggested that you might be able to help and that I'd find you here! I have the 8.75% Aviva preference shares:
"Does anyone else on here hold these? I have a few and theyve taken a dip today as a result of the CEO suggesting they maybe paid down. Does this mean theyll be cancelled/bought back at par value (£1.00)? I can understand the company no longer wishing yo pay the 8.75% coupon but it seems a little inequitable for us holders at £1.75!
Any guidance would be much appreciated.
Many thanks if you have any idea what the score is likely to be.
I have just managed to get a display of HSBA from Yahoo finance onto an Excel worksheet after continued efforts. A widow kept coming up satating a script error but I kept tapping away at it and pressed import and up it popped.
There seems to be a lot of the overall Yahoo finance page items including FTSE100 & 250 prices, general headlines but way down the sheet (line 58 to be exact) there is the current mid market price 701.80+2.40 (+0.14%). Now all I need to do is to find a way to transfer that to a worksheet and see if it keeps updating. Well it hasn't managed to update itself, the price now showing as 702.50.
I must still be doing something wrong but I will keep trying.
As I think I mentioned I consider myself computer illiterate. I have been using one with Excel now for over 25 years. Everything I am able to do on Excel is basically self taught or with the occasional help of Excel for Dummies......
I have been using Excel 2007 for some years now and it has generally served me well. I have built two basic workbooks that I use daily using data I input manually (all data has at some stage to be input manually even the information that you are able to input automatically.)
My first workbook is basically day to day finances which includes spending , bank and savings accounts using a double entry system where the various worksheets are linked to an overall balance sheet that will also indicate if there are wrong entries somewhere. There are also charts and then an annual tax return sheet based on the latest sheets shown when you do your tax return online. Unless HMRC changes its methods this sheet is normally correct within £100.00 at the end of each tax year. That does for me.
The second workbook contains all my investments. For every stock I hold or sell I first print a hard copy of the contract note. Where there are dividends reinvested I add to the holding on that hard copy to record a new total holding together with the original overall purchase cost which is then divided by the total shares held to give average holding price for that stock. Individual holdings are then held together by staples where possible or in a clear folder when that is no longer possible! Most of my holdings are either FTSE 100 or 250. There is the accidental "leftovers" of one AIM stock that I managed to sell a tad too quickly and one small IT.
There is an single worksheet that shows each stock, original purchase price and the overall costof purchase, current market price and valuation, book profit or loss both in sterling terms and as a percentage of that holding. It also shows current dividends, total dividends received for each stock and the total of all diviends paid on each stock since purchase. There are other items recorded in addition such as p/e both historic and current and the number of years that a stock be held for the dividends to equal the purchase price.
Cells within this worksheet are linked so that the only entries I need to input manually is that of the daily closing prices, adding whatever number of shares of individual stocks are increased by dividend reinvestment, the sterling equivalent of dividends paid, recalculation on results days of the relevant p/e. It also lists announcement dates / ex div and pay dates which always have to be entered manually.
These are all then linked automatically using Excel formulae to an overall spreadsheet together with bank balances etc. together with various reserves which are added automatically daily to allow for holidays and other capital outlays.
It has served me pretty well over the years although there are times when I am unsure whether a "thick finger" has intervened or whether Excel has a mind of its own and is determined thwart my efforts at finacial literacy....
My first efforts to use your system this morning have failed!
Yes, I opened a new workbook had at first Yahoo finance opened up and then LSE but and hit the "from web" button on the data tab. I entered the web address and then go. The first thing I noticed was that the web addresses changed slightly and a small window asking where I wanted the data. When I pressed Ok to continue another window popped up saying that "the web returned no data, press on the arrow." This I did together with import and got a nice blue coloured window with the same statement "the web returned no data, etc." This has happened on eachoccasion I have attempted to get this to work. Not sure why, whether it is the web pages I have used that do not allow automated page retrieval, Excel 2007 is just no longer up to the job or whether I have missed some vital piece of i
Sorry but I dont know anything about the query capabilities of LibreOffice, so I have no idea how easy or difficult it will be to import web data using queries as per my post.
I dont know how complex your portfolio spreadsheet is, but I think that your simplest route to obtaining prices automatically would be to use Google sheets. I havent used it myself but I believe that most excel spreadsheets work OK with it. If you havent used any esoteric features it might need very little in the way of changes. And the GOOGLEFINANCE function then provides a very easy way to obtain live prices.
Why not give it a try ?. What have you got to lose ?.
Well I know that using spreadsheets can be difficult if you arent familiar with them. But they are VERY useful, so some time getting up to speed will be well worthwhile. There are only about 4 steps involved and they are VERY simple, they may look complex in my description but if you try them I think you will find that they really arent. I dont know what software you have but if its not Excel 2016 then beware as the commands that you will need to enter will not be exactly as I have described them in my post.
If your portfolio contains only FTSE100 stocks then you should be able to fully automate your portfolio updates using the techniques that I have described. Sites are available that provide FTSE100 data, some in real-time, but most with a 15 min delay. But you may not be concerned about that if you only update your portfolio once a day ?. I update mine 2-3 times a day, but all the FTSE stocks update automatically. I could update them every couple of minutes if I wanted to.
Realistic prices for other types of investment are difficult to obtain by data query. For my preference shares I want live prices as the investments have a large spread and the true price can be substantially different to the official spread figures that brokers typically publish. Take LLPC (a preference share) for example, the official spread figures at cob today are 176.6 (Sell), 179 (Buy). Whereas the live prices obtained by doing dummy trades are 177.3 (Sell) and 178.45 (Buy). Thats a big difference when you've got a lot of them. Similarly prices for Investment Trusts can have a big spread and the live selling price can be significantly more than the official spread selling price.
So I am reconciled to entering my pref and investment trust prices manually, because I always do dummy trades to obtain live prices. If I was content with official spread figures then I could probably set up a virtual portfolio somewhere and set up a query to obtain the prices.
If you need any help just ask. But I need to know what software you are using if its not Excel 2016.
I like this thread. Many years ago whilst I was employed I was able to copy & paste Reuters prices onto a spreadsheet that I could display and work from. Generally that system worked well for me until the day Reuters had updating problems and my whole system collapsed. It took me about 30 minutes before I recognised that I had a problem that could have proved costly.
Then (if I remember correctly) you were only allowed to copy & paste from a site if you subscribed to that site. I also recall trying to set up a similar system for myself when I first purchased a home computer but, was unable to copy & paste price information from any website I tried to use.
Today, I collect my prices from Yahoo Finance for my spreadsheets, I take each day's closing prices and then overwrite yesterday's prices. It has served me well over they years but if I could somehow manage to do it automatically that would seem like finding the pot of gold at the end of the proverbial rainbow!
Do you use a specific site that allows you to import prices into your spreadsheet or is it possible to do it from most sites these days?
Pref, your method seems pretty labourious to set up at first glance and not being terribly efficient on computers and that's without my customary "thick finger" problem I will be studying carefully your solution and hopefully step by small step within a few days I will hope have at least got something up and possibly running. Whether I can do so successfully is an entirely different matter!
I did something similar years ago but found it too unwieldy as it didn't seem possible to remove unwanted data, so every time a link was updated the complete data import overwrites everything in other cells. I found the best workaround was to copy and paste a complete virtual portfolio into another spreadsheet and link to the relevant cells, but adding a new entry to the virtual portfolio messes everything up. Resolving this, somehow, has been on my list of things to do so I can keep track of things more easily. I didn't/don't want to use google sheets - they know enough about me as it is!!!
I think your idea to have each query on a different worksheet within a workbook and each relevant stock price cell renamed to make it easy to reference is the way forward. Now all I need to do is stop procrastinating and allocate a day or two to make the changes.
Note to anyone starting out - get your portfolio tracking spreadsheet in order right at the beginning - don't put it off or I'll guarantee you'll live to regret it!
OK I have hit an issue with doing an example for this as having chosen a simple web site to use I found that doing automated page retrieval was explicitly prohibited in their Ts & Cs. This doesnt stop you actually retrieving data from such sites of course, but I am unhappy to publish an example here using a site that prohibits such operations. So what I have done instead is to produce a generic description of what you need to do to create a query, it is then up to you to locate a suitable website to use in conjunction with these operations and which does not contravene their Ts and Cs.
Instructions for creating a query are given below:-
1. Open a new completely blank workbook
2. Select the Data menu item in the ribbon and then select From Web
3. You now need to enter the address of a web page and select Basic or Advanced. Select Basic (its the default) and then enter the web address of the page containing the FTSE100 data that you want to import and press OK. Suggest you locate a suitable page in your browser and then copy and paste the URL.
4. Excel now analyses the web page that you entered and displays a Navigator page that includes one entry for each set of data items found on that web page. What you need to do now is to locate the data that you want to import. To do this use the mouse to select each named group in turn and look at the Table View on the right hand side of the screen. When it displays the data that you want, ie a list of stock Epic codes and prices then using the Load control at the bottom of the screen select Load.
5. Having selected that and pressed Load then Excel creates a query and loads the data onto the worksheet. The data is automatically created in the form of an Excel table. The name of the query created is displayed in a new window on the right of the screen.
6. At this point I suggest you rename the query by selecting it, right clicking and selecting rename and entering the name FTSE100. This new name will appear in the list of queries on the screen. This action will ALSO change the name of the table holding the data to FTSE100.
7. To use data from the FTSE100 table elsewhere in your spreadsheet you can use any normal excel formula, however it is normal to use INDEX and MATCH operations to search the table for a matching name in one of the columns (eg the Epic code) and return the entry for a nominated numbered column (eg the Stock Price) that matches that name. I have shown an example of this formula in the link provided after point 8 below.
8. You can have any number of queries within a workbook, the list of queries being retrieved by using the Queries and Connections command on the Data menu. Each query has a set of menu items and properties which you gain access to by right clicking on the query name. One of these menu items is Refresh, if you select this then Excel will immediately re-run just that query retrieving the current data into the table. If you select Properties you will find one called Refresh this connection on Refresh All which you can select or de-select using a tick box. All queries with this property will be refreshed any time you use the Refresh All command on the Data menu in the ribbon. You can use either of these methods to periodically update your portfolio spreadsheet on demand with stock prices obtain from the web. Personally I do the same thing for exchange rates also.
Those are the basics. If you choose Advanced instead of Basic at Step 3 then you gain access to advanced editing features that allow you to do things like removing rows or columns, renaming columns and other clever features including logging in to the web site (requires a username and password). Id ignore these to begin with if I were you. They can cause problems that you best to avoid to start with.
Personally I always put each query on a different worksheet
Yes I can do that. But Ill need a bit of time to construct an example and document the exact set of steps for creating a web data retrieval query.
For my example and instructions I shall be using excel 2016 as that is what I have. If you have an older version then you can almost certainly do much the same things, but as the menus and user interface are different the exact commands needed to complete each step will be different.
I will also be using excel tables. Tables are just named ranges of cells with a header row which assigns a name to each column. They also allow cells to be referenced using structured references, these are names of the form:-
Table_name[column_name] or within a table just [colimn_name]
These can be used instead of the old A1, B6 sort of format for referencing cells.
Tables were introduced in excel 2013 so if youre version of excel is older than that then again, you can probably do the same things but you will have to created named ranges and use the associated names or A1 type references to refer to the cells containing the data.
I will try and post the example ASAP, too late to do it tonite (10:00 now) but will try to do it tomorrow.
No Im afraid I am still dithering, dont really like the idea of selling something I havent held for that long to liberate funds to buy HSBA (Plan A). really Id like to wait for my dividends (Plan B), but those are about 4 weeks away. Also thought of putting some more money in to fund the purchase (Plan C), but that means juggling stuff around too and I really cant be bothered. And who knows what the SP will be in ~4 weeks time anyway !. I was tempted to do Plan A or C when they were ~720, which would clearly have been a mistake in retrospect. So no - just watching right now. Effectively waiting for my dividends I guess.
Re the exchange rate point, yes you are correct that figure is contains unrealistic detail by including 2 decimal places. Thing is that my investment spreadsheet imports all of the FTSE 100 stock prices and the exchange rates via data queries on demand and if I plan a purchase it calculates the yield based on those numbers. But of course you are right it really depends on the exchange rates that they declare for each dividend. Thing is my spreadsheet is generic and does the same calculation for all stocks, the only difference is the EPS for the year which for HSBA is calculated as 0.51*100/Todays GBP -USD rate. Personally I am fully aware that this is just an approximation but it might confuse other people I guess.
Nice move up today. Prefs almost fully recovered now (only 3 down more than a ~£250 in total today). Portfolio only 1.4% down YTD ATM, ~1.8% due in dividends before end of April. Lets hope it continues !!.
Are you still "watching and waiting" on the sidelines, or did you make the most of the opportunity when the share price did indeed briefly dip below £7 per share.
I see from one of your earlier posts, that you calculated the dividend yield to two decimal places, but with widely fluctuating exchange rates, and the rate being set each "quarter", it is probably better to use a likely range - a bit like you did in your Buy-back spreadsheets.
Since I have owned HSBC shares, the exchange rates have varied enormously - from over two dollars to the pound, to below 1.25 for cash (and below 1.23 for scrips).
Although the cash exchange rate is sometimes better than scrips, overall the scrip option has benefited from better rates.
The average combined rate for my cash/scrips since early 2001 is still over 1.5 and I currently use 1.4 to provide a rough estimate of the likely yield for the year, but it could be much better or worse!
Or maybe not it would seem. Holding above 702 and not following the HK lead.
Not quite sure whats going on today, I had expected my far east based investment trusts (AAIT & HFEL) to be down as the markets are all down. But actually they are all UP a bit, and the £ is up too, so it isnt that. Hmmmm ?.
FTSE up a bit too and US futures looking to be recovering a bit, only 0.2% down now.
If Trump is watching he will probably think that its a good time to make some new intervention !.
HSBC closed in NY at the Sterling equivalent price of around 717p. Could do better than that in HK on Monday - could do worse.
Scrip Election: 22 March
UK Financial Authorities report on Gupta money laundering due: Mid-March.
Highly volatile US markets still look unstable.
Not much by way of HSBC corporate announcements before Q1.
A possible threat of kitchen-sinking by the new management team in the Q1 report.
Possibly worth a Call Option punt but I'm not putting my shirt on it.
Important message from the Financial Conduct Authority:
Posting inside information that is not public knowledge, or information that is false or misleading, may constitute market abuse.
This could lead to an unlimited fine and up to seven years in prison.
If you have any information, concerns or queries about market abuse, click here.
The content of the messages posted represents the opinions of the author, and does not represent the opinions of Interactive Investor Trading Limited or its affiliates and has not been approved or issued by Interactive Investor Trading Limited.
You should be aware that the other participants of the above discussion group are strangers to you and may make statements which may be misleading, deceptive or wrong.
Please remember that the value of investments or income from them may go down as well as up and that the past performance of an investment is not a guide to its performance in the future.
The discussion boards on this site are intended to be an information sharing forum and is not intended to address your particular requirements.
Whilst information provided on them can help with your investment research you need to consider carefully whether you should make (or refraining from making) investment or other decisions based on what you see without doing further research on investments you are interested in.
Participating in this forum cannot be a substitute for obtaining advice from an appropriate expert independent adviser who takes into account your circumstances and specific investment needs in selected investments that are appropriate for you.