Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

Recommended Posts

I am trying to build an excel model with several files of 200 MB eahc one and all toghether will reach at least 10 GB size.

 

I can't open more than 500 MB , i have al I7 processor and 16 GB RAM. Does anybody know what version of excel is better?, i began with 2007 , now i just changed to 2010 but i have more problems.

 

When i try to insert a new column excel says there are not sufficient resources, r something like that

 

Should I use the 64 bit version of excel?

 

On the other hand, Windows XP or windows 7?

 

Please i need help

 

Many thanks

Share this post


Link to post
Share on other sites

Maybe try importing your data into an SQL database. Some options to consider are:

 

  • SQL Server Express (free with restrictions) or SQL Server (pay) by Microsoft
  • MySQL by Oracle (free with restrictions)
  • PostgreSQL by an Open Source Community (free with no restrictions)

 

SQL Server Express may be the easiest for you.

 

Make sure you backup your source data!

Share this post


Link to post
Share on other sites

I do not have enough expertise in Excel to answer your question. However, I do have enough experience to communicate that I second the above posters comments that this would be much better suited work for a SQL database. I personally use MS SQL Server for my data repository, and am quite pleased. The other databases the above poster identifies would work as well. Although the code for the statistical math components is more difficult to generate in SQL, the database is very efficient in handling very large data sets. Also, Ad Hoc reporting of your data is very simple using a SQL database. I have a system at work that performs about seven million updates every day on hardware inferior to yours without any issues at all.

 

Best Wishes . . .

Share this post


Link to post
Share on other sites

Many thanks for your comments. I don´t know anything about SQL programming. So which one of these softwares would you recommend to me? how much time do you think it would take to reach the minimum level required to do the same as anyone can do using excel? There is one easer and simple than others at using math formulas.

 

Thank you

Share this post


Link to post
Share on other sites
I am trying to build an excel model with several files of 200 MB eahc one and all toghether will reach at least 10 GB size.

 

I can't open more than 500 MB , i have al I7 processor and 16 GB RAM. Does anybody know what version of excel is better?, i began with 2007 , now i just changed to 2010 but i have more problems.

 

When i try to insert a new column excel says there are not sufficient resources, r something like that

 

Should I use the 64 bit version of excel?

 

On the other hand, Windows XP or windows 7?

 

Please i need help

 

Many thanks

definitely 64 bit of everything --- 64 bit OS, 64 bit excel, lotsa RAM

 

the latest excel can open a million rows of data

Share this post


Link to post
Share on other sites

I think you can continue to use excel by simply adding horsepower to the equation, however in my opinion, it will not do it efficiently and that is why it is necessary to continue to ramp up your hardware. Do not get me wrong, I use excel every single day to perform functions for which it is well suited, but I also know what other systems (databases) do well and rely on them when they are more efficient.

 

To answer your questions:

 

So which one of these softwares would you recommend to me?

 

I have not used all available database software, so I cannot comment on which is the best, and they all do something better than others, but I have chosen MS SQL Server to accomplish my database tasks. It is robust enough for my purposes, and is easy to create databases and tables, import data, manage data, and manipulate this data. It is the one database that is tightly linked to Excel in case you wish to import/exprt data to from excel (which I do).

 

how much time do you think it would take to reach the minimum level required to do the same as anyone can do using excel?

 

I cannot answer this as I do not know what you are doing with Excel. Excel truly does a good job at quickly summarizing data in a mathematical and statistical sense. It has many built in functions to perform this work. I myself have custom code working in my Excel spreadsheets that I find very useful. SQL coding is similar to building custom formulas in excel. The good news is if you do not know how to code in SQL, you can find hundreds of examples on the internet that work with little or no modification. To give you an example, once you learn how to perform basic data manipulation in SQL (which could be accomplished in a day or two (IMO), if you are computer savvy), it takes me about as long to code a custom formula in Excel as it does for me to write SQL code for the formula. The main difference is SQL allows for a lot more flexibility in how my data is displayed and grouped, and it is much more efficient when dealing with large data sets.

 

Is one easier and simple than others at using math formulas.

 

I do not know which one is easier or more simple for math and statistics, as I think each have a similar baseline for achieving this goal. I use MS SQL Server due to it being less complex to perform the functions I require in a simple and efficient manner. We mainly use Oracle at work, and other systems that I work on a weekly basis include PostGres and MySQL, but at the end of the day, I prefer to use MS SQL for my purposes as I can manipulate the data faster (import, export, create databases/tables, etc.) than I can with the other systems. Also, I prefer the GUI of MS SQL, for managing and manipulating data than the other programs, although I am sure others would have a different opinion.

As the previous poster mentioned, the lightweight version of MS SQL is a no cost solution.

 

In the end, you can accomplish what you are looking for on anything from paper and pencil, a spreadsheet, or a database, it just depends on the amount of efficiency you are expecting.

 

