Plotting Economic Data
-
- Posts: 50
- Joined: 11 Nov 2005
- Contact:
Plotting Economic Data
I have economic data in a spread sheet that I'd like to plot on a daily chart. Can this be done?
- Dave Masalov
- Posts: 1712
- Joined: 16 Apr 2010
- Has thanked: 51 times
- Been thanked: 489 times
Re: Plotting Economic Data
Dear t123knight,
Could you please be more precise? In what format do you have the data? Is it an ASCII file?
Could you please be more precise? In what format do you have the data? Is it an ASCII file?
-
- Posts: 50
- Joined: 11 Nov 2005
- Contact:
Re: Plotting Economic Data
I have the data is in an excel spread sheet. One column is a date the other is a numerical value. The data is reported twice a month.
- Dave Masalov
- Posts: 1712
- Joined: 16 Apr 2010
- Has thanked: 51 times
- Been thanked: 489 times
Re: Plotting Economic Data
Dear 123knight,
Is this end of day data? If the numerical data is Close, you need to duplicate this column three times in Excel. Thus, you can successfully import this file via Quote Manager --> File --> Import --> ASCII: date, open, high, low, and close columns and plot a daily chart.
Is this end of day data? If the numerical data is Close, you need to duplicate this column three times in Excel. Thus, you can successfully import this file via Quote Manager --> File --> Import --> ASCII: date, open, high, low, and close columns and plot a daily chart.
-
- Posts: 50
- Joined: 11 Nov 2005
- Contact: