What HYP

[Arborbridge]

Maybe you misunderstand. Dod mentioned had a problem with the table program and the three types available and I was offering advice to solve that difficulty. That wasn't cajoling him.

No, I understood perfectly well. Of course it could be true that Dod101 is unable to fathom the mechanism for adding a table to a post although, as all it requires is an understanding of "Selecting Data", "Copying Data" and "Pasting Data, I rather doubt it.

But even if it is true, if Dod101 actually wanted to post the details of his portfolio, all he has to do is type out a post with the details of his portfolio, line by line. And it would appear that Dod101 knows full well how to type out such a post. He simply chooses not to, as of course he is entirely entitled to do.

Enjoy!


Ian

Well, Ian, I know you like a good old ding-dong. I'm not (and was not) commenting on whether Dod wanted to post his portfolio or not, but he was certainly showing some exasperation with the formatting tool, so that's where I was trying to help. If you want to expand that into something else, then that is entirely yours to do - but it isn't what I was doing. Dod is quite capable of telling us if he felt I was "cajoling" him, but he hasn't responded to your accusation so I think you are flogging a dead horse.

And before you come back with some further even more detailed answer, I will just say that I explained what happened from my POV - so I shall say no more and engage no further on the topic.

Arb.

[Arborbridge]

I don't think it is accurate to say Dod chooses not to post his portfolio. He has posted both his income and growth portfolios in the past and the most recent update was a reply to my question here:
viewtopic.php?f=31&t=36894&p=549993#p550067

He did say he is currently working on some numbers, and that he's acknowledged IAAGs previous assistance, and will get round to using the table software before long. I wouldn't characterise that as choosing not to post his portfolio.

