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
Got a credit card? use our Credit Card & Finance Calculators
Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site
Eventide's tlfaddin - share prices in Excel
-
- Lemon Quarter
- Posts: 4133
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3287 times
- Been thanked: 2869 times
Re: Eventide's tlfaddin - share prices in Excel
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
--kiloran
-
- Lemon Quarter
- Posts: 1347
- Joined: November 4th, 2016, 12:11 pm
- Has thanked: 124 times
- Been thanked: 856 times
Re: Eventide's tlfaddin - share prices in Excel
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
-
- Posts: 4
- Joined: December 14th, 2016, 1:59 pm
-
- Lemon Quarter
- Posts: 4133
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3287 times
- Been thanked: 2869 times
Re: Eventide's tlfaddin - share prices in Excel
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
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 8 guests