No. of Recommendations: 4
ThyPeace, all we have to go on is data from the past and some of us prefer to see it in graphic rather than in tabular form. That's what makes Klein charts so useful. We need more of them, on demand. At least I do!

I started my professional life programming mainframes and it was actually easy because we only had about 20 or so instruction to talk to the CPU with. Modern computer languages have hundreds of instruction and we can make up more complex ones on the fly. In investing terms, switching costs become increasingly high -- exponentially! Young people learn the new stuff, old ones want to stick with the old ones.

One way to simplify things is to use frameworks. For someone who likes to write code (me) it is as easy to create one as it is to learn one created by someone else in the hope you'll like it. I'm on the third version of my php framework -- entirely OOP and semantic in design. So I'm stuck with LAMP which has lots of missing features such as a good math library (phpExcel, maybe Python), graphic rendering (Javascript), and other odds and ends. Then there is the increasing complexity of interacting with Yahoo's API, a necessity because Yahoo is still the best source of free price data.

Progress Report

For the graphics rendering I'm going to try Chart.js (JavaScript). I've downloaded the library and got it working.

Python might solve the Yahoo API problem and might even replace phpExcel which is huge and deprecated to boot. Python 2.7 comes installed in Macs and I've installed Python 3.7 as well. I got php to talk Python (more or less).

Now I have to decide to start with the rendering (JavaScript) or with the data acquisition (Python).

Suggestions welcome!

Denny Schlesinger
Print the post Back To Top
No. of Recommendations: 1
Not to rain on your parade, but phpExcel is deprecated and not maintained and they suggest people to switch to phpSpreadsheet

https://github.com/PHPOffice/PHPExcel

If you're going to learn it, I'd learn the one that is maintained, there might be something in the old one that doesn't work with modern web technologies
Print the post Back To Top
No. of Recommendations: 1
Not to rain on your parade, but phpExcel is deprecated and not maintained and they suggest people to switch to phpSpreadsheet

Yes, I know it's deprecated. I'm using phpExcel in my Portfolio webapp so I'm quite familiar with it. I use it for its math library (Excel functions) and that is not likely to change. These are the same functions that I used in Excel 4 which seems a lifetime ago!

If I could find a charting, drawing class library in php I would prefer to use that instead of phpExcel/phpSpreadsheet. Do you know of any?

Thanks!

Denny Schlesinger
Print the post Back To Top
No. of Recommendations: 0
Yes, I know it's deprecated. I'm using phpExcel in my Portfolio webapp so I'm quite familiar with it. I use it for its math library (Excel functions) and that is not likely to change. These are the same functions that I used in Excel 4 which seems a lifetime ago!

If I could find a charting, drawing class library in php I would prefer to use that instead of phpExcel/phpSpreadsheet. Do you know of any?


Sorry, we actually use node, but haven't found any modules that have decent graphing and regression features, which is why I was looking at phpExcel when you mentioned it. Best of luck!
Print the post Back To Top
No. of Recommendations: 5
Hi Denny!

This sounds like a good idea. I guess what you're saying is you'd like to be able to generate the CAGR charts for any stock you come up with. I simply have not put any emphasis into interactive web software in my career (I do more with deep physical/math modeling and currently mainly Python, previously Octave). To my knowledge Javascript would be the main vehicle, as I think maybe jck101 implied, because it's built to be interactive in the browser and has wildly varied choices for charting and other display. The current BMW charts are built with Perl in an extremely primitive fashion. But it keeps working... the code is now over a decade old.

-Mike
Print the post Back To Top
No. of Recommendations: 0
I guess what you're saying is you'd like to be able to generate the CAGR charts for any stock you come up with.

Yes!

I simply have not put any emphasis into interactive web software in my career (I do more with deep physical/math modeling and currently mainly Python, previously Octave).

