Kapalı

Excel 2007 Simple Spreadsheet Lookup and Download - Repost - open to bidding

Overview: Metastock Explorer Spreadsheet.

The attached Excel spreadsheet (Excel 2007) is the second stage in a Stock selection system designed to determine stocks that have reached their Buy Price. The spreadsheet is made up from results of an Exploration using Metastock (an equities charting package) from EOD (End of Day) data downloaded during March. These results are then copied and pasted from Metastock into this spreadsheet. The process is occurs daily after trading is closed. No knowledge of Metastock is required; its’ part in the process is finished at this point.

(For this reason the spreadsheet format must remain as it is with the same column headings and in the same sequence as shown. Any change to the format would require reformatting of the original Metastock results before pasting to the spreadsheet.)

The system relies on any stock breaching the preset Buy Price; ie at some time during the trading day the stock has fallen below the Buy Price. In order to know this the Low for the current day must be downloaded from Yahoo Finance and compared to the Buy Price for that particular stock. The stock suffix for the Australian Stock Exchange by Yahoo is .AX, so BHP must be rendered as [url removed, login to view] in order that it is managed correctly by the Yahoo Finance download. Only ASX stocks are ever used; there is no necessity to cater for other exchanges.

In the event that the Low has been breached conditional formatting is required to indicate that the breach has occurred. The stock in question will then be deleted from the system. Only about 1 in 7 stocks actually do fall to reach their Buy Price. In the current worksheet two have been highlighted to clarify the requirements but these figures are false and placed there by way of illustration. When you run a test you will see that they have been fudged.

The benefit rendered by spreadsheet is that the system is automatic. The alternative is to download each ‘Low’ at EOD separately or to examine each of 30 something charts and both are tedious. Once a week the spreadsheet is tidied up and those stocks that no longer meet the criteria are removed.

Specific requirements:

1. Insert the suffix .AX to each stock symbol when downloading data from Yahoo.

2. Write an Excel Look-up macro suitable for use with Yahoo Finance EOD data and include a download button on the spreadsheet.

3. Download the day’s Low for each stock and Update the Low Value.

4. Where the Low for the day has fallen below the BuyPrice highlight the cell.

I shall be happy to answer any queries.

Charles Brodley.

Beceriler: Powerpoint, Sosyal Medya Pazarlaması, Twitter, Web Scraping, WordPress

Daha fazlasını gör: website design, wordpress, visual basic for apps, microsoft excel

İşveren Hakkında:
( 0 değerlendirme ) Mansoura, Egypt

Proje NO: #13598669

Bu iş için 22 freelancer ortalamada £179 teklif veriyor

sapotacorp

Hi hamedezat. I have read 4 requires in your project. I have finish them quickly. Let's contact me to discuss further details.. Q

£225 GBP in 6 gün içinde
(720 Değerlendirme)
8.2
shinemonkey212

I Will Give You Successful Sites and Many Helps!!! Hello, how are you? I'm glad to tell you about your project. As you can see at my profile, i am a WordPress Expert and have great skills and solid experiences for y Daha Fazla

£150 GBP in 3 gün içinde
(93 Değerlendirme)
7.2
mantislin

Hi sir, This is kimi and I am scraping expert, I have did too many scraping projects, please check my profile page then you will know. https://www.freelancer.com/u/mantislin.html Can you tell me Daha Fazla

£178 GBP in 5 gün içinde
(222 Değerlendirme)
7.3
ethancoder1

Hi, Dear Employer Thanks for reviewing my cover letter. I am Ethan more than 5 years experienced in PHP / MYSQL /Oracle/ Plsql/ java/ Jsp/ Jsf /Servlet/ RMI/ AJAX /JQUERY / JAVASCRIPT / CSS3 / HTML / HTML5 / wordpre Daha Fazla

£133 GBP in 3 gün içinde
(81 Değerlendirme)
6.1
schoudhary1553

Bid Summmary Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.

£250 GBP in 3 gün içinde
(13 Değerlendirme)
5.6
axiomswb

We have expertise in Excel VBA, Data [login to view URL] main motto is to provide client satisfaction for long term relationship.

£100 GBP in 2 gün içinde
(12 Değerlendirme)
4.6
dezines99

Hi, Expert here,ready to start immediately. I will always available to discuss project specs.I have reviewed all your requirements and can deliver exactly what you are looking for, 100% guaranteed. I am confident to Daha Fazla

£250 GBP in 0 gün içinde
(17 Değerlendirme)
4.3
akrontechnohub

Hi There! I read your requirement,you are Looking for web development . We have good professional development team with 5+ years experience for WordPress Development. I hope we are perfect for your requirement Daha Fazla

£70 GBP in 3 gün içinde
(10 Değerlendirme)
4.2
overtservices

Bid Summmary Hello, I have 4+ years of experience in WordPress and I have skills you’re looking for. Kindly revert so that we can discuss on the project and I can analyse your requirement. Thank you. Relevant Experie Daha Fazla

£150 GBP in 5 gün içinde
(4 Değerlendirme)
3.5
XpertSolNet

Hi Dear, I have gone through the complete job description. Please share further details so I can start working on it. I have great expertise in Powerpoint, Social Media Marketing, Twitter, Web Scraping, WordPress. Daha Fazla

£250 GBP in 3 gün içinde
(1 Yorum)
0.9
vl16vaidya

A proposal has not yet been provided

£222 GBP in 10 gün içinde
(2 Değerlendirme)
0.9
SilentStarMagic

Hi, I am a serious developer who aims to provide high quality services. If you contact me, we can discuss more things detail and will be achieved with each other's purpose. Good luck for your business…

£150 GBP in 2 gün içinde
(0 Değerlendirme)
0.0
£150 GBP in 3 gün içinde
(0 Değerlendirme)
0.0
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Daha Fazla

£150 GBP in 3 gün içinde
(0 Değerlendirme)
2.0
vw7571960vw

I have the experience to start contributing from day one and I am truly excited about the prospect of getting started

£150 GBP in 3 gün içinde
(0 Değerlendirme)
0.0
RubyOnRail

Hello, It's a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work on customization part if we can proceed towards more discussion. I have gone through your project Daha Fazla

£277 GBP in 3 gün içinde
(0 Değerlendirme)
0.0
Shopify

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further Daha Fazla

£257 GBP in 3 gün içinde
(0 Değerlendirme)
3.4
iyapraji

A proposal has not yet been provided

£250 GBP in 7 gün içinde
(0 Değerlendirme)
0.0
aangelo01

I know to use excel, word and some editing. I will do whatever it takes to get the job well done on the quickest time. My clients satisfaction is always important.

£150 GBP in 3 gün içinde
(0 Değerlendirme)
0.0
mrchambers

I have completed many Excel VBA projects over the last 20 years, including web scraping / API integrations, and will use a third party library ( [login to view URL] ) to provide reliable web data retri Daha Fazla

£160 GBP in 3 gün içinde
(0 Değerlendirme)
0.0