All Questions

Introduction

I recently learned to chart Medias Móviles Simples( abbreviated "SMA" ) using the library of MatPlotLibFinancein Python3, which Medias Móviles Simplesare trend lines that help the investor in determining good times to enter to buy or sell an asset.

Data

The following variables contain the data used in the Script to plot the price action, the first variable was named as df_trading_pairand contains the following information:

For its part, the other named variable df_trading_pair_date_time_indexcontains the same information as the previous variable with slight modifications, since it can only be used in this way in the script below:

def set_DateTimeIndex(df_trading_pair):
    df_trading_pair = df_trading_pair.set_index('Start Date', inplace=False)
    # Rename the column names for best practices
    df_trading_pair.rename(columns = { "Open Price" : 'Open',
                                       "High Price" : 'High',
                                       "Low Price" : 'Low',
                                       "Close Price" :'Close',
                              }, inplace = True)
            
    return df_trading_pair
 # Create another df just to properly plot the data
 df_trading_pair_date_time_index = set_DateTimeIndex(df_trading_pair)

script

The following script will essentially seek to create a Japanese candlestick chart using the information stored in the variables df_trading_pairand df_trading_pair_date_time_index, its main details are explained as comments within the script:

import pandas as pd
import mplfinance as mpf
import matplotlib.pyplot as plt
import matplotlib.dates as mdates

trading_pair = "SOLBUSD"
# Plotting
# Create my own `marketcolors` style:
mc = mpf.make_marketcolors(up='#2fc71e',down='#ed2f1a',inherit=True)
# Create my own `MatPlotFinance` style:
s  = mpf.make_mpf_style(base_mpl_style=['bmh', 'dark_background'],marketcolors=mc, y_on_right=True)    

# Plot it
# First create a dictionary to store the plots to add
subplots = {'Low SMA 9': mpf.make_addplot(df_trading_pair['Low SMA 9'], width=1, color='#F0FF42'),
            'Close SMA 25': mpf.make_addplot(df_trading_pair['Close SMA 25'], width=1.5, color='#EA047E'),
            'High SMA 99': mpf.make_addplot(df_trading_pair['High SMA 99'], width=2, color='#00FFD1')}

trading_plot, axlist = mpf.plot(df_trading_pair_date_time_index,
                    figratio=(10, 6),
                    type="candle",
                    style=s,
                    tight_layout=True,
                    datetime_format = '%H:%M',
                    ylabel = "Precio ($)",
                    returnfig=True,
                    show_nontrading=True,
                    addplot=list(subplots.values())
                    )

# Add Title
symbol = trading_pair.replace("BUSD","")+"/"+"BUSD"
axlist[0].set_title(f"{symbol} - 3m", fontsize=25, style='italic', fontfamily='fantasy')

# Find which times should be shown every 6 minutes starting at the last row of the df
x_axis_minutes = []
for i in range (1,len(df_trading_pair_date_time_index),2):
    x_axis_minutes.append(df_trading_pair_date_time_index.index[-i].minute)

# Set the main "ticks" to show at the x axis
axlist[0].xaxis.set_major_locator(mdates.MinuteLocator(byminute=x_axis_minutes))

# Set the x axis label
axlist[0].set_xlabel('Zona Horaria UTC')

# Set the SMA legends
# First set the amount of legends to add to the legend box
axlist[0].legend([None]*(len(subplots)+2)) 
# Then Store the legend objects in a variable called "handles", based on this script, your objects to legend will appear from the third element in this list
handles = axlist[0].get_legend().legendHandles
# Finally set the corresponding names for the plotted SMA trends and place the legend box to the upper left corner of the bigger plot
axlist[0].legend(handles=handles[2:],labels=list(subplots.keys()), loc = 'upper left')

Finally, this script will produce the following image:

Problem

Comparing the chart printed by my script with the chart displayed by Binance:

It is evident that the largest moving average (that of 99) was not printed as such, or it was, I think that due to the size established ( figratio=(10, 6)) for the same chart it does not appear.

The doubt

How could I make a kind of " Zoom Out" with the script so that when printing the graph it is possible to show the moving average of 99 without compromising much the appreciation of the other elements printed on the graph?

Hoping that everyone is doing well, I have had an inconvenience (Perhaps as a newbie) when I wanted to save information in my database from php to MySQL.

Describing the workflow of my little website.

Previously, I requested help on this page to achieve that based on a "trigger" click that would update a specific div where the information would be. I've already done that, thank you very much. Now, in a certain update of the div, I get to one where it consists of seeing some entries already made and a section to be able to make a comment, a more specific form. Basically there is only a textarea to insert the comment itself, the other data is collected from the current session and others (we will emphasize later), and a button which, in theory, is supposed to trigger a certain php code to insert the record in question.

What have I tried?

Based on the extensive php and mysql video tutorials we find all over the internet, the methodology is almost the same itself, but oddly enough, it doesn't work for me.

What I currently have in my code is the following:

