Page 1 of 1

Eventide's tlfaddin - share prices in Excel

Posted: June 5th, 2023, 4:24 pm
by funduffer
Hi,

This thread is about Eventide's Excel addin which enables you to get up-to-date share prices in your Excel sheet, using the getdata function.

https://lemonfoolfinancialsoftware.weeb ... excel.html

It has stopped working, due to the same problem that HYPTUSS has had, I believe.

I use this in my portfolio tracking spreadsheets, and it is incredibly useful.

I understand that there is no commitment for Eventide to keep this up to date, but it would be very useful if someone could take a look and update it. I don't think there is much to alter, but my programming skills are, I am afraid, too out of date to attempt this myself. (I.e FORTRAN in the 1970's!). I did attempt this myself, and thought I had fixed it, but it seems not.

Much appreciated if someone more competent than me could do this, or suggest an alternative.

FD

Re: Eventide's tlfaddin - share prices in Excel

Posted: June 5th, 2023, 5:21 pm
by kiloran
It's on my to-do list, but it will probably be a couple of weeks before I have time to look at it

--kiloran

Re: Eventide's tlfaddin - share prices in Excel

Posted: June 5th, 2023, 7:14 pm
by funduffer
kiloran wrote:It's on my to-do list, but it will probably be a couple of weeks before I have time to look at it

--kiloran

Thank you, kiloran.

You are an absolute legend!

FD

Re: Eventide's tlfaddin - share prices in Excel

Posted: November 2nd, 2023, 3:31 pm
by LobsangRamper
Was there any progress with this, kiloran ?

Re: Eventide's tlfaddin - share prices in Excel

Posted: November 2nd, 2023, 3:50 pm
by kiloran
LobsangRamper wrote:Was there any progress with this, kiloran ?

Only a very cursory look so far. Certainly if I make any progress with it, there would be a much more restricted range of data items to report. EvenTide's code had 19 data items that could be reported.

Code: Select all

Case 1, "n", "nm", "name", "longname", "shortname"
Case 2, "b", "bid"
Case 3, "a", "ask", "offer"
Case 4, "l", "l1", "last"
Case 5, "c", "c1", "chg", "change"
Case 6, "prv", "prvcls", "close", "previousclose"
Case 7, "daylow", "dl"
Case 8, "dayhigh", "dh"
Case 9, "52wk_low", "52wl"
Case 10, "52wk_high", "52wh"
Case 11, "delay", "exchangedelay"
Case 12, "ccy", "currency"
Case 13, "type", "quotetype"
Case 14, "mktcap", "mc", "marketCap"
Case 15, "divyld", "dy", "dividendyield"
Case 16, "d", "div", "ltmdivs"
Case 17, "e", "eps"
Case 18, "50dma"
Case 19, "200dma"

I think another 2 were added later.

With the loss of the Yahoo Finance API, the range of data items would be much more restricted, so maybe not worthwhile.

Also I've never written code for an Excel (or LibreOffice) extension, so that's a learning curve I have to tackle.

I haven't rejected the idea, but it's some way down my list of priorities right now. Very much a project for a cold, snowy week in winter!

--kiloran