Most of the website work I've done is interactive screens usually powered by a relational database sticking as closely as possible to Apple's user interface guidelines. Design and graphics are not my thing. I've played around a bit with Python but I'm trying to stick with php which by version 7 is very powerful. I've switch almost entirely to OOP.

To my knowledge Javascript would be the main vehicle, as I think maybe jck101 implied, because it's built to be interactive in the browser and has wildly varied choices for charting and other display.

Javascript is a language I loved to hate because it was so difficult to debug but now Safari has some really good developer tools built in. But you are right, maybe that's the way to go. The latest version of my Portfolio webapp runs on php 7, some Javascript in the user interface, a home grown version of AJAX, and MySQL/MariaDB.

One unsolved problem I have is downloading price history from Yahoo - the crumb! Can you help?

Denny Schlesinger
Print the post Back To Top
No. of Recommendations: 2
Holy Guacamole!

Chart.js
Simple yet flexible JavaScript charting for designers & developers


https://www.chartjs.org/

Denny Schlesinger
Print the post Back To Top
No. of Recommendations: 0
Holy Guacamole!

Chart.js
Simple yet flexible JavaScript charting for designers & developers

https://www.chartjs.org/


You found the add in my company currently uses for charts and it is pretty good, but a few things it doesn't do well.

It is your resolution but if I were you I'd do a tutorial on a MEAN stack and see how that fit in with what you're trying to do. Mean is Mongo DB, Express, Angular, Node and is fairly common, although I'd maybe skip the Angular and just use the what is in express.

If you do decide to go the javascript route and want other contributors, put it on git or bitbucket and I'd be happy to spend some time on it.

For stock history, check this out:

https://github.com/AndrewRPorter/yahoo-historical

it is in PHP so maybe it would work better for you. Although seems like Yahoo changed their API so maybe not working currently. There are a couple other options for those quotes. Just search github.
Print the post Back To Top
No. of Recommendations: 1
I'm sticking with LAMP. I no longer do any commercial work so it's not worth my while to start learning afresh. I'm happy to use JavaScript so long as I can find a library I can just drop in. I gave Chart.js a quick look and got it working ASAP. I'll see how well it does.

The yahoo-historical is in Python, not php. It uses the new Yahoo API. I'll give it a try.

Thanks,

Denny Schlesinger
Print the post Back To Top
No. of Recommendations: 2
Chiming in just to note that everyone on this thread (not me) deserves a few dozen recs for considering this. Thank you!

ThyPeace, yes, I'm still around and reading.
Print the post Back To Top
No. of Recommendations: 4
ThyPeace, all we have to go on is data from the past and some of us prefer to see it in graphic rather than in tabular form. That's what makes Klein charts so useful. We need more of them, on demand. At least I do!

I started my professional life programming mainframes and it was actually easy because we only had about 20 or so instruction to talk to the CPU with. Modern computer languages have hundreds of instruction and we can make up more complex ones on the fly. In investing terms, switching costs become increasingly high -- exponentially! Young people learn the new stuff, old ones want to stick with the old ones.

One way to simplify things is to use frameworks. For someone who likes to write code (me) it is as easy to create one as it is to learn one created by someone else in the hope you'll like it. I'm on the third version of my php framework -- entirely OOP and semantic in design. So I'm stuck with LAMP which has lots of missing features such as a good math library (phpExcel, maybe Python), graphic rendering (Javascript), and other odds and ends. Then there is the increasing complexity of interacting with Yahoo's API, a necessity because Yahoo is still the best source of free price data.

Progress Report

For the graphics rendering I'm going to try Chart.js (JavaScript). I've downloaded the library and got it working.

Python might solve the Yahoo API problem and might even replace phpExcel which is huge and deprecated to boot. Python 2.7 comes installed in Macs and I've installed Python 3.7 as well. I got php to talk Python (more or less).

Now I have to decide to start with the rendering (JavaScript) or with the data acquisition (Python).

Suggestions welcome!

Denny Schlesinger
Print the post Back To Top