Help Amibroker AFL .. plot from CSV data

zel

New Member
#1
Hi All,


Please help me with Amibroker AFL
I have CSV data contains 3 columns
1. Stock Name
2. Date
3. HIT1 (my custom value number for the date and not every rows got this value )

NAME DATE HIT1
GOOG 3/15/2021 28
GOOG 3/12/2021 26
GOOG 3/10/2021 33
GOOG 3/9/2021 37
GOOG 3/8/2021 27
GOOG 3/5/2021 28
GOOG 3/4/2021 25
GOOG 3/3/2021 28
GOOG 3/2/2021 12
GOOG 3/1/2021 22
GOOG 2/26/2021 34
GOOG 2/25/2021
GOOG 2/24/2021
GOOG 2/23/2021
GOOG 2/22/2021 42
GOOG 2/19/2021
GOOG 2/18/2021
GOOG 2/17/2021
GOOG 2/16/2021
GOOG 2/15/2021
GOOG 2/11/2021 20

I would to plot the HIT1 as line chart or histogram chart in the Amibroker , and each blank rows can't be set as ZERO value.

I've tried to plot it but failed to draw a line chart or histogram bar, my result is only horizontal line not line chart or histogram .


thank you for kind attention

regards

Zel
 
#2
how is the custom HIT1 field calculated. You can simply create an array in the afl for HIT1 and then plot the values in a pane using the plot functions. If you can share the formula to HIT1 then I can share the afl
 

zel

New Member
#3
Hi Ike,
Thank you for prompt response.

the HIT1 are not a formula... merely a random value that written in the csv. These data are not related with the price, volume.
 
#4
Be blessed By the Divine, Have a Good Day to Dear Seniors,
One copied afl and modified with additional ema kindly rectify this, my requirement as I mestioned as follow:

1.EMA 5,8,13,40 exact crossover and crossunder with Buy and Sell arrow marks.
2.Screener and exploration need.
3. It should be wroked in all time frame.
I have tried but not showing exact Buy & and Sell arrows and also not giving signal in Screener and Exploration.
Kindly help me and Your favour is high valuble.
 

Attachments

#5
Hi Ike,
Thank you for prompt response.

the HIT1 are not a formula... merely a random value that written in the csv. These data are not related with the price, volume.
You will have to insert that value in aux1 or aux2 fields and then simply use plot functions to plot it on the chart. It pretty darn simple once you figure out how to import this set of data into the amibroker database.
 

Similar threads

Zerodha – Open Paperless Account

Open online account with Zerodha. Free delivery trading and Max Rs 20 for Intraday, F&O, Currency and Commodity Trading. Intraday High leverage with MIS, CO and BO.

Name:Phone:
Email:City:
State:
Are you a day trader?