stock market portfolio script

[shaymiller]

I buy & sell stocks daily and unfortunately, my broker doesn't provide kind of analysis I need on my history. I want to khow daily, weekly, monthly income. Which stock makes more profit. how long stock was held before being sold etc.

which script can I use or any other website out there which can help me see analysis I want.

I looked up admin dashboard, but its too much work. I already have a simple script, where I can each trade in mysql & now I need to display the results.


eg. https://www.google.com/search?q=adm...XPxVkKHUvdBecQ_AUoAXoECAkQAw&biw=1920&bih=969

 

[xHolyy]

I buy & sell stocks daily and unfortunately, my broker doesn't provide kind of analysis I need on my history. I want to khow daily, weekly, monthly income. Which stock makes more profit. how long stock was held before being sold etc.

which script can I use or any other website out there which can help me see analysis I want.

I looked up admin dashboard, but its too much work. I already have a simple script, where I can each trade in mysql & now I need to display the results.


eg. https://www.google.com/search?q=admin+dashboard+template+php+free&source=lnms&tbm=isch&sa=X&ved=2ahUKEwitz7CX7ZLuAhXPxVkKHUvdBecQ_AUoAXoECAkQAw&biw=1920&bih=969

Dear Shay,

You will probably create this on your own because you want to display the results and make analysis out of it.
You will need to set-up a database connection within PHP first, I will advice you to use PHP PDO for it (Safest way to make a MySQL connection from your PHP if you are not using any PHP Framework).

Probably you got a connection like that already because you insert records at this moment to your MySQL.
What you need to make is the following:

1. First get all the records By SELECT * FROM table;
2. Now loop trough all items with a foreach($aRecords as $aRecord) the a before the naming stands for Array.
3. Display them in a table with the following example:

<?php
    
    foreach($aRecords as $aRecord)
    {
        echo
            '
            <tr>
                <td>'. $aRecord['example_variable'] .'</td>
            </tr>
            ';   
    }

?>

I hope this well help you in the correct way to get what you want.

 

[oldjolan700]

Display them in a table with the following example

This doesn't seem enough for what he want, if i'm not wrong he want to analyze theses datas then showing the result.

What can of calculations do you want to make and what infrastructure do you have to upload to mysql ?

 

[opeyemidy]

I think he wants some sort of data filtering base on parameters such as stock value, income and date

 

[xHolyy]

This doesn't seem enough for what he want, if i'm not wrong he want to analyze theses datas then showing the result.

What can of calculations do you want to make and what infrastructure do you have to upload to mysql ?

I understand that he wants to do that, But I helped him to start how he can do it.
You can easily track analysis from it when you put all the data in MySQL and then return it to a Chart.JS

 

[shaymiller]

I understand that he wants to do that, But I helped him to start how he can do it.
You can easily track analysis from it when you put all the data in MySQL and then return it to a Chart.JS

yes, thats exactly what I am looking for. I don't need high level stock analysis script. this is for myself. I mentioned Stock market analysis, to give an idea what I am trying to do.

I am looking the History data. I did come across chart.js but can't seem to work


any working php code?

what you posted on your first is basic, which I know. I need table charts, bar graphs.

I think he wants some sort of data filtering base on parameters such as stock value, income and date

I have those already.

 

[skule]

yes, thats exactly what I am looking for. I don't need high level stock analysis script. this is for myself. I mentioned Stock market analysis, to give an idea what I am trying to do.

I am looking the History data. I did come across chart.js but can't seem to work


any working php code?

what you posted on your first is basic, which I know. I need table charts, bar graphs.


I have those already.

What about websockets?