Klartigue
08-31-2011, 11:16 AM
Now its getting a little more complicated.
Is there any way I can write a macro that opens a file in a program called Axys. Then it searches for certain cusips within that file, gets the price, and pastes it into a cell in excel?
For example:
Item Cusip Price EVAL Spread
A1 34281QBU 111.379 ----
cover 34281QBU 111.034
A2 66285WGF 102.397 ----
cover 66285WGF 102.395
A3 70914PPF 110.2 ----
cover 70914PPF 109.798
I want to be able to pull prices from a file in a program called Axys and have the prices pasted into the cells where the --- is.
Before attmepting this, is there a way to write a macro that opens a price file in axys, searches for each of the cusip, finds the eval, and pastes it in the --- space? and from there i would subtract the existing price - eval from axys place it in the spread column.
Thanks!
Is there any way I can write a macro that opens a file in a program called Axys. Then it searches for certain cusips within that file, gets the price, and pastes it into a cell in excel?
For example:
Item Cusip Price EVAL Spread
A1 34281QBU 111.379 ----
cover 34281QBU 111.034
A2 66285WGF 102.397 ----
cover 66285WGF 102.395
A3 70914PPF 110.2 ----
cover 70914PPF 109.798
I want to be able to pull prices from a file in a program called Axys and have the prices pasted into the cells where the --- is.
Before attmepting this, is there a way to write a macro that opens a price file in axys, searches for each of the cusip, finds the eval, and pastes it in the --- space? and from there i would subtract the existing price - eval from axys place it in the spread column.
Thanks!