<form action="" class="ejemplo" method="POST">

    <!-- <input type="text" name="respuesta"> -->
    <input type="submit" name="guardar" value="Enviar respuesta">

    <textarea name="respuesta" name="respuesta"></textarea>

    <?php 
        //if (isset($_POST['guardar'])) {
            $textor = mysqli_real_escape_string($con, $_POST['respuesta']);
            //if(empty($textor)){
                echo "<font>Introduzca algo!</font>";
            //}else{
                $fechareg = date('d-m-Y H:i:s');
                echo $fechareg;
                echo $textor;
                $sentencia = "INSERT INTO respuestas(n_control, id_pregunta, contenido, fecha) VALUES ('{$_SESSION['usuario']}','{$id}', '{$textor}', '{$fechareg}')";
                $result = mysqli_query($con, $sentencia);

            //}
        //}
    ?>

</form>

Before I clarify, you will see the if with the isset commented, since, if I ignore that validation, it DOES execute the query, but wrongly done, the user respects it, the id also, the content is blank, and the date as 0000 -00-00 00:00:00. The strange thing is also that in the echo of the variables where the date is supposed to be, it comes out fine, it is printed correctly, the text is still blank.

Now when that piece of code is executed, it prints:

Warning: Undefined array key "respuesta" in C:\xampp\htdocs\pag\ver_datos.php on line 80

As if the "answer" did not exist, but it is well raised in the form in its name. If I leave the if of isset, it just refreshes the page and does absolutely nothing, not even insert. You may also admire that it tries a simple input text and likewise it doesn't recognize it, it doesn't retrieve your text.

I heard that it can also be done through ajax, but I wouldn't know how to use it, I'm a newbie here. In the same way, do it in a separate php, but I can't find how to pass the variables such as the id.

I add the code of how the id and the user are obtained (That's right, based on what was previously selected, I get the id with post):

<?php 
    $id = $_POST['id'];
    $titulo = $_POST['titulo'];
    include("conexion.php");
    $con=conectar();
    session_start();
?>

If it is useful, I will tell you that above I receive other comments from other users. That works correctly.

Why is it that it doesn't even recognize the name of the input, and the date prints it fine but when sending it to the database it puts it in 0's? What am I doing wrong?

Let's see if someone can enlighten

I've been messing around all day with how to change an image when clicking on another using javascript, but when calling an element of the document, it throws me the null value

I have the id = "OneOne" in the image of the HTML document;

When clicking on it, through the onclick event, I send the id of the image and the position it occupies as a parameter, in this case it would be "UnoUno" and "0"

In the function that receives the onclick event I try to reference the image I clicked on to change it to another, and I always receive null

let ele = "#" + elemento; //resultado: "#UnoUno"
let control = document.getElementById(ele); //control: null

I've been with this error for a few hours, I've searched, read, reread and I can't find the error that I'm causing

What am I doing wrong?

Part of the affected HTML file:

 <body>
     <main>
         <section class="section">  
              <table class="table">
                 <tr>
                     <td>
                         <img id = "UnoUno" class="img" src="./img/reverso.png" alt="imagen11" onclick="abrirImagenClick('UnoUno', '0')">
                     </td>
                 </tr>
             </table>
         </section>
     </main>
 </body>

Part of the affected CSS file

.table tr td img:hover
{
    border: 3px solid #fe0101;
}

.img
{
    height: 150px;
    width: 110px;
}

Affected part of javascript file

//recibo por parámetro con el evento onclick, el elemento cliqueado y la posición que ocupa
function abrirImagenClick(elemento, posicion)
{
    //variable que concatena el elemento con la almohadilla
    let ele = "#" + elemento;
    //variable que debería de almacenar el elemento del documento donde deseo cambiar la imagen
    //pero me devuelve null
    let control = document.getElementById(ele);
    imagen = document.createElement("img");

    imagen.src = "img/" + barajaBarajada[posicion];

    //control.appendChild(imagen);
}

#include <stdio.h>
#include <iostream>
#include <math.h>
#include <sstream>
main ()
{
    float sueldo,nomina,suma;
    int i;
    
    std::string empresa;
    
    std::cout<<"Introduce el nombre de la empresa:"<<"\n";
    std::getline(std::cin,empresa);
    
    for (i=1;i<=12;i++)
    {
        std::cout<<"Introduce el sueldo del trabajador"<<i<<":"<<"\n";
        std::cin>>sueldo;
        suma=suma+sueldo;
    }
    nomina=suma;
    std::cout<<"La empresa "<<empresa<<" debe pagar una nomina de: "<<suma;
    
    return 0;
}

I don't have an idea of ​​how to pass this same program using the While cycle, could someone help me, the problem says that 12 salaries are entered and that in the end the payroll to be paid by said company is printed, which was previously requested name too.

Good afternoon, I have the following problem within an ngfor, so far it complies with the values, but I would like the condition All to be greater than or equal to 9 to only be repeated once and for all the keys of the program to be shown in the tooltip .

Until now it is all I have, when it does not comply it is shown separately and the respective key, but if I want that when they are all the other condition is fulfilled and in the tooltip it shows all the names of the programs separated by commas.

<div *ngFor="let clave of Proyecto.j_programa" class="listar_programas">
   <span pTooltip="{{clave.programa}}" tooltipPosition="bottom" class="font-bold">{{ Proyecto.j_programa?.length  >= 9 ? 'Todos' : clave.clave_programa+', '}}</span>
</div>

Likewise, I don't know how to use the join function on the key.program_key variable since I currently concatenate it like this > +', ' and I want the last element to have a period or not show anything.

Currently it prints like this: GA, IA, II,

something like this: GA, IA, II.

I read that with .join but it gives me the result and everything bugs.