Anyway, this is all getting off topic from the opening post. If I may suggest, let's keep the discussion of Dod's portfolio to the threads he started, called "Dod's high yield portfolio" (viewtopic.php?f=31&t=16638&start=20#p206239) and "Dod's Growth Portfolio" viewtopic.php?t=9286#p107058). If he chooses to update us, longhand or in table format, I'm sure he will when he is ready.

Well done for putting this discussion in perspective.

[Dod101]

I don't think it is accurate to say Dod chooses not to post his portfolio. He has posted both his income and growth portfolios in the past and the most recent update was a reply to my question here:
viewtopic.php?f=31&t=36894&p=549993#p550067

He did say he is currently working on some numbers, and that he's acknowledged IAAGs previous assistance, and will get round to using the table software before long. I wouldn't characterise that as choosing not to post his portfolio.

Anyway, this is all getting off topic from the opening post. If I may suggest, let's keep the discussion of Dod's portfolio to the threads he started, called "Dod's high yield portfolio" (viewtopic.php?f=31&t=16638&start=20#p206239) and "Dod's Growth Portfolio" viewtopic.php?t=9286#p107058). If he chooses to update us, longhand or in table format, I'm sure he will when he is ready.

I am sorry to be the subject of all this. I have in an Excel spreadsheet a nice table which I would like to post but whenever I follow the instructions, it comes out with columns corrupted. People could just about read it but I would like to know what I am doing wrong. My current effort is on the Testing website. Can anyone help please?

Dod

[Arborbridge]

I don't think it is accurate to say Dod chooses not to post his portfolio. He has posted both his income and growth portfolios in the past and the most recent update was a reply to my question here:
viewtopic.php?f=31&t=36894&p=549993#p550067

He did say he is currently working on some numbers, and that he's acknowledged IAAGs previous assistance, and will get round to using the table software before long. I wouldn't characterise that as choosing not to post his portfolio.

Anyway, this is all getting off topic from the opening post. If I may suggest, let's keep the discussion of Dod's portfolio to the threads he started, called "Dod's high yield portfolio" (viewtopic.php?f=31&t=16638&start=20#p206239) and "Dod's Growth Portfolio" viewtopic.php?t=9286#p107058). If he chooses to update us, longhand or in table format, I'm sure he will when he is ready.

I am sorry to be the subject of all this. I have in an Excel spreadsheet a nice table which I would like to post but whenever I follow the instructions, it comes out with columns corrupted. People could just about read it but I would like to know what I am doing wrong. My current effort is on the Testing website. Can anyone help please?

Dod

One thing you could do would be to post the table in rough form, then someone like myself or IAAD will reformat it, or you could email one of us to do the same.

Alternatively, can you describe what is actually happening, what it is you are seeing? I'm not sure what "corrupted" means in this context. That normally use to imply what we called computer "garbage".

PS, just copy and paste the table from Excel, and I think we could pick it up and reformat from the TLF post.

[Dod101]

Shares
Alliance Trust 4.57% 2.51% 2.51%
Unilever 4.56% 4.41% 4.42%
HSBC Holdings 4.47% 3.98% 4.06%
Shell 4.15% 3.68% 4.06%
Legal & General 3.84% 6.86% 8.15%
Astrazeneca 3.72% 2.13% 2.62%
National Grid 3.69% 3.89% 4.81%
Murray International 3.64% 3.32% 4.17%
Caledonia 3.64% 5.71% 7.16%
3i Infrastructure 3.43% 2.53% 3.36%
SSE 3.41% 3.75% 5.02%
Scottish Mortgage IT 3.38% 0.42% 0.57%
Diageo 3.27% 1.52% 2.12%
BAT 3.16% 5.23% 7.57%
Murray Income Trust 3.08% 2.93% 4.34%
Schroders 3.04% 3.72% 5.59%
Finsbury Growth & Income 2.96% 1.34% 2.06%
Chesnara 2.87% 5.23% 8.32%
JP Morgan Global Growth 2.77% 0.65% 1.06%
Phoenix Group 2.55% 5.04% 9.04%
Segro 2.49% 1.89% 3.47%
Admiral 2.48% 5.71% 10.49%
Schroder Oriental Income 2.48% 2.39% 4.39%
Primary Health Properties 2.47% 3.51% 6.50%
Toronto Dominion Bank 2.46% 2.03% 3.77%
GSK 2.42% 2.51% 4.73%
RIT Capital Partners 2.20% 0.95% 1.98%
Imperial Brands 2.11% 3.44% 7.45%
M J Gleeson 1.90% 1.29% 3.11%
Bank of Montreal 1.60% 1.10% 3.13%
Henry Boot 1.22% 0.73% 2.73%
Treatt 0.79% 0.07% 0.42%
Total Shares 94.83% 94.47% 4.55%

Bond Funds
Schroder Sterling Bond Fund 1.95% 1.49% 3.48%
Liontrust Bond 1.79% 1.90% 4.83%
M & G Securities High Yield 1.71% 2.13% 5.68%
Total BondFunds 5.46% 5.52% 4.61%

This is a straight copy and paste from Excel. Even using the financial software though, I still get one or two items which slip off to the adjoining column, IAAG's instructions are fine and I seem to be following them exactly. I am not normally so dim but am very frustrated by this.

The columns are (or would be if there were any) Capital, Dividend and Yield

If you can help Arb, I would be very grateful.

Dod

[stacker512]

I think the linked page that describes how to make the table, should have some info about how to use table column separators (it's mentioned for pre and code but not tables). A quick scan doesn't appear to show one. Otherwise, it seems to me like it would just be a table with one column and many rows.

I had hoped one could use tabs to separate the columns but that doesnt seem to work.

[IanTHughes]

Shares                      | Capital | Income | Yield 
Alliance Trust              |   4.57% |  2.51% |  2.51%
Unilever                    |   4.56% |  4.41% |  4.42%
HSBC Holdings               |   4.47% |  3.98% |  4.06%
Shell                       |   4.15% |  3.68% |  4.06%
Legal & General             |   3.84% |  6.86% |  8.15%
Astrazeneca                 |   3.72% |  2.13% |  2.62%
National Grid               |   3.69% |  3.89% |  4.81%
Murray International        |   3.64% |  3.32% |  4.17%
Caledonia                   |   3.64% |  5.71% |  7.16%
3i Infrastructure           |   3.43% |  2.53% |  3.36%
SSE                         |   3.41% |  3.75% |  5.02%
Scottish Mortgage IT        |   3.38% |  0.42% |  0.57%
Diageo                      |   3.27% |  1.52% |  2.12%
BAT                         |   3.16% |  5.23% |  7.57%
Murray Income Trust         |   3.08% |  2.93% |  4.34%
Schroders                   |   3.04% |  3.72% |  5.59%
Finsbury Growth & Income    |   2.96% |  1.34% |  2.06%
Chesnara                    |   2.87% |  5.32% |  8.32%
JP Morgan Global Growth     |   2.77% |  0.65% |  1.06%
Phoenix Group               |   2.55% |  5.04% |  9.04%
Segro                       |   2.49% |  1.89% |  3.47%
Admiral                     |   2.48% |  5.71% | 10.49%
Schroder Oriental Income    |   2.48% |  2.39% |  4.39%
Primary Health Properties   |   2.47% |  3.51% |  6.50%
Toronto Dominion Bank       |   2.46% |  2.03% |  3.77%
GSK                         |   2.42% |  2.51% |  4.73%
RIT Capital Partners        |   2.20% |  0.95% |  1.98%
Imperial Brands             |   2.11% |  3.44% |  7.45%
M J Gleeson                 |   1.90% |  1.29% |  3.11%
Bank of Montreal            |   1.60% |  1.10% |  3.13%
Henry Boot                  |   1.22% |  0.73% |  2.73%
Treatt                      |   0.79% |  0.07% |  0.42%
Bond Funds
Schroder Sterling Bond Fund |   1.95% |  1.49% |  3.48%
Liontrust Bond              |   1.79% |  1.90% |  4.83%
M & G Securities High Yield |   1.71% |  2.13% |  5.68%

Enjoy!


Ian

[stacker512]

I think the linked page that describes how to make the table, should have some info about how to use table column separators (it's mentioned for pre and code but not tables). A quick scan doesn't appear to show one. Otherwise, it seems to me like it would just be a table with one column and many rows.

I had hoped one could use tabs to separate the columns but that doesnt seem to work.

Looks like the column separator is a double-pipe (||). And still need to have a mysterious "L=" at the beginning of each row.

@Dod101, how does this look?

[Arborbridge]

I wasn't needed after all! Glad that someone is looking after Dod's table.


Arb.

[tjh290633]

If you copy an extract from a spreadsheet into the <pre> box, you should get a perfect result with a vertical bar separator. I prefer to use 3 spaces, which entails deleting what is shown on the input page and replacing with 3 spaces, but you don't have to.

For me the other options are too fiddly. Note that a blank first cell in your array will upset things. A full stop in that cell should prevent that.

TJH

[Arborbridge]

If you copy an extract from a spreadsheet into the <pre> box, you should get a perfect result with a vertical bar separator. I prefer to use 3 spaces, which entails deleting what is shown on the input page and replacing with 3 spaces, but you don't have to.

For me the other options are too fiddly. Note that a blank first cell in your array will upset things. A full stop in that cell should prevent that.

TJH

I don't have to think much about it: just copy the spread-sheet and paste in to the appropriate box in the table formatter:

http://lemonfoolfinancialsoftware.weebl ... ormat.html

Then choose one of the three output options and "preview" each to decide which one prefers.

Arb.

[Dod101]

I am really sorry for the fuss. Many thanks to all who have sorted out an elderly gent's incompetence. I may not be an elderly gent, but elderly at least is correct.

I will now put a commentary together to explain one or two bits and pieces and maybe post on the other dedicated thread.

I think my problem was with the original Excel table which I took from Money and had to covert to an Excel file.

Dod