Heads up,
I see the newest datasheet has the company above, yet for me when I try to add it as a share the sheet picks up the header of the datasheet so although I can add EPIC shares and pull a price the description for the first 3 columns is
Data Sheet Name EPIC New Data Sheet Sector,
EPIC - Ediston Property
-
- Lemon Quarter
- Posts: 2718
- Joined: November 5th, 2016, 10:30 am
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: EPIC - Ediston Property
Good timing! I'm working on final tests and documentation for a new release, so I'm glad you didn't find this problem after I've published the new version.kempiejon wrote:Heads up,
I see the newest datasheet has the company above, yet for me when I try to add it as a share the sheet picks up the header of the datasheet so although I can add EPIC shares and pull a price the description for the first 3 columns is
Data Sheet Name EPIC New Data Sheet Sector,
I can see the problem on both the Excel and LibreOffice versions, amazed that nobody has picked up on this previously.
I'll work on a fix
--kiloran
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: EPIC - Ediston Property
Not fully tested, but it looks like the following changes will fix the problem:kiloran wrote:Good timing! I'm working on final tests and documentation for a new release, so I'm glad you didn't find this problem after I've published the new version.kempiejon wrote:Heads up,
I see the newest datasheet has the company above, yet for me when I try to add it as a share the sheet picks up the header of the datasheet so although I can add EPIC shares and pull a price the description for the first 3 columns is
Data Sheet Name EPIC New Data Sheet Sector,
I can see the problem on both the Excel and LibreOffice versions, amazed that nobody has picked up on this previously.
I'll work on a fix
--kiloran
- Company Data Sheet, change the heading in cell C1 from "EPIC" to anything else. For example "EPIC symbol" or "Symbol"
- Company Data Sheet. Locate the row for Ediston Property Investment Company, and change column D from "New Data Sheet Sector" (a total screw-up on my part) to "IT - Property - UK Commercial"
-
- Lemon Quarter
- Posts: 2718
- Joined: November 5th, 2016, 10:30 am
Re: EPIC - Ediston Property
Ta. That looks like it works and makes sense to me, it's not EPIC anyway as technically it's TIMD - Tradable Instrument Display Mnemonics
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: EPIC - Ediston Property
Seems to work OK on the testing I have done. I think I'll use the reference "Symbol" since it's not even EPIC/TIDM. It's the Yahoo stock symbol minus the ".L" suffix. It's generally the same as EPIC/TIDM but with some differences, such as BT-A vs BT.Akempiejon wrote:Ta. That looks like it works and makes sense to me, it's not EPIC anyway as technically it's TIMD - Tradable Instrument Display Mnemonics
Thanks for highlighting the problem.
--kiloran
-
- Lemon Quarter
- Posts: 2718
- Joined: November 5th, 2016, 10:30 am
Re: EPIC - Ediston Property
Glad to help. Thaks for the extra details about the EPIC too. I had noticed BT.kiloran wrote:Seems to work OK on the testing I have done. I think I'll use the reference "Symbol" since it's not even EPIC/TIDM. It's the Yahoo stock symbol minus the ".L" suffix. It's generally the same as EPIC/TIDM but with some differences, such as BT-A vs BT.Akempiejon wrote:Ta. That looks like it works and makes sense to me, it's not EPIC anyway as technically it's TIMD - Tradable Instrument Display Mnemonics
Thanks for highlighting the problem.
--kiloran