Best Wishes . . .

Share this post


Link to post
Share on other sites
I am trying to build an excel model with several files of 200 MB eahc one and all toghether will reach at least 10 GB size.

 

I can't open more than 500 MB , i have al I7 processor and 16 GB RAM. Does anybody know what version of excel is better?, i began with 2007 , now i just changed to 2010 but i have more problems.

 

When i try to insert a new column excel says there are not sufficient resources, r something like that

 

Should I use the 64 bit version of excel?

 

On the other hand, Windows XP or windows 7?

 

Please i need help

 

Many thanks

 

May be time to ditch Excel and move to better suited Statistical Packages. R is one of them. Free and lots of addons.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • AXON Enterprise stock, top of range breakout at https://stockconsultant.com/?AXON
    • FOUR Shift4 Payments stock with a solid breakout above 122.9, from Stocks to Watch at https://stockconsultant.com/?FOUR
    • EBS Emergent Biosolutions stock watch, pullback to 9.9 triple+ support area with bullish indicators at https://stockconsultant.com/?EBS
    • POAI Predictive Oncology stock with a bull flag breakout, target 2 area at https://stockconsultant.com/?POAI
    • Date: 18th February 2025.   UK Unemployment Rate Falls and The Pound Spikes Upwards.     The British Pound spikes upwards against all currencies as the UK releases its employment data. However, the latest employment data release does not give long-term confidence as the UK continues to see a higher possibility of economic stagnation in 2025. Can the GBP maintain momentum?   UK Releases Latest Employment Data! The UK employment data had its positive and negative points. The Monthly Unemployment Claims rose 22,000 which is at a 3 month high, and higher than analysts’ previous expectations. This is known to be negative for the British Pound. However, the UK also saw some positive data which investors are clinging onto. The UK Unemployment Rate fell for the first time since October 2024. The UK Unemployment Rate, to the surprise of analysts, fell from 4.5% to 4.4%. Lastly, the Average UK Salaries Index rose to 6.00%, the highest in 13 months and higher than previous expectations. This is the main reason why the GBP is increasing in value. That said, the Bank of England and economists continue to expect the UK to witness stagnation in 2025.     The British Pound The British Pound is now one of the best-performing currencies of the day so far. The US Dollar and Japanese Yen are also strongly increasing in value. The Governor of the Bank of England, Mr Bailey, is due to speak at 09:30 GMT and is likely to comment on the latest employment data.   Previously, Bailey described the UK’s economic growth as “static,” despite stronger-than-expected Q4 2024 data—0.1% growth instead of the forecasted –0.1% quarterly and 1.4% annually versus the expected 1.1%. Meanwhile, the BoE revised its 2025 GDP growth forecast down to 0.75% from 1.0% in November. Traders are also hoping Governor Bailey will comment on the possible future rate cuts.   Tomorrow at 09:00 (GMT+2), the UK will release January inflation data. Analysts expect the annual CPI to rise from 2.5% to 2.8%, while monthly prices may drop by 0.3% after a similar increase in December. The Core CPI is projected to climb from 3.2% to 3.6%.   When evaluating the GBP Index, the GBP is currently trading 0.95% higher in 2025. However, the upward price movement is largely due to last week’s Gross Domestic Product which beat expectations. The performance of the GBP will also depend on whether the US imposes tariffs. Additionally, pressure on the UK to increase defence spending could further strain the country's already scrutinized budget.   GBPUSD - Technical Analysis and Price Condition The GBPUSD is trading above the main moving averages on the 2-hour timeframe and is trading high on most oscillators. These factors indicate that the buyers are currently controlling momentum, but traders are concerned about two factors. The first is that the GBPUSD is struggling to break above the 1.26300 level and the fact that both the USD and GBP is simultaneously increasing in value. As both currencies are increasing in value, technical analysts view the price action as conflicting. On the 5-minute chart, the GBPUSD is trading at the 200-bar average price movement indicating a neutral signal. This also follows the concerns of traders that the price action is conflicting.     If the price breaks above 1.25918, the GBPUSD may witness sell signals materialize. However, if the price breaks above 1.26200, buy signals may arise which will also be in line with the indications on the 2-hour timeframe.   Key Takeaway Points: GBP rises as the UK employment data lifts GBP, but stagnation concerns remain. UK Salaries hit a 13-month high, boosting the Pound. The Bank of England Governor, Mr Bailey may hint at future rate cuts and advises the UK will witness economic stagnation. The key risks for the GBP remain inflation data, US tariffs, and UK defence spending pressure. Always trade with strict risk management. Your capital is the single most important aspect of your trading business.   Please note that times displayed based on local time zone and are from time of writing this report.   Click HERE to access the full HFM Economic calendar.   Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding of how markets work. Click HERE to register for FREE!   Click HERE to READ more Market news.   Michalis Efthymiou HFMarkets   Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in Leveraged Products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.