Existing Excel vsto c# program to show stock alert on Excel worksheet.back-testing stock trading strategies
$30-5000 USD
Cancelled
Posted over 11 years ago
$30-5000 USD
Paid on delivery
Excel workbook(see attached [login to view URL]) has mutiple worksheet,
Need to get stock data from Yahoo finance web page, and update stock price on the worksheet and create new worksheet to show alert stock info.
Refer to Worksheet Yrh0x00120T0160UDFY06 stock,symbol ANTH(A2) price in (F2) is higher then High(C2) will show the stock info in worksheet Yrh0x00120T0160UDFY06-alert.
inside Yrh0x00120T0160UDFY06-alert will have several named-range. the number of named-range is dynamically created based on following PerctEnum.
if the stock percent is between 5-9 percent, it will show on Perct_0050_0090 range.
public enum PerctEnum
{
Perct_000000000,
Perct_0990N0130,
Perct_0130N0090,
Perct_0090N0050,
Perct_0050N0000,
Perct_0000_0020,
Perct_0020_0050,
Perct_0050_0090,
Perct_0090_0130,
Perct_0130_0200,
Perct_0200_0999
}
the format of stock data showen on the Perct_0050_0090 range is as following:
Symbol/Price/Chane/Change Percent/Volume (refer to A2,F2,G2,H2,E2 in Yrh0x00120T0160UDFY06).
the number of row will be 12.
I will provide Existing Excel vsto c# example code to retrive stock data from yahoo web page.
Seller's solution must have vsto install/uninstall.