I would like to have a script that plots stock market profiles. I don’t know how to script, but perhaps someone could write this for me for a small fee?
Ideally, I would like to copy data from an excel file, paste into an applescript window and have the script produce a window with the stock profile. Data entry could also be done directly into an applescript field.
Here is an example of the data and the corresponding graph:
Data (from an open office or Excel file: ( I only included Y to B time periods, in reality the time periods extend from Y to O.
(Time Period) (Value)
Y 115 109
Z 110 104
A 107 99
B 106 95
C (etc)
D
E
F
G
H
I
J
K
L
M
N
O
The above data table would like this after running the script:
115 A
114 A
113 A
112 A
111 A
110 AZ
109 YZ
108 Z
107 ZA
106 ZAB
105 ZAB
104 ZAB
103 AB
102 AB
101 AB
100 AB
99 AB
98 B
97 B
96 B
95 B
Model: Pro (2012)
AppleScript: 2.5.1
Browser: Safari 537.73.11
Operating System: Mac OS X (10.8)