Plotting External Values

[FX989231]

I can't seem to find an answer to my problem in my forum searches, so here is what I want to do:

I want to plot values in the non-price pane study. This values will range between 0 & 100. Every week there will be a new value. The value's are valid for one week. Example.

2 Oct 06 - 42
9 Oct 06 - 38
16 Oct 06 - 50

I have data for the last 2 years that can be plotted.

If no new date is entered then the latest entered value must plot until the next input. The point is that the data/value's are related to specific starting dates.

I do not mind entering these data direct into the EFS study every week, or if it is easy enough to read the info into the EFS then that is also an option, point is either the external file has to be updated manualy with the new info or the EFS must be updated manualy

Any help or short example will be appreciated.

Regards

[mbuta]

FX,

You need to do do one of the following two things:

a/ Either use Weekly time interval for your chart => one bar = one week, or

b/ Declare and calculate your data in inv("W") external time interval and observe all the rules and restrictions explained in Help file.

Then return the value and should have no problem. We all do this all the time since EFS2. It is a very common procedure and should have plenty of examples, just search for External Time Intervals.

Good Luck!

[FX989231]

mbuta

Thank you, but I do not think you understand what I want.

I am not reading data from any other symbol or chart into my study.

The data got nothing to do with any symbol or study available in eSignal.

Based on fundamentals I arive at a calculated figure for that week. I want to plot these figures in the NonPricePane relative to the week it is valid for.

As I said in my first post I did search the forums for help and examples both on External Time frames and Data but all these posts talk about is importing data calculated on some other symbol or study.

All I want to do is plot the data in a graph like you would do in Excel:
Date1 - Value1
Date2 - Value2
etc.

I have no idea how to get this data to plot as I suggested in my original post.

If it is as easy as you suggest, then I would appreciate it if you can post something short that plot say only 3 values between 0 and 100 where every value is valid for one week no matter what interval is used (Obviously not longer than one week)

I would appreciate it very much.

Regards

[FX989231]

Here is an example

Hope it is more clear

[mbuta]

Sorry, but in this case I have no clue.
Maybe one of the experts can help.
You want to import data.

However, I can tell one trick: In Data Manager, you can correct ticks and data, so you can populate there your data, but I doubt you can preserve it between sesions.

[Guest]

Alex, Steve, etc, any ideas?

Regards

[Guest]

Hi Kobus,

Yes, this is similar to something I was working on. I'll know better this evening (US eastern time) if I have some extra time to help you (or your alter ego) out on this.

[FX989231]

It will be much appreciated if you can.

Thanks in advance

Regards

[Guest]

Hi Kobus,

Access to your data within an efs would require the data being saved in a text file, further, it will have to be in the eSignal formula output path.

Knowing that, please save your data to a text file and attach it to a post. The information you showed in an earlier post is close, but not sufficient to complete development (see below), and using actual file data would save me time and effort coding a solution. Also, I will need the exact path and file name where you want to save the data.

Several more things.
[list=1][*]Chart Timeframe - what chart timeframes are you considering?[*]File Data - Needs to be comma delimited between the date and the data. The date can be delimited with '/' or '-'...[*]Load Historical Data - do you want the chart to load historical values or only the most recent value?[*]Data Values - do you want the values displayed in the Cursor Window and / or displayed in a text box?[*]Colors and thickness - What color do you want the lines, what thickness,etc. If you want text boxes, what font, color, foreground and background color?[/list=1]

If you can supply this info in a post, I will do my best to put something together to help you out in the next several days.

Thanks,

[FX989231]

Steve

Thank you very much, the answers are as follows:

Chart Timeframe - what chart timeframes are you considering?

This is weekly data, I would like it to plot on a Weekly chart and a Daily chart.

Load Historical Data - do you want the chart to load historical values or only the most recent value?

I would like all the data in the file to load and plot.

Data Values - do you want the values displayed in the Cursor Window and / or displayed in a text box?

No need for a text box

Colors and thickness - What color do you want the lines, what thickness,etc. If you want text boxes, what font, color, foreground and background color?

Lines can be blue, thickness 2
If possible you can add a MA plot of the data on the same window, maybe a Red line, thickness 2.

Regards

[FX989231]

Steve

The pathname for the data will be:

Program Files/eSignal/Formulas/Kobus

I attach an image to illustrate the desired effect of the plot.

Please let me know if this is suffiecient or you need more info.

Thank you for your time and patience.

Regards

[Guest]

Originally posted by FX989231
Steve

The pathname for the data will be:

Program Files/eSignal/Formulas/Kobus

That will not work, unless you have changed the default output path, the default path for the data file that must be read is C:\Program Files\eSignal\FormulaOutput.

I also wanted you to attach an example file in a format that follows the conventions I discussed with the same name that you will be using.

You did not answer whether you wanted the values displayed in the Cursor Window, just the part about the text box.

Regarding the MA, I am assuming you mean the file data, please clarify.

[FX989231]

Steve

I attached a file in the previous post named "datagbp"
I created the data in Word and saved in as text, please advice if
the file is correct or you want corrections. I also do not know ib what order the data must be, example: oldest data first or newest data first.

Sorry for the half answer on the Cursor Window, yes I would like it to display in the Cursor Window.

Yes the MA on the file data.

Regards

[FX989231]

Steve

I attach the Word doc that contain the Data in case the text file does not come out correct

Regards

[Guest]

Kobus,

I did not see the file, sorry for missing that.

The file does require modification. Each data set should be on it's own line. The preferred sort is oldest to newest, but the data can be sorted within the efs if necessary. Please let me know if it must be sorted, it is relatively straightforward.


The file can also be a csv file if you want. Saving it directly or an export from excel in that format is relatively straightforward and may be the easiest for you in the long run. I attached a simple file that was output from excel as a csv file. (I had to modify the extension since a csv extension is not recognized as a valid attachment in